EndPoint Delete Sheet Rows

Contents

1 Label
2 Description
3 Parameters
4 Output Columns
5 Input Columns

Name

delete_sheet_rows

Description

Delete rows from a Sheet by row IDs. [API reference]

Parameters

Parameter

Label

Required

Options

Description

SheetId

YES

Row Id(s) - Comma separated

YES

Restrict results to records specified by a comma-separated list of IDs. Max IDs per request controlled by BatchSize property (found in Pagination template)

IgnoreRowsNotFound

Ignore If Rows Not Found

Option	Value
true	true
false	false

If set to false and any of the specified row Ids are not found, no rows are deleted, and the 'not found' error is returned.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
Id	`DT_I8`	`bigint`		False
BatchMessage	`DT_WSTR`	`nvarchar(4000)`	4000	False
BatchResultCode	`DT_I4`	`int`		False
HttpStatusCode	`DT_I4`	`int`		False

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
Id	`DT_I8`	`bigint`		False

Required columns that you need to supply are bolded.