EndPoint Get Sheet Fields

Contents

Name

get_sheet_fields

Get Sheet fields by Sheet ID. [API Help]

Parameter	Label	Required	Options	Description
SheetId	SheetId	YES
ColumnIds	Column Ids (Default=All Columns)	NO		A comma-separated list of column ids. The response contains only the specified columns in the columns array, and individual rows' cells array only contains cells in the specified columns.

Label	DataType	Length	Raw
Id	DT_I8	0	False
Version	DT_I4	0	False
Index	DT_I4	0	False
Title	DT_WSTR	100	False
Type	DT_WSTR	50	False
Width	DT_I4	0	False
SystemColumnType	DT_WSTR	100	False
ContactOptionsName	DT_WSTR	500	False
ContactOptionsEmail	DT_WSTR	500	False
Options	DT_WSTR	500	False
Description	DT_WSTR	1000	False
Validation	DT_BOOL	0	False
AutoNumberFormatPrefix	DT_WSTR	100	False
AutoNumberFormatFill	DT_WSTR	50	False
AutoNumberFormatSuffix	DT_WSTR	100	False
Format	DT_WSTR	100	False
Symbol	DT_WSTR	50	False
Primary	DT_BOOL	0	False
Locked	DT_BOOL	0	False
LockedForUser	DT_BOOL	0	False

Label	DataType	Length	Raw	Description
There are no Static columns defined for this endpoint. This endpoint detects columns dynamically at runtime.