Run a read-only SQLite query

Execute one SELECT, WITH, or EXPLAIN statement against the active project's SQLite database. Results are capped at 100 rows. Bound parameters use SQLite question-mark placeholders.

Authorization

BearerAuth

AuthorizationBearer <token>

Project-scoped user API key

In: header

Request Body

application/json

TypeScript Definitions

Use the request body type in TypeScript.

sql*string

Length1 <= length <= 20000

params?array<string|number|boolean>

Itemsitems <= 100

maxRows?integer

Range1 <= value <= 100

Default100

Response Body

`application/json`

Request Examples

bash

curl -X POST "https://api.pdfparse.net/sql/query" \
  -H "Content-Type: application/json" \
  -d '{
    "sql": "string"
  }'

Response Samples

application/json

{
  "columns": [
    "string"
  ],
  "rows": [
    {
      "property1": null,
      "property2": null
    }
  ],
  "rowCount": 0,
  "maxRows": 0,
  "truncated": true,
  "durationMs": 0,
  "rowsRead": 0
}

Authorization

Request Body

Response Body

200application/json

401application/json

403application/json

404application/json

500application/json

`application/json`

`application/json`

`application/json`

`application/json`

`application/json`