API ReferenceToolsSheets

Get Table

Beta
Retrieve table data from an Athena spreadsheet.

Authentication

X-API-KEYstring
API Key authentication via header
OR
AuthorizationBearer

Bearer authentication of the form Bearer <token>, where token is your auth token.

Request

This endpoint expects an object.
asset_idstringRequired
The ID of the spreadsheet asset
table_namestringRequired
Table name to retrieve
table_idstring or nullOptional
Table ID to retrieve

Response

Successful Response
asset_idstring
The ID of the spreadsheet asset
columnslist of maps from strings to strings
Array of column objects with name and other metadata
messagestring
Success message or error description
rowslist of maps from strings to any
Array of row objects with column names as keys
successboolean
Whether the operation was successful

Errors