FreshBooks

Availability:

Airbyte Cloud Airbyte OSS PyAirbyte

Support Level:

Marketplace

Connector Version:

0.0.9(Last updated 2 hours ago)

FreshBooks connector seamlessly syncs invoicing, expenses, and client data from FreshBooks into data warehouses or analytics platforms.

Configuration

Input	Type	Description	Default Value
client_id	string	Client ID.
client_secret	string	Client secret.
redirect_uri	string	Redirect Uri.
account_id	string	Account Id.
client_refresh_token	string	Refresh token.
oauth_access_token	string	Access token. The current access token. This field might be overridden by the connector based on the token refresh endpoint response.
oauth_token_expiry_date	string	Token expiry date. The date the current access token expires in. This field might be overridden by the connector based on the token refresh endpoint response.
business_uuid	string	Business uuid.

Read this section carefully to get your Account Id and Business UUID.

Streams

Stream Name	Primary Key	Pagination	Supports Full Sync	Supports Incremental
user		DefaultPaginator	✅	❌
clients		DefaultPaginator	✅	❌
invoices	id.invoiceid	DefaultPaginator	✅	❌
expenses	id.expenseid	DefaultPaginator	✅	❌
expense_summaries		DefaultPaginator	✅	❌
expense_categories	id	DefaultPaginator	✅	❌
invoice_details	invoiceid	DefaultPaginator	✅	❌
expense_details	expenseid	DefaultPaginator	✅	❌
accounts		DefaultPaginator	✅	❌
taxes	taxid	DefaultPaginator	✅	❌

Reference

Config fields reference

Field

Type

Property name

Client ID

required

string

client_id

Client secret

required

string

client_secret

Redirect Uri

required

string

redirect_uri

Account Id

required

string

account_id

Refresh token

required

string

client_refresh_token

Business uuid

required

string

business_uuid

string

oauth_access_token

string

oauth_token_expiry_date

Changelog

Expand to review

Version	Date	Pull Request	Subject
0.0.8	2025-01-18	51659	Update dependencies
0.0.7	2025-01-11	51087	Update dependencies
0.0.6	2024-12-28	50525	Update dependencies
0.0.5	2024-12-21	50000	Update dependencies
0.0.4	2024-12-14	49498	Update dependencies
0.0.3	2024-12-12	49209	Update dependencies
0.0.2	2024-12-11	48942	Starting with this version, the Docker image is now rootless. Please note that this and future versions will not be compatible with Airbyte versions earlier than 0.64
0.0.1	2024-10-27		Initial release by @bishalbera via Connector Builder