SSIS Components for Smartsheet

Build 24.0.9062

Info_Cells

Query Smartsheet Cells. A collection of Cells comprises each Row in a Sheet.

Table Specific Information

Select

This view returns details for Cells of a specified Row. The SheetId and RowId parameters are always required.

Retrieve Cells.

SELECT * FROM Info_Cells WHERE SheetId = '2940085806098308' AND RowId = '6773684447799172'

Columns

Name Type References Description
Id [KEY] String The Id of the column that the cell is located in.
Value String The value of the cell. A string, a number, or a boolean value.
DisplayValue String Visual representation of cell contents as presented to the user in the UI.
ColumnType String The type definition on the Column object.
Formula String The formula for a cell, if set.
Format String The format descriptor.
ConditionalFormat String The format descriptor describing the conditional formatting of the cell.
Strict Boolean Set to false to enable lenient parsing. Defaults to true. This attribute can be specified in a request, but will never be present in a response.
SheetId String The sheet Id.
RowId String The row Id.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062