APIs

Goal: Call your warm queries from anywhere.

Every warm query is automatically a REST endpoint. Open the APIs menu to find it with ready-to-copy cURL, TypeScript, and Python; the panel shows your exact URL:

https://openx.fathym.com/oi-api/warm-queries/{lookup}

Authenticate

APIs -> API Keys: pick an expiration (15 minutes to 30 days) or a custom duration, Generate, copy once. Treat tokens like passwords; scope them to what the integration needs (see Security).

Call it

curl -X GET 'https://openx.fathym.com/oi-api/warm-queries/{lookup}' \
  -H 'Authorization: Bearer YOUR_TOKEN'

The response includes the results plus who approved the query and when.

Power BI

Copy the endpoint + token -> Power BI Desktop Get Data -> Web -> Advanced, add header Authorization: Bearer YOUR_TOKEN -> expand the results array -> set types -> Close & Apply. For auto-refresh, publish to the Power BI Service and store the token in the gateway.

Grafana

Configuration -> Data Sources -> Add the JSON API source, set the URL + auth header; add a panel with path $.results[*], time field timestamp, value field your metric.

Where it plugs in

Tool	How
Power BI	Web/REST connector
Grafana	JSON API data source
Dashboards / apps	Direct HTTP
Any AI	MCP - see Bring Any AI

Next steps

• Browse + test endpoints -> API Explorer
• Manage tokens -> Security
• Auth, scopes, the full endpoint list -> Auth & Tokens