Data Tables

After running the analysis, the data table provides results details about the imported financial data for the current period.

Logical names and types

Data tables types can be identified by either their logicalName or type field, depending on the data table, and can be queried accordingly using the following fields:

Table	Field	Value
General Ledger Entries	`logicalName`	`gl_journal_lines`
General Ledger Transactions	`logicalName`	`gl_journal_tx`
Monetary Flows	`type`	`flows_compact`
Accounts Payable Entries	`logicalName`	`ap_detail_entries`
Accounts Receivable Entries	`logicalName`	`ar_detail_entries`
Accounts Payable: End of Period Outstanding Payable	`logicalName`	`ap_detail_union_open_payables`
Accounts Receivable: End of Period Outstanding Receivables	`logicalName`	`ar_detail_union_open_receivables`
Configured Analysis Entries	`logicalName`	`output_entries_virtual`

Table API stability

The API includes data tables with stable schema as well as tables with unstable schema, where the schema might change in the future or may even be removed. By default, the data table query API returns tables with stable schema only. To include tables with unstable schema in the results, add include-unstable-schemas=true to your query string. For example, https://.../api/v1/data-tables/query?page=0&size=20&include-unstable-schemas=true.

Overview

Details

Webhooks

API reference

Logical names and types

Table API stability

​Logical names and types

​Table API stability

Logical names and types

Table API stability