Data Query

Query Table

get

https://internal-api.platform.amigo.aihttps://api.platform.amigo.ai

/v1/{workspace_id}/query/{schema}/{table}

Query a table with PostgREST-style filtering, sorting, and pagination.

Authorizations

BearerAuth

AuthorizationstringRequired

API key issued via POST /v1/{workspace_id}/api-keys. Pass the returned api_key value as a Bearer token.

Path parameters

schemastringRequired

tablestringRequired

Query parameters

selectany ofOptional

stringOptional

or

nullOptional

orderany ofOptional

stringOptional

or

nullOptional

limitinteger · min: 1 · max: 100OptionalDefault: 20

offsetintegerOptionalDefault: 0

semanticany ofOptional

Semantic search query (uses pgvector cosine similarity)

stringOptional

or

nullOptional

Responses

200

Successful Response

application/json

countintegerRequired

has_morebooleanRequired

422

Validation Error

application/json

get

/v1/{workspace_id}/query/{schema}/{table}

HTTPcURLJavaScriptPython

GET /v1/{workspace_id}/query/{schema}/{table} HTTP/1.1
Host: internal-api.platform.amigo.ai
Authorization: Bearer YOUR_SECRET_TOKEN
Accept: */*

{
  "items": [
    {
      "ANY_ADDITIONAL_PROPERTY": "anything"
    }
  ],
  "count": 1,
  "has_more": true
}