EndPoint Update Sheet Data (Overwrite Cells)

Name

update_sheet_data

Description

Update data to spreadsheet on desired tab / cell location (i.e. start/end range). Limit is 10MB per request. [API reference]

Parameters

Parameter

Label

Required

Options

Description

Range

Range for Table Boundary (Including Header)

YES

Enter Range to detect Table column names and datatypes. Example: enter A1:C if you have table of 3 columns starting from Cell A1

WriteRange

Range for Data Cells

YES

Cell Range which needs to be update. Example: Enter A2 if you like to start update from cell A2

TabName

If you have multiple tabs on your spreadsheet then you can specify here. By default first tab is used if you do not enter.

valueRenderOption

Option	Value
FORMATTED_VALUE	FORMATTED_VALUE
UNFORMATTED_VALUE	UNFORMATTED_VALUE
FORMULA	FORMULA

valueInputOption

Option	Value
USER_ENTERED	USER_ENTERED
RAW	RAW

majorDimension

Option	Value
DIMENSION_UNSPECIFIED	DIMENSION_UNSPECIFIED
COLUMNS	COLUMNS
ROWS	ROWS

dateTimeRenderOption

Option	Value
SERIAL_NUMBER	SERIAL_NUMBER
FORMATTED_STRING	FORMATTED_STRING

SpreadSheetId

Option	Value
Enter Your Sheet Id
Example Sheet Id	1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

Enter unique spreadsheet Id. To obtain sheet Id. Open spreadsheet in browser and check URL. You will example value like 1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms that is your sheet id.

Output Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw
spreadsheetId	`DT_WSTR`	`nvarchar(100)`	100	`False`
updatedRange	`DT_WSTR`	`nvarchar(255)`	255	`False`
updatedRows	`DT_I4`	`int`		`False`
updatedColumns	`DT_I4`	`int`		`False`
updatedCells	`DT_I4`	`int`		`False`

Input Columns

Label	Data Type (SSIS)	Data Type (SQL)	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.

Examples

SSIS

Use Google Sheets Connector in API Source component to read data or in API Destination component to read/write data:

Update rows in [Dynamic Table] table using API Destination

This EndPoint belongs to [Dynamic Table] table, therefore you cannot work with it directly. Use this table and table-operation pair instead:

Google Sheets

[Dynamic Table]

Update