Move FreshBooks data anywhere it matters.

Sync FreshBooks user, clients and invoices to any warehouse or AI app.

Sync FreshBooks free Read the docs

Source

FreshBooks

Snowflake
BigQuery
Postgres
Databricks
Claude

Streams: 10
Destinations: 50+
Standard support: 0.0.72

Overview

What is the Airbyte FreshBooks connector?

The Airbyte FreshBooks connector extracts data from FreshBooks and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh. It publishes 10 streams you can select per connection.

01
Sync to your warehouse
Land 10 FreshBooks tables in 50+ destinations on a schedule you control.
02
One authorization
Authenticate FreshBooks once and Airbyte keeps every scheduled sync running on it.
03
Cloud or self-hosted
Run the FreshBooks connector on Cloud, OSS, Hybrid.

10 streams

Every table you can sync from FreshBooks

user
Pagination DefaultPaginator
Sync modes FullIncr.
clients
Pagination DefaultPaginator
Sync modes FullIncr.
invoices
Primary key id.invoiceid
Pagination DefaultPaginator
Sync modes FullIncr.
expenses
Primary key id.expenseid
Pagination DefaultPaginator
Sync modes FullIncr.
expense_summaries
Pagination DefaultPaginator
Sync modes FullIncr.
expense_categories
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.

user
Pagination	DefaultPaginator
Sync modes	FullIncr.

clients
Pagination	DefaultPaginator
Sync modes	FullIncr.

invoices
Primary key	id.invoiceid
Pagination	DefaultPaginator
Sync modes	FullIncr.

expenses
Primary key	id.expenseid
Pagination	DefaultPaginator
Sync modes	FullIncr.

expense_summaries
Pagination	DefaultPaginator
Sync modes	FullIncr.

expense_categories
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

Setup

Live in three steps

Get your FreshBooks credentials from the vendor dashboard or developer settings.
Configure the source in Airbyte with the required connection fields.
Pick a destination, choose streams, set full refresh or incremental, and schedule syncs.

Configuration fields

FreshBooks configuration fields
Field	Type	Description
account_id*	string	Not documented.
business_uuid*	string	Not documented.
client_id*	string	Not documented.
client_refresh_token*	string	FreshBooks refresh tokens are single-use: every token refresh invalidates this value and the connector stores the replacement returned by FreshBooks. If this token has already been used elsewhere it is rejected with invalid_grant and you must re-authorize the app to obtain a new one.
client_secret*	string	Not documented.
redirect_uri*	string	Not documented.
oauth_access_token	string	The current access token. This field might be overridden by the connector based on the token refresh endpoint response.
oauth_token_expiry_date	string	The date the current access token expires in. This field might be overridden by the connector based on the token refresh endpoint response.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

FreshBooks connector questions

What data can I sync from FreshBooks with Airbyte?

10 streams: user, clients, invoices, expenses, expense summaries, expense categories, invoice details, expense details, accounts, taxes.

Does the FreshBooks connector support incremental sync?

The FreshBooks connector supports full refresh sync. Check the stream list on this page for incremental support per table.

Where can I run the FreshBooks connector?

Run the FreshBooks connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales