FreshBooks logo

FreshBooks

Sync FreshBooks invoice, client, and payment data into your warehouse.

Overview

The FreshBooks connector syncs your invoicing and accounting data into analytics-ready tables in your data warehouse. Pull invoices, clients, expenses, payments, and time entries from the FreshBooks API, with Ingest handling auth, pagination, and retries so the tables stay current.

What you can sync

Ingest syncs the following FreshBooks data into your data warehouse, each as its own table refreshed on your schedule:

  • Invoices
  • Clients
  • Expenses
  • Payments
  • Time entries

Authentication

OAuth2 (authorization code)

Sign up or log in at the FreshBooks developer portal and create an app with a redirect URI for client credentials.

You enter credentials in a secure form, never in chat. Ingest stores and rotates them for you.

Resources