Read rows from database table | Athena

Query rows from a table in the database. Supports filtering, ordering, and pagination using PostgREST-style query parameters. **Filter Syntax:** - `?column=eq.value` - Equal - `?column=neq.value` - Not equal - `?column=gt.value` - Greater than - `?column=gte.value` - Greater than or equal - `?column=lt.value` - Less than - `?column=lte.value` - Less than or equal - `?column=like.*pattern*` - LIKE (case-sensitive) - `?column=ilike.*pattern*` - ILIKE (case-insensitive) - `?column=in.(a,b,c)` - IN list - `?column=is.null` - IS NULL

Query rows from a table in the database. Supports filtering, ordering, and pagination using PostgREST-style query parameters.

Filter Syntax:

?column=eq.value - Equal
?column=neq.value - Not equal
?column=gt.value - Greater than
?column=gte.value - Greater than or equal
?column=lt.value - Less than
?column=lte.value - Less than or equal
?column=like.*pattern* - LIKE (case-sensitive)
?column=ilike.*pattern* - ILIKE (case-insensitive)
?column=in.(a,b,c) - IN list
?column=is.null - IS NULL

Authentication

X-API-KEYstring

API Key authentication via header

AuthorizationBearer

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

Path parameters

asset_idstringRequired

table_namestringRequired

Query parameters

selectstring or nullOptional

Columns to return (comma-separated, e.g., ‘id,name,email’)

orderstring or nullOptional

Order by clause (e.g., ‘created_at.desc’, ‘name.asc’)

limitintegerOptional1-1000Defaults to 100

Maximum number of rows to return

offsetintegerOptional>=0Defaults to 0

Number of rows to skip

Response

Successful Response

datalist of maps from strings to any

Array of row objects

Errors

400

Bad Request Error

403

Forbidden Error

404

Not Found Error

422

Unprocessable Entity Error

501

Not Implemented Error

503

Service Unavailable Error

Query rows from a table in the database. Supports filtering, ordering, and pagination using PostgREST-style query parameters.

Filter Syntax:

?column=eq.value - Equal
?column=neq.value - Not equal
?column=gt.value - Greater than
?column=gte.value - Greater than or equal
?column=lt.value - Less than
?column=lte.value - Less than or equal
?column=like.*pattern* - LIKE (case-sensitive)
?column=ilike.*pattern* - ILIKE (case-insensitive)
?column=in.(a,b,c) - IN list
?column=is.null - IS NULL

API Key authentication via header

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

Columns to return (comma-separated, e.g., ‘id,name,email’)

Order by clause (e.g., ‘created_at.desc’, ‘name.asc’)

Maximum number of rows to return

Number of rows to skip

Array of row objects

1	{
2	"data": [
3	{
4	"email": "alice@example.com",
5	"id": 1,
6	"name": "Alice"
7	},
8	{
9	"email": "bob@example.com",
10	"id": 2,
11	"name": "Bob"
12	}
13	]
14	}

1	{
2	"data": [
3	{
4	"email": "alice@example.com",
5	"id": 1,
6	"name": "Alice"
7	},
8	{
9	"email": "bob@example.com",
10	"id": 2,
11	"name": "Bob"
12	}
13	]
14	}

$	curl https://api.athenaintel.com/api/v0/databases/asset_id/data/table_name \
>	-H "X-API-KEY: <apiKey>"