​
List Columns

Gets a list of all columns belonging to the sheet specified in the URL.

External Documentation

To learn more, visit the Smartsheet documentation.

​
Parameters

ParameterDescription
Include AllIf true, include all results, that is, do not paginate. Mutually exclusive with page and pageSize (they are ignored if includeAll=true is specified).
Levelspecifies whether multi-contact data is returned in a backwards-compatible, text format (level=0, default) or as multi-contact data (level=1).
PageWhich page to return. Defaults to 1 if not specified. If you specify a value greater than the total number of pages, the last page of results is returned.
Page SizeThe maximum number of items to return per page. Unless otherwise stated for a specific endpoint, defaults to 100. If neither pageSize nor page is specified, returns all rows in the sheet. If only page is specified, defaults to a page size of 100.
Sheet IDSheet ID of the sheet being accessed.

​
Example Output

{
	"data": [
		{
			"id": 0,
			"index": 0,
			"symbol": "When applicable for **CHECKBOX** or **PICKLIST** column types. See [Symbol Columns](../../tag/columnsRelated#section/Column-Types/Symbol-Columns).",
			"title": "Column title.",
			"type": "See [Column Types](../../tag/columnsRelated#section/Column-Types)",
			"validation": false
		}
	],
	"pageNumber": 1,
	"pageSize": 50,
	"totalCount": 136,
	"totalPages": 25
}

​
Workflow Library Example

List Columns with Smartsheet and Send Results Via Email

Preview this Workflow on desktop

Was this page helpful?

Get RowList Search Sheet