Projects

Query project warehouse data

Runs a bounded read-only SQL query using the caller’s short-lived warehouse session. maxRows is capped at 1000; check truncated before interpreting results.

post/api/v1/project-rooms/{id}/warehouse/query

Request

  • Base URL: https://askthegrid.com
  • URL: https://askthegrid.com/api/v1/project-rooms/{id}/warehouse/query
  • Auth: HTTP bearer

Path parameters

idstring required

Request body

sqlstring required
maxRowsinteger

Response

Success

organizationIdstring uuid required
columnsstring[] required
elapsedMsnumber required
truncatedboolean required
sqlstring required
queriedAtstring date-time required

Changes

No recorded changes to this operation across all 1 revision of this API.