FreshBooks

FreshBooks is the #1 accounting software in the cloud designed exclusively for service-based small business owners and independent professionals. The company has helped over 10 million people worldwide process billions of dollars with its ridiculously easy-to-use invoicing, time tracking, and expense management features. Based in Toronto, Canada, FreshBooks serves to pay customers in 160 countries.

Data integration: Skyvia supports importing data to and from FreshBooks, exporting FreshBooks data to CSV files, replicating FreshBooks data to relational databases, and synchronizing FreshBooks data with other cloud apps and relational databases.

Backup: Skyvia Backup supports FreshBooks backup.

Query: Skyvia Query supports FreshBooks.

Establishing Connection

To create a connection with Freshbooks, you need to select the Alpha API version, enter your FreshBooks Company name and sign in.

FreshBooks Classic API is deprecated. However, Skyvia supports FreshBooks connections with the Classic API version selected for compatibility.

Creating Connection

To connect to FreshBooks via Alpha API, perform the following steps:

  1. Select the Alpha in the the API Version list on the Connection Editor page.
  2. Specify your Company Name.

    Connection Editor window 2

  3. Click Sign In with FreshBooks.
  4. In the opened window, enter your FreshBooks credentials and click Log in.

    FreshBooks Log In window

Additional Connection Parameters

Metadata Cache

You can specify the time after which Metadata Cache expires.

Connector Specifics

Object Peculiarities

Project

The Services field stores a collection of JSON Services objects. When loading data to the Services field, you can either specify an Id of an existing service (record in the Services object) or specify Name to create a new service with such name, for example:

[{"Id":24327481},{"Name":"Support"}]

In this example, two services are added to the project: one existing service with the corresponding Id, and one new ‘Support’ service is created.

Services

If you work with the Rate field of the Services object, an additional API call is used for each record, both when selecting and modifying this field. If you don’t need the Rate values, don’t query this field.

Incremental Replication and Synchronization

Skyvia does not support the Synchronization and Replication with Incremental Updates for the ExpenseCategory, GateWay, System, and TimeEntry objects.

Supported Actions

Skyvia supports all the common actions for FreshBooks.