Skip to main content
Gets a list of all columns belonging to the sheet specified in the URL.
External DocumentationTo 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

{
	"pageNumber": 2,
	"pageSize": 123,
	"totalPages": 0,
	"totalCount": 6,
	"data": [
		{
			"id": 20094019768540,
			"version": 0,
			"index": 0,
			"title": "<string>",
			"type": "<string>",
			"primary": true,
			"validation": false,
			"width": 151
		},
		{
			"id": 918564532466900,
			"version": 0,
			"index": 1,
			"title": "<string>",
			"type": "<string>",
			"validation": false,
			"width": 33
		}
	]
}

​
Workflow Library Example

List Columns with Smartsheet and Send Results Via Email
Workflow LibraryPreview this Workflow on desktop
⌘I