Get dataset data

GET 
/datasets/:id/data

Returns paginated row-level data for an internal dataset. The caller must have at least read-only access. Only datasets with DatasetType "internal" are supported (external/view returns IPV-1041).

Normal mode (no action param): Executes SQL queries against Athena (s3athena/lf targets) or Redshift. Supports filtering via filter_condition (Lucene-like syntax) and sorting via sortField / sortOrder.

Spatial mode (action=get_spatial_data): Fetches spatially converted data for datasets with DataCategory "spatial". Returns a different response shape with spatial_columns, spatial_crs, and string-based next_available.

Pagination: Use limit and offset. Default limit is 1000 (max 1000). Check nextStart.nextAvailable (boolean) to determine if more pages exist; use nextStart.nextOffset as the next offset value.

Request

Responses

200

Dataset data retrieved successfully.

Response Headers

Access-Control-Allow-Origin
Access-Control-Allow-Methods
Access-Control-Allow-Headers

400

Validation error — dataset not found, user not authorized, invalid DatasetType, or bad filter/sort/limit/offset values.

Response Headers

Access-Control-Allow-Origin
Access-Control-Allow-Methods
Access-Control-Allow-Headers

500

Internal server error or query timeout

Response Headers

Access-Control-Allow-Origin
Access-Control-Allow-Methods
Access-Control-Allow-Headers