Codat Tables
The provider models the data in API into a list of tables that can be queried using standard SQL statements.
Generally, querying API tables is the same as querying a table in a relational database. Sometimes there are special cases, for example, including a certain column in the WHERE clause might be required to get data for certain columns in the table. This is typically needed for situations where a separate request must be made for each row to get certain columns. These types of situations are clearly documented at the top of the table page linked below.
Codat Tables
| Name | Description |
| Accounts | Gets the latest chart of accounts for a company |
| AgedCreditorReport | Gets the aged creditor report for a company |
| AgedDebtorReport | Gets the aged debtor report for a company |
| BalanceSheet | Gets the latest balance sheet for a company. |
| BankAccounts | Gets bank accounts info |
| BankStatements | Gets the latest bank statements for a company |
| BankStatementsAccounts | Gets the latest bank statements for a company |
| BillPayments | Gets the latest billPayments for a company |
| Bills | Gets the latest bills for a company |
| Companies | Fetch a list of all companies metadata with accounting links on the Codat platform |
| CompanyInfo | Gets the latest basic info for a company |
| Connections | Gets connections for a company |
| CreditNotes | Gets a list of all credit notes for a company |
| Customers | Gets the latest bank statements for a company |
| DataSets | Fetch a list of all data snapshots captured for a company |
| IntegrationBankSettings | Gets Bank Settings for integrations for your account |
| Integrations | Gets integrations for your account |
| Invoices | Gets the latest invoices for a company |
| Items | Gets the items for a given company |
| Journals | Gets the latest journal entries for a company |
| Payments | Gets the latest payments for a company |
| Profile | Fetch your organisations company profile |
| ProfileSyncSettings | Fetch your profile sync settings |
| ProfitAndLoss | Gets the latest profit and loss for a company. |
| Suppliers | Gets the latest suppliers for a company |
| TaxRates | Gets the latest tax rates for a given company. |
| Transactions | Gets the latest bank transactions for given account ID and company. |