Get Table | Athena | API Reference Docs

Retrieve table data from an Athena spreadsheet.

Authentication

X-API-KEYstring

API Key authentication via header

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

row_limit_appliedbooleanDefaults to false

True when the table exceeded the server row-read limit and only the first N rows were returned. Narrow the range or query via SQL with a LIMIT to read more.

Errors

422

Unprocessable Entity Error

$	curl -X POST https://api.athenaintel.com/api/v0/tools/sheets/table/get \
>	-H "X-API-KEY: <apiKey>" \
>	-H "Content-Type: application/json" \
>	-d '{
>	"asset_id": "string",
>	"table_name": "string"
>	}'

1	{
2	"asset_id": "string",
3	"columns": [
4	{}
5	],
6	"message": "string",
7	"rows": [
8	{}
9	],
10	"success": true,
11	"row_limit_applied": false
12	}