connector

JSON over HTTP

Turn any JSON API endpoint into a queryable source.

Connection fields

Field	Required	Description
`url`	Yes	URL of the JSON endpoint to fetch.
`user`	No	Username, for HTTP basic auth.
`password`	No	Password, for HTTP basic auth.

There's no real query language here — whatever's typed into the query editor is ignored entirely. Every run just re-fetches url and returns whatever it received (an array of objects becomes rows; a single object becomes one row).

Example configuration

{
  "url": "https://api.example.com/v1/orders.json",
  "user": "",
  "password": ""
}

Example response

GET https://api.example.com/v1/orders.json

[
  { "id": 1042, "customer": "Acme Co", "total": 249.99, "status": "paid" },
  { "id": 1043, "customer": "Globex",  "total": 89.50,  "status": "pending" }
]

→ columns: id, customer, total, status (each an untyped string column — see Caveats)

Caveats

Query text is not sent anywhere and has no effect — this connector always re-fetches the same configured url, which is also what keeps it safe from a user redirecting the request somewhere else.
Every column comes back as an untyped string, including numbers and booleans — this connector doesn't infer column types the way a real database connection does.