POST /sheets/{sheetId}/rows/copy

Copies rows from the sheet specified in the URL to (the bottom of) another sheet.

Servers

Request headers

Name Type Required Description
Content-Type String Yes The media type of the request body.

Default value: "application/json"

Query parameters

Name Type Required Description
include String No

A comma-separated list of row elements to copy in addition to the cell data:

  • all - specify a value of all to include everything (attachments, children, and discussions).
  • attachments
  • children - if specified, any child rows of the rows specified in the request are also copied to the destination sheet, and parent-child relationships amongst rows are preserved within the destination sheet; if not specified, only the rows specified in the request are copied.
  • discussions

Possible values:

  • "children"
  • "discussions"
  • "attachments"
  • "all"
ignoreRowsNotFound Boolean No

true or false: default is false. If set to true, specifying row Ids that do not exist within the source sheet does not cause an error response. If omitted or set to false, specifying row Ids that do not exist within the source sheet causes an error response (and no rows are copied).

Default value: false

Request body fields

Name Type Required Description
to No
rowIds[] Array No

The Ids of the rows to move or copy from the source sheet.

How to start integrating

  1. Add HTTP Task to your workflow definition.
  2. Search for the API you want to integrate with and click on the name.
    • This loads the API reference documentation and prepares the Http request settings.
  3. Click Test request to test run your request to the API and see the API's response.