BizTalk Adapter for FreshBooks

Build 20.0.7587

Tables

The adapter models the data in FreshBooks into a list of tables that can be queried using standard SQL statements.

Generally, querying FreshBooks 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.

CData BizTalk Adapter for FreshBooks Tables

Name Description
Categories A list of categories associated with a FreshBooks account.
Clients A list of clients stored in FreshBooks. Staff can view and edit clients they are assigned to.
Contractors A list of contractors associated with a FreshBooks account. Available only to account administrator, not staff members.
Estimates A list of estimates found in FreshBooks. Staff can only access estimates for their assigned clients.
Expenses A list of expenses for the FreshBooks account. Staff can only access expenses that belong to them or are associated with clients they are assigned to.
Invoices A list of invoices associated with a given client Id. Staff can access invoices for clients that are assigned to them.
Items A list of items stored in FreshBooks.
Payments A list of payments stored in FreshBooks. Staff members can access payments for clients assigned to them.
Projects A list of projects associated with a FreshBooks account. Staff members can access all projects they're assigned to, but can only edit projects for which they are the Project Manager.
Recurring A list of recurring profile summaries. Credit card information must be tokenized before being submitted for auto-bill. Staff members can access recurring profiles for clients they are assigned to.
Staff A list of staff associated with a FreshBooks account. Staff members can only access their own information.
Tasks A list of tasks associated with a FreshBooks account. Staff members can only use the ProjectId field for projects they're assigned to.
Taxes A list of taxes associated with a FreshBooks account.
TimeEntries A list of time entries associated with a FreshBooks account. Staff can only create new time entries for projects they are assigned to.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587