API Data Provider - Online Help

Harvest 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.

Harvest Tables

Name Description
AuthenticatedUser Returns a list of your users.
Clients Returns a list of your clients.
Company Retrieves the company for the currently authenticated user.
Contacts Returns a list of your contacts
EstimateItemCategories Returns a list of your estimate item categories.
EstimateMessages Returns a list of messages associated with a given estimate
Estimates Returns a list of your estimates
ExpenseCategories Returns a list of your expense categories.
Expenses Returns a list of your expenses
InvoiceItemCategories Returns a list of your invoice item categories.
InvoiceMessages Returns a list of messages associated with a given invoice
InvoicePayments Returns a list of payments associate with a given invoice
Invoices Returns a list of your invoices
Projects Returns a list of your projects
ProjectTaskAssignments Returns a list of your task assignments.
ProjectUserAssignments Returns a list of your user assignments.
Roles Returns a list of roles in the account
Tasks Returns a list of your tasks.
TimeEntries Returns a list of your expenses
UserCostRates Returns a list of cost rates for the specified user.
ProjectUserAssignments Returns a list of your project assignments for the specified user.
Users Returns a list of your users.

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