API Data Provider - Online Help

Avaza Tables

The provider models the data in API as a list of tables in a relational database that can be queried using standard SQL statements.

Avaza Tables

Name Description
Account Returns account details.
Companies Returns the list of companies.
Contacts Returns the list of contacts.
CreditNotes Returns the list of credit notes.
Currencies Returns a list of currencies.
Estimates Returns a list of estimates.
ExpenseCategories Returns a list of expense categories.
ExpenseGroups Returns all expense groups.
ExpenseMerchants Returns a list of expense merchants.
ExpensePaymentMethods Returns a list of payment methods.
Expenses Returns a list of expenses.
FixedAmounts Returns all expenses.
Inventory Returns the list of inventory.
Invoices Returns a list of invoices.
Payments Returns a list of payments.
Projects Returns a list of projects.
ProjectTimesheetCategories Returns all project timesheet categories.
ScheduleAssignments Returns schedule assignments.
ScheduleSeries Returns schedule series.
Sections Returns list of sections.
Tasks Returns the list of tasks.
TaskStatuses Returns the list of task statuses.
TaskTypes Returns the list of task types.
Taxes Returns the list of taxes configured in Avaza account.
Timesheets Returns the list of timesheets.
TimesheetSummary Returns Basic Summary of Timesheet Statistics.
TimesheetTimer Returns the running timer if there is one for a user.
Users Returns collection of users who have roles in the current Avaza account.
Webhooks Returns the list of webhook subscriptions.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839.0