FreshBooks
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.15 | 2025-03-08 | 55347 | Update dependencies | 
| 0.0.14 | 2025-03-01 | 54947 | Update dependencies | 
| 0.0.13 | 2025-02-22 | 54422 | Update dependencies | 
| 0.0.12 | 2025-02-15 | 53770 | Update dependencies | 
| 0.0.11 | 2025-02-08 | 53314 | Update dependencies | 
| 0.0.10 | 2025-02-01 | 52873 | Update dependencies | 
| 0.0.9 | 2025-01-25 | 52309 | Update dependencies | 
| 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 |