Axiomatic Docs

Export ledger data for external analysis in Tableau, Power BI, or custom data pipelines.

Overview

The data warehouse export endpoint provides bulk access to your accounting data in JSON or CSV format. Use it to feed external BI tools, build custom dashboards, or integrate with your data warehouse.

Data export requires the Professional plan or above.

Export Endpoint

GET /api/exports/data-warehouse?entityId=...&bookId=...

Query Parameters

Parameter	Required	Description
`entityId`	Yes	The entity to export data for
`bookId`	Yes	The book to export from
`format`	No	`json` (default) or `csv`
`tables`	No	Comma-separated list of tables to include. Omit to export all.
`fromDate`	No	Start date filter (ISO 8601)
`toDate`	No	End date filter (ISO 8601)

Available Tables

Table	Description
`accounts`	Chart of accounts
`journal_entries`	Posted journal entry headers
`journal_lines`	Individual debit/credit lines
`events`	Financial events
`bills`	Accounts payable bills
`invoices`	Accounts receivable invoices
`trial_balance`	Current trial balance

Example: Export Journal Data as CSV

GET /api/exports/data-warehouse?entityId=abc&bookId=xyz&format=csv&tables=journal_entries,journal_lines&fromDate=2025-01-01&toDate=2025-12-31

Output Formats

JSON

Returns a JSON object keyed by table name, with each value being an array of rows:

{
  "accounts": [
    { "id": "...", "code": "1000", "name": "Cash", "type": "ASSET" }
  ],
  "journal_entries": [
    { "id": "...", "date": "2025-03-15", "memo": "Payroll" }
  ]
}

The response includes a Content-Disposition header for direct download: attachment; filename="export-{entityId}-{date}.json"

CSV

Returns a multi-section CSV file with one section per table. Each section starts with a header row containing column names.

The response includes: Content-Disposition: attachment; filename="export-{entityId}-{date}.csv"

Connecting to BI Tools

Tableau

Use Tableau's Web Data Connector or REST API data source
Point it to https://app.axiomatic.software/api/exports/data-warehouse
Pass your API key in the Authorization header
Set format=json and select the tables you need
Configure a refresh schedule matching your reporting cadence

Power BI

Use Get Data → Web or the REST API connector
Enter the export URL with your query parameters
Add your API key as a Bearer token in the authentication settings
Power BI will parse the JSON response into tables automatically
Set up scheduled refresh in the Power BI service

Custom Pipelines

Call the export endpoint from any HTTP client. For incremental loads, use fromDate and toDate to fetch only the data that changed since your last pull.

Authentication

All export requests require a valid API key with read access to the entity. Pass it as a Bearer token:

Authorization: Bearer your-api-key

Generate API keys in Settings → API Keys.

Data Export