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

Connector Specifics

Object Peculiarities

Bills

The Bills object stores complex structured fields in JSON format: Lines, BillPaymets. You can use our Nested Objects mapping feature in Import to insert or update the nested values in such fields. Select the Nested Objects checkbox in import to enable this feature. You can also replicate the nested objects using the Unwind Nested Objects option. Select JSON Columns to replicate nested object fields as columns with JSON data into the target table or select Separate Tables to replicate nested object fields into additional tables in the database.

When you modify the Lines field, Skyvia rewrites its value. For example, you have two lines in the Bill, now you want to add the third line. You have to list all the existing lines and a new one together in the mapping.

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.

On This Page