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": ""
}

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.