Workbooks
List columns for a workbook element
This endpoint retrieves a list of columns associated with a specific element within a workbook. It provides metadata about each column, such as name and formula, which can be essential for understanding the data structure and for further data manipulation or analysis.
Usage notes
- Retrieve the workbookId by calling the /v2/workbooks endpoint.
- Retrieve the elementId by first calling the /v2/workbooks/{workbookId}/pages endpoint, then calling the /v2/workbooks/{workbookId}/pages/{pageId}/elements endpoint.
Usage scenarios
- Data exploration: Helps users to explore the data structure of a workbook element, facilitating deeper analysis and understanding.
- Integration tasks: Useful for developers integrating Sigma with other tools, needing to know the data structure to map data accurately.
Best practices
- Validate the elementId to make sure it corresponds to the correct workbook element before querying.
- Leverage this endpoint when setting up interfaces that require specific knowledge about the data structure.
get/v2/workbooks/{workbookId}/elements/{elementId}/columns
Request
- Base URLhttps://api.sigmacomputing.com
- AuthHTTP bearer
Path parameters
workbookIdstring required
Unique identifier of the workbook.
elementIdstring required
Unique identifier of the workbook element.
Query parameters
pagestring
Use to specify further pages using the string returned in the nextPage portion of the response.
limitnumber double
Number of results to return per page, with a maximum of 1,000 per request. Use the page option in subsequent requests to retrieve the next set of results.
Response
The response body.
Changes
No recorded changes to this operation across all 1 revision of this API.