Query a database

Error

A valid request URL is required to generate request examples

{
  "columns": [
    "<string>"
  ],
  "rows": [
    [
      "<unknown>"
    ]
  ],
  "rowCount": 123
}

{
  "error": "<string>",
  "details": [
    "<unknown>"
  ],
  "message": "<string>"
}

{
  "error": "<string>",
  "details": [
    "<unknown>"
  ],
  "message": "<string>"
}

{
  "error": "<string>",
  "details": [
    "<unknown>"
  ],
  "message": "<string>"
}

{
  "error": "<string>",
  "details": [
    "<unknown>"
  ],
  "message": "<string>"
}

POST

api

databases

{databaseId}

query

Error

A valid request URL is required to generate request examples

{
  "columns": [
    "<string>"
  ],
  "rows": [
    [
      "<unknown>"
    ]
  ],
  "rowCount": 123
}

{
  "error": "<string>",
  "details": [
    "<unknown>"
  ],
  "message": "<string>"
}

{
  "error": "<string>",
  "details": [
    "<unknown>"
  ],
  "message": "<string>"
}

{
  "error": "<string>",
  "details": [
    "<unknown>"
  ],
  "message": "<string>"
}

{
  "error": "<string>",
  "details": [
    "<unknown>"
  ],
  "message": "<string>"
}

Authorization

string

header

required

Use your Anything API key as the Basic auth username and leave the password empty. Example credentials: anything_xxx:

databaseId

string<uuid>

required

application/json

sql

string

required

Minimum string length: 1

Query results

columns

string[]

required

rows

any[][]

required

rowCount

number

required

⌘I