API Data Provider - Online Help
Avaza Profile
Connecting to Avaza
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
Account
Companies
Contacts
CreditNotes
Currencies
Estimates
ExpenseCategories
ExpenseGroups
ExpenseMerchants
ExpensePaymentMethods
Expenses
FixedAmounts
Inventory
Invoices
Payments
Projects
ProjectTimesheetCategories
ScheduleAssignments
ScheduleSeries
Sections
Tasks
TaskStatuses
TaskTypes
Taxes
Timesheets
TimesheetSummary
TimesheetTimer
Users
Webhooks
ExpenseGroups
Returns all expense groups.
Columns
Name
Type
References
Id [KEY]
Integer
Name
String