EndPoint Get Sheet Row by ID(s)
Name
get_sheet_rows_by_ids
Description
Get a Sheet by ID(s). [API reference]
Parameters
Output Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Id |
DT_I8
|
bigint
|
False |
||
| CreatedAt |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| ModifiedAt |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| CreatedAtLocalTime |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| ModifiedAtLocalTime |
DT_DBTIMESTAMP
|
datetime
|
False |
||
| RowNumber |
DT_I4
|
int
|
False |
Row number | |
| [$parent.title$] |
DT_WSTR
|
nvarchar(2000)
|
2000 | False |
|
| PrevRowId |
DT_I8
|
bigint
|
False |
Input Columns
| Label | Data Type (SSIS) | Data Type (SQL) | Length | Raw | Description |
|---|---|---|---|---|---|
| Id |
DT_I8
|
bigint
|
False |
Examples
SSIS
Use Smartsheet Connector in API Source component to read data or in API Destination component to read/write data:
Get Sheet Row by ID(s) using API Source
Get Sheet Row by ID(s) using API Destination
ODBC application
Use these SQL queries in your ODBC application data source:
Get Sheet Rows by Id(s) (single or multiple)
This example shows how to list multiple Sheet Rows by its Id(s). Supply Comma Separated List of Row IDs (Upto 100 recommended). You can also supply Row Number(s) instead of ID(s). If you supply both Id(s) and Row Number(s) then only common rows are selected.
SELECT * FROM get_sheet_rows_by_ids
WITH (
SheetId=3482072521854852
, Id='1312208360476548,6941707894689668,5815807987847044'
--OR-- (If you supply both Id and RowNumber then only Common Rows selected
--, RowNumber='1,2,100'
)Get sheet rows by row number(s) (single or multiple)
This example shows how to list multiple Sheet Rows by its Row Number(s). Supply Comma Separated List of Row Numbers (Upto 100 recommended). You can also supply Row Id instead of Row Number(s). If you supply both Id(s) and Row Number(s) then only common rows are selected.
SELECT * FROM get_sheet_rows_by_ids
WITH (
SheetId=3482072521854852
, RowNumber='1,2,100'
--OR-- (If you supply both Id and RowNumber then only Common Rows selected
--, Id='1312208360476548,6941707894689668,5815807987847044'
)SQL Server
Use these SQL queries in SQL Server after you create a data source in Data Gateway:
Get Sheet Rows by Id(s) (single or multiple)
This example shows how to list multiple Sheet Rows by its Id(s). Supply Comma Separated List of Row IDs (Upto 100 recommended). You can also supply Row Number(s) instead of ID(s). If you supply both Id(s) and Row Number(s) then only common rows are selected.
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_sheet_rows_by_ids
WITH (
SheetId=3482072521854852
, Id=''1312208360476548,6941707894689668,5815807987847044''
--OR-- (If you supply both Id and RowNumber then only Common Rows selected
--, RowNumber=''1,2,100''
)';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_SMARTSHEET_IN_DATA_GATEWAY];Get sheet rows by row number(s) (single or multiple)
This example shows how to list multiple Sheet Rows by its Row Number(s). Supply Comma Separated List of Row Numbers (Upto 100 recommended). You can also supply Row Id instead of Row Number(s). If you supply both Id(s) and Row Number(s) then only common rows are selected.
DECLARE @MyQuery NVARCHAR(MAX) = 'SELECT * FROM get_sheet_rows_by_ids
WITH (
SheetId=3482072521854852
, RowNumber=''1,2,100''
--OR-- (If you supply both Id and RowNumber then only Common Rows selected
--, Id=''1312208360476548,6941707894689668,5815807987847044''
)';
EXEC (@MyQuery) AT [LINKED_SERVER_TO_SMARTSHEET_IN_DATA_GATEWAY];