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.

The tables
Jobshttps://one.agentryx.io/api/v1/reporting/jobs
Job historyhttps://one.agentryx.io/api/v1/reporting/job_events
Customershttps://one.agentryx.io/api/v1/reporting/customers
Siteshttps://one.agentryx.io/api/v1/reporting/sites
Equipmenthttps://one.agentryx.io/api/v1/reporting/equipment
Invoiceshttps://one.agentryx.io/api/v1/reporting/invoices
Quoteshttps://one.agentryx.io/api/v1/reporting/quotes
Teamhttps://one.agentryx.io/api/v1/reporting/workers
Timesheetshttps://one.agentryx.io/api/v1/reporting/timesheets
Repeat planshttps://one.agentryx.io/api/v1/reporting/plans
Certificateshttps://one.agentryx.io/api/v1/reporting/certificates
Partshttps://one.agentryx.io/api/v1/reporting/parts
Callshttps://one.agentryx.io/api/v1/reporting/calls
Leavehttps://one.agentryx.io/api/v1/reporting/leave
Expenseshttps://one.agentryx.io/api/v1/reporting/expenses
Vanshttps://one.agentryx.io/api/v1/reporting/vehicles
Fuelhttps://one.agentryx.io/api/v1/reporting/fuel_transactions
Up to 5,000 rows a time. Add ?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.
Power BI Desktop
  1. Get data, Web, then pick Advanced.
  2. URL parts: https://one.agentryx.io/api/v1/reporting/jobs?format=csv&limit=5000
  3. 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).
  4. 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).
  5. 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

Looker Studio can't send a key in a header, so go through Google Sheets or your own storage.

  1. 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.
  2. 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.
  3. BigQuery: point an external table at gs://your-bucket/agentryx-one/latest/*.jsonl (newline JSON) and use the BigQuery connector.
Excel
  1. Data, From Web, Advanced. Same address and header as Power BI.
  2. Data, Refresh all brings it up to date.
A data warehouse (Snowflake, Redshift, Databricks, Fabric)

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.