Agentryx One · help
Your data in Power BI, Looker Studio and Excel
Every table is there for your own reports. You need a reporting key: on Connections, make a key and pick Reporting only. It can read everything and change nothing. Keep it like a password and revoke it if it gets out.
| Jobs | https://one.agentryx.io/api/v1/reporting/jobs |
| Job history | https://one.agentryx.io/api/v1/reporting/job_events |
| Customers | https://one.agentryx.io/api/v1/reporting/customers |
| Sites | https://one.agentryx.io/api/v1/reporting/sites |
| Equipment | https://one.agentryx.io/api/v1/reporting/equipment |
| Invoices | https://one.agentryx.io/api/v1/reporting/invoices |
| Quotes | https://one.agentryx.io/api/v1/reporting/quotes |
| Team | https://one.agentryx.io/api/v1/reporting/workers |
| Timesheets | https://one.agentryx.io/api/v1/reporting/timesheets |
| Repeat plans | https://one.agentryx.io/api/v1/reporting/plans |
| Certificates | https://one.agentryx.io/api/v1/reporting/certificates |
| Parts | https://one.agentryx.io/api/v1/reporting/parts |
| Calls | https://one.agentryx.io/api/v1/reporting/calls |
| Leave | https://one.agentryx.io/api/v1/reporting/leave |
| Expenses | https://one.agentryx.io/api/v1/reporting/expenses |
| Vans | https://one.agentryx.io/api/v1/reporting/vehicles |
| Fuel | https://one.agentryx.io/api/v1/reporting/fuel_transactions |
?offset=5000 for the next lot, ?since=2026-11-01 for recent rows only, and ?format=csv for a spreadsheet instead of JSON. Money is in pence. Times are UTC.- Get data, Web, then pick Advanced.
- URL parts:
https://one.agentryx.io/api/v1/reporting/jobs?format=csv&limit=5000 - HTTP request header: Authorization, value
Bearer agx_your_reporting_key. Press OK, then Anonymous when it asks how to sign in (the key does that). - Power BI shows the columns. Load, and do the same for each table you want. Join them on the id columns (for example jobs.customer_id to customers.id).
- To refresh in the Power BI service, publish the report and set a scheduled refresh. If the service won't keep the header, use the address with the key in it instead:
https://one.agentryx.io/api/v1/reporting/jobs?format=csv&key=agx_your_reporting_key
Looker Studio can't send a key in a header, so go through Google Sheets or your own storage.
- Google Sheets: make a sheet per table and put this in cell A1:
=IMPORTDATA("https://one.agentryx.io/api/v1/reporting/jobs?format=csv&key=agx_your_reporting_key")Sheets refreshes it about every hour. In Looker Studio, Add data, Google Sheets, and pick the sheet. - Google Cloud Storage: set up the nightly copy on Connections with a Google Cloud bucket. In Looker Studio, Add data, Google Cloud Storage, and give it
your-bucket/agentryx-one/latest/jobs.csv. It updates every night. - BigQuery: point an external table at
gs://your-bucket/agentryx-one/latest/*.jsonl(newline JSON) and use the BigQuery connector.
- Data, From Web, Advanced. Same address and header as Power BI.
- Data, Refresh all brings it up to date.
Set up the nightly copy on Connections with an Amazon S3 or Google Cloud bucket. Every night at 2am each table lands twice: in a folder for the day (agentryx-one/2026-11-17/jobs.csv) and in agentryx-one/latest/, as CSV and newline JSON. latest/_manifest.json lists the tables and row counts. Load from there with your warehouse's usual S3 or GCS stage.