Freshbooks Integration SharePoint

FreshBooks cloud accounting data can be integrated and synchronized codeless with various other data sources using the Layer2 Cloud Connector via 3rd party data providers. Invoices, transactions, sales receipts, reports, and more are supported for data synchronization. Please take a look here for systems and applications to connect, like SQL databases, Microsoft Office 365, SharePoint, Exchange, Dynamics and many others.​​​​

FreshBooks Data Integration and Synchronization

FreshBooks is a very popular cloud-based accounting solution that serves more than 5 million people to make billing painless. It helps to create and send invoices, capture expenses, track time and know your numbers.

FreshBooks Data Connectivity 

data can be integrated und synchronized codeless with many systems and applications on-premises (locally) or in other clouds using the Layer2 Cloud Connector.

Benefits of FreshBooks Data Integration and Synchronization

Integrating FreshBooks via the the Layer2 Cloud Connector has the following features and benefits:
  • Many systems and apps can be connected: Often requested data providers like ODBC, OLEDB, OData, XML etc. are included in the distribution package, vendor specific ADO.NET data providers like for SQL Server, Oracle, mySQL etc. can be used, also 3rd party data providers. On-premises and cloud-based systems and apps are supported. Please find your specific data source or destination here.
  • Fast and risk-free codeless implementation: No programming or tools required. Setup in a few minutes guided by a wizard. Sample connection templates included. Just adapt your connection string and data query. 
  • No touch integration: Does not require any customization, changes or installation on FreshBooks or the external data source side, e.g. SQL or SharePoint.
  • Flexible sync options: One-way or two-way sync, insert/update/delete operations can be blocked, if required. Scheduled update in background, or on-demand only.
  • Reliable architecture: A connection is established only for data synchronization – not for general FreshBooks usage.
  • All FreshBooks features provided: As external data is directly cached in FreshBooks, all the great FreshBooks features are provided as usual.
  • Best performance: Fast synchronization, supports large datasets. No bulk-import - data changes are processed carefully. Users directly work with cached data sets in FreshBooks for best user experience.
  • Highest Security: No need to open your local network for access from outside. Secure communication, e.g. SSL/HTTPS (depending on data provider). No 3rd party or clouds involved. The Layer2 Cloud Connector runs as a Windows service on a Windows server or client in your secure internal network and directly connects both ends for sync.

FreshBooks Specific Data Integration Settings

​To connect to FreshBooks the data source entity must be configured as follows in the Layer2 Cloud Connector Connection Manager:

FreshBooks Data Integration Synchronization 


Fig.: Sample connection configuration to connect to a FreshBooks clients list via 3rd party data provider.

Please note the following FreshBooks specific settings.

  • Install the CDATA ADO.NET Provider for FreshBooks. This provider is not part of the Layer2 Cloud Connector ADO.NET provider package and should be installed separately from the vendor's product page. It requires extra licensing.
  • Choose “CDATA ADO.NET Provider for FreshBooks 2015” (exact name might vary) as “Data Provider” for your data entity (source and / or destination).
  • Follow the vendor instructions for setting up the connection string and select statement (see below for samples).
  • Make use of a connection string like this: CompanyName=MyId; Token=MyToken; AutoCache=true;
  • The CompanyName value is required to connect to FreshBooks and is the same as the first part of the URL used to connect. For example the account with the URL has a company name "sample".
  • The token value is required to connect if not using OAuth. It can be found in the FreshBooks account settings, under "FreshBooks API". For example,  
  • Add a data query following the vendor documentation. Invoices, transactions, sales receipts, reports, and more are supported.
  • If you are using this provider as a data source in a uni-directional connection, choosing a primary key is not required as the provider sets one automatically. 
  • If you are using this provider as target or in a bi-directional connection, choosing your own primary key is required. Choosing the automatically provided primary key is not recommended as this might lead to inconsistent synchronization. Usual PK restrictions of ‘unique, non-NULL’ apply.
  • Note that you can connect FreshBooks via ODBC as well.

Step-by-Step Intros For FreshBooks Integration And Synchronization

​Just some ideas what to connect next with to FreshBooks data queries:
  • Sync with 3rd party tools like ERP/CRM/CMS based on SQL databases like Oracle, mySQL or Microsoft SQL Server.
  • Sync with Microsoft SharePoint or Office 365 for advanced collaboration (for example with customers or partners) or for intranet publishing. Search, change notifications and workflows are fully supported. Syncing FreshBooks contact data with Office 365 automatically integrates with Microsoft Outlook and other apps.
  • Integrate with Microsoft Dynamics CRM/ERP/NAV or SalesForce etc.
  • Archive FreshBooks data in a local database for custom reporting / analyis.
  • You will find more systems to connect here.

FreshBooks Data Integration - Known Issues and Workarounds

  • The scenario above uses the token-based authentication offered by FreshBooks, which is deprecated (support might cease at any time). FreshBooks recommends using OAuth, but requires a formal application for OAuth credentials, which might take up to five working days to get approved.
  • AutoCache=true is used to work with live data instead of local cache (which seems counter-intuitive, hence this note).
  • Usernames (“clients” collection column) couldn’t be used twice, even after deletion.

Next Steps For Cloud Connector Evaluation

Share this site on Xing
Share this site on Google+
Share this site on LinkedIn

The Layer2 Cloud Connector does what every other synchronization software doesn’t, it syncs both ways and works.


 Download & Evaluation

Please register now to receive your free personal download link via email to your valid company email address.
Yes, I accept the licensing terms and conditions
How to buy this product

With the free Shareware Edition you can manage a limited number of items per connection. To order a license for the full version please click the shopping cart below.

Layer2 Cloud Connector
License List price Buy Now
FREE Shareware Edition * $0.00
FREE App Edition *
App Store only
$0.00 Go to App Store
Personal Edition
1 Single Server
License (one-time fee)
$499.00 Add to Shopping Card
1 Annual Software Assurance
for Personal Edition
$99.00 Add to Shopping Card
Professional Edition
1 Single Server
License (one-time fee)
$1,407.00 Add to Shopping Card
1 Annual Software Assurance for Professional Edition $281.00 Add to Shopping Card
Enterprise Edition **
1 Single Server
License (one-time fee)



File Sync Edition***
1 user annual subscription
Prepaid Remote Support
1 Hour
$176.00 Add to Shopping Card
Please contact [email protected] in case you want to order directly via Layer2 based on quote, invoice and bank transfer to Germany.


* The Shareware Edition and App Edition is limited to sync 25 items per connection.

** Starting with January 2015 all features of the Enterprise Edition are already included in the Professional Edition.

*** The File Sync Edition is limited to local file synchronization with any specific Office 365, SharePoint or OneDrive4B. The license is per user annually with a minimum of 50 licenses. Not yet available for online order. Please contact [email protected] if interested.

Frank Daske

Frank Daske

Business Development Manager
+49 (0) 40 28 41 12 - 30
[email protected]

Please note that the 011 exit code must be dialed first for all international calls made from the USA, Canada and Australia.

Related News

Layer2 now connects 100+ commonly used IT systems with Twitter via its Layer2 Cloud Connector

The Layer2 Cloud Connector is now able to connect Twitter to integrate data to a wide range of IT backend systems including Office 365, SharePoint, SQL, ERP/CRM.

New Microsoft Teams Connectors: Layer2 adds 100+ typically used backend systems

​The Layer2 Cloud Connector is now able to connect to Microsoft Teams to quickly integrate more than 100 IT backend systems including local SQL, ERP/CRM.
Related Downloads
PDF Image

Cloud Connector Instruction

Download this step-by-step instruction to connect and sync your corporate or cloud data sources bi-directional to any native SharePoint 2010/2013/2016 list or library, including Microsoft Office 365.
PDF Image

Feasibility Study: Connecting local SQL Server to SharePoint Online

The study compares different approaches for SharePoint Online data integration regarding performance, features, security and investment.
PDF Image

Flyer: Layer2 Partner Program

Partner with us as a software distributer, reseller or SharePoint, Office 365 or Azure service provider. We are offering a free Partner Program with up to 30% Discount, free NFR licenses etc. Please download for more.
PDF Image

Layer2 Case Study: Cloud Connector helps ChemWerth to integrate the Microsoft Office 365 Cloud

"The Cloud Connector’s interface is easy to understand and use. Anyone familiar with utilities in the Microsoft stack will be productive immediately. Our recommendation: The Layer2 Cloud Connector is a no brainer.”
NoDoc Image

Layer2 Cloud Connector PAD File

This XML-based PAD file offers a Layer2 Cloud Connector product description for resellers to download and publish.
PDF Image

Office 365: How to sync with MS Dynamics CRM

You can sync any CRM data with native lists in SharePoint on-prem or online to make it available offline with Outlook.
PDF Image

Office 365: How to sync with SAP?

You can connect SharePoint and Office 365 with SAP via NetWeaver and OData.
PDF Image

Office 365: How to sync your local file share?

When you are moving to the cloud, there are a lot of reasons to keep your local file system. But you don't have to miss the benefits of the cloud.
PDF Image

Product Flyer: Cloud Connector for Microsoft SharePoint & Office 365

Flyer with features, benefits & pricing info for download as PDF.
PDF Image

Product Flyer: SharePoint Online Local File Server Sync

You can centrally migrate, synchronize, or backup your local file server department shares and home drives very flexible with SharePoint Online to close known gaps and overcome limitations of the Microsoft OneDrive for Business client.
PDF Image

Solutions Flyer: Data Integration with SharePoint, Office 365 and 100+

FileMaker can be integrated with 100+ other sources codeless using the Layer2 Cloud Connector.
Related Links

Layer2 Cloud Connector Community Group @ LinkedIn

​Are you already @ LinkedIn? Please join the Cloud Connector Community Group to share your experience.

Microsoft Partner Story Book for Office 365 about Cloud Connector

​Know more about a Layer2 Cloud Connector customer reference at the Microsoft Office web site.

Purchase Layer2 Cloud Connector via ComponentSource

​ComponentSource has offices in the USA, UK and Japan supporting over 125,000+ Customers, in over 180 Countries. They are also an approved Federal Government supplier through the GSA Schedule.



Sign Up for Layer2 Product Newsletter

We keep you up-to-date about new Layer2 product releases, added features and fixed issues.