Schema Information for FreshBooks

In this article, we will look at the schema information of the supported APIs and tables for FreshBooks.

Need help with something?

Talk to data expert

Find the links to other articles related to FreshBooks below:

Tables/APIs Supported

The tables and APIs associated with the FreshBooks connector are as follows.

Clients

Purpose: Gives the list of all “clients” to whom you send invoices to.
Source API Documentation  https://www.freshbooks.com/api/clients

Replication: Full Replication
Replication Key: NA

 

Expenses

Purpose: Gives the list of all expenditures of your business in FreshBooks.
Source API Documentation  https://www.freshbooks.com/api/expenses

Replication: Full Replication
Replication Key: NA

 

Invoices

Purpose: Gives the list of all "Invoices" present.
Source API Documentation  https://www.freshbooks.com/api/invoices

Replication: Full Replication
Replication Key: NA

 

Estimates

Purpose: This API gives a list of all "Estimates". Estimates provides Owners and Clients a way to agree and negotiate on the price and scope of work before it commences
Source API Documentation  https://www.freshbooks.com/api/estimates

Replication: Full Replication
Replication Key: NA

 

Taxes

Purpose: Lists all the previously used "Taxes".
Source API Documentation  https://www.freshbooks.com/api/taxes

Replication: Key-Based Replication
Replication Key: updated_since

 

Projects

Purpose: This lists all the "Projects", which are basically used for tracking business projects and related information.
Source API Documentation  https://www.freshbooks.com/api/project

Replication: Key-Based Replication
Replication Key: updated_since

 

TimeEntries

Purpose: This lists all the "Time Entries". Time Entries represent time spent working for a client or project.
Source API Documentation  https://www.freshbooks.com/api/time_entries

Replication: Key-Based Replication
Replication Key: updated_since