API Data Provider - Online Help
Codat Profile
Connecting to Codat
Using the Profile
ADO.NET
JDBC
ODBC
PowerBI
SSIS
Excel
SQL Compliance
SELECT Statements
SQL Functions
String Functions
Date Functions
Math Functions
EXECUTE Statements
Schema Discovery
ADO.NET
JDBC
System Tables
sys_tables
sys_tablecolumns
sys_procedures
Tables
Accounts
AgedCreditorReport
AgedDebtorReport
BalanceSheet
BankAccounts
BankStatements
BankStatementsAccounts
BillPayments
Bills
Companies
CompanyInfo
Connections
CreditNotes
Customers
DataSets
IntegrationBankSettings
Integrations
Invoices
Items
Journals
Payments
Profile
ProfileSyncSettings
ProfitAndLoss
Suppliers
TaxRates
Transactions
Codat Stored Procedures