List Columns - BlinkOps Documentation

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

External DocumentationTo learn more, visit the Smartsheet documentation.

Parameters

Parameter	Description
Include All	If true, include all results, that is, do not paginate. Mutually exclusive with page and pageSize (they are ignored if includeAll=true is specified).
Level	specifies whether multi-contact data is returned in a backwards-compatible, text format (level=0, default) or as multi-contact data (level=1).
Page	Which 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 Size	The 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 ID	Sheet 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

Preview this Workflow on desktop