Sign in

v1

latestOpenAPI 3.0.02026-07-14184214216.1 KB
data

Append to a sheet data from another sheet

Append data from a source sheet to the target sheet. Uses column names rather than ids. Matches columns from the source sheet to the target sheet based on column names.

post/dataset/{handle}/append/from-sheet/{from-handle}/by-name

Path parameters

handlestring required

Handle of the target sheet

from-handlestring required

Handle of the source sheet

Request body

add_unmatched_columnsboolean

Whether to add any unmatched source sheet columns as new columns in the target sheet.

case_insensitiveboolean

Whether to ignore letter case in column names.

trim_column_namesboolean

Whether to ignore leading and trailing spaces in column names.

Response

OK

Messagestring
Successboolean