Can I connect a REST API to iDBQuery?
Yes. iDBQuery connects to REST APIs, pulls their JSON responses into a queryable model, and lets you ask questions in plain language over live API data. It supports authentication and scheduled syncs, with a built-in safeguard that blocks requests to internal or private addresses.
iDBQuery includes a REST API connector so external services become a queryable source like any database. You point it at an endpoint, configure authentication, and iDBQuery fetches the JSON, flattens it into a structured model, and makes it available to question.
- Authentication supported — including token-based and OAuth2 client-credentials and authorization-code flows for protected APIs.
- JSON to queryable data — nested API responses are turned into tables you can filter, aggregate and join.
- Scheduled syncs — set a recurring refresh so the connected API data stays current automatically.
- Safe by default — every user-supplied URL passes a guard that blocks requests to internal or private network addresses, preventing data from leaking to or from places it shouldn't.
Once connected, API data behaves like any other source: you can blend it with your databases, spreadsheets and documents in one live model and ask questions that span all of them. This is ideal for pulling in metrics, records or reference data from a SaaS tool or internal service without building and maintaining a separate pipeline. As with every source, answers are cited so you can trace them back to the underlying records.
Updated 2026-06-22