BizTalk Adapter for FreshBooks

Build 20.0.7587

Data Model

The CData BizTalk Adapter for FreshBooks can model your account as a database through two APIs, the Classic API and the Alpha API. You can programmatically access the available entities by querying the available System Tables.

Collaborative Query Processing

The adapter offloads as much of the SELECT statement processing as possible to FreshBooks and then processes the rest of the query within the adapter. See SupportEnhancedSQL for more information on how the adapter circumvents API limitations with in-memory client-side processing.

Key Features

  • The adapter models FreshBooks Categories, Projects, and more, allowing you to write SQL to query FreshBooks data.
  • Stored procedures allow you to execute operations to FreshBooks, including downloading and uploading objects.
  • Live connectivity to these objects means any changes to your FreshBooks account are immediately reflected when using the adapter.

Classic API

The Classic API uses the OAuth Core 1.0 Revision A specification.

Alpha API

The Alpha API uses the OAuth 2.0 specification.

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