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

Request

Base URL
//api.gigasheet.com (relative, and the document’s source URL is not known)
Auth
API key in header X-GIGASHEET-TOKEN
TypeScript
https://skmtc.dev/freshdesk/apis/gigasheet-api/docs/dataset/:handle/append/from-sheet/:from-handle/by-name/post.ts
A function with typed inputs. Its response is checked against the schema.

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

Messagestring

Successboolean

Changes

No recorded changes to this operation across all 1 revision of this API.