Execute SQL get query

POST https://data.jetadmin.io/projects/{{project_id}}/prod/{{resource_name}}/sql_get_query

Replace the double-brace placeholders with your identifiers. The interactive endpoint below uses standard OpenAPI path parameters.

Use SELECT queries supported by your resource's SQL engine. In the example query, replace {{model_id}} with the actual SQL table name; a model API identifier may differ from the SQL table name.

Execute SQL get query

post

Executes a query using the resource SQL engine syntax. Only SELECT queries are allowed.

Authorizations

AuthorizationstringRequired

Static API token for the selected resource, passed directly in the Authorization header. Use the token and auth format shown by the resource API.

Path parameters

project_idstringRequired

Project identifier. Replace {{project_id}} with your project identifier.

resource_namestringRequired

Connected resource API name. Replace {{resource_name}} with your resource name.

Body

querystringRequired

SQL query using the resource SQL engine syntax. Must be a SELECT query.

Responses

200

SQL query result rows.

application/json

400

Invalid request parameters or body.

application/json

401

Missing or invalid API token.

application/json

post/projects/{project_id}/prod/{resource_name}/sql_get_query

POST /projects/{project_id}/prod/{resource_name}/sql_get_query HTTP/1.1
Host: data.jetadmin.io
Authorization: YOUR_API_KEY
Content-Type: application/json
Accept: */*
Content-Length: 54

{
  "query": "SELECT id, name FROM {{model_id}} LIMIT 10"
}

{
  "results": [
    {
      "id": 1001,
      "name": "Record name"
    },
    {
      "id": 1002,
      "name": "Second record name"
    }
  ]
}