Xplenty customers can now connect to QuickBooks Online API  to query, process, and store consolidated information into an easy-to-use reference database structure or file storage.

Sample Use Cases on Xplenty

    1. Monitoring company and accounts information: Collect and compile each of your companies' or clients' information from QuickBooks. 
    2. Processing invoices information: Store the information from invoices for consolidation and analysis.
    3. Processing customer information: Store customer contacts, billing information, and buying histories as a step towards better CRM.
    4. Auditing items and inventory: Aggregate SKU numbers, unit price and purchase cost of the inventory.
    5. Compiling discounts and credit memos

Customer Story
Customer Story
Keith connected multiple data sources with Amazon Redshift to transform, organize and analyze their customer data.
Amazon Redshift Amazon Redshift
David Schuman
Keith Slater
Senior Developer at Creative Anvil
Before we started with Xplenty, we were trying to move data from many different data sources into Redshift. Xplenty has helped us do that quickly and easily. The best feature of the platform is having the ability to manipulate data as needed without the process being overly complex. Also, the support is great - they’re always responsive and willing to help.
TRUSTED BY COMPANIES WORLDWIDE

Enjoying This Article?

Receive great content weekly with the Xplenty Newsletter!

How to Connect Xplenty to QuickBooks

The REST API component from Xplenty can be used to connect to the QuickBooks Online API. The OAuth2 process detailed here can be set up on pipelines in Xplenty with variables set to query for access_token & refresh_tokens using the Curl function.

Setting up a Test Company and Test App on QuickBooks

If you have not yet signed up for an Intuit Developer account, you can do so via this link. This account allows you to explore the QBO API

A Sandbox company dashboard from QuickBooks provides sample data for the sales, invoices, and customers to test with, as shown in the following image:

undefined

Customer Story
Customer Story
Keith connected multiple data sources with Amazon Redshift to transform, organize and analyze their customer data.
MongoDB MongoDB
Amazon Redshift Amazon Redshift
David Schuman
Dave Schuman
CTO and Co-Founder at Raise.me
They really have provided an interface to this world of data transformation that works. It’s intuitive, it’s easy to deal with [...] and when it gets a little too confusing for us, [Xplenty’s customer support team] will work for an entire day sometimes on just trying to help us solve our problem, and they never give up until it’s solved.
TRUSTED BY COMPANIES WORLDWIDE

Enjoying This Article?

Receive great content weekly with the Xplenty Newsletter!

Setting up the Xplenty Data Pipeline

We will now walk through an example use case for moving and processing invoices with Xpenty from the Sandbox Company_US_2 in QuickBooks to the destination database. 

Here is a sample image of the completed pipeline: 

undefined

1) Connect via the REST API component with the GET method to the URL (encoded) as https://sandbox-quickbooks.api.intuit.com/v3/company/<realmID>/query?query=select%20%2A%20from%20Invoice&minorversion=<version>

The Headers are set to Accept application/json, Authorization Bearer $access_token as respective Key Value pairs.

undefined

2) Process the data. You can use the Xplenty methods detailed in  How Do I Process JSON Data to choose, extract, and further process the required fields. The invoice object from Intuit shows the structure of the JSON data returned.

3) Store the resulting invoice data on file storage, a Database, or one of the many other destination options Xplenty provides.

Here is a snapshot of the invoice information retrieved via the pipeline:

undefined

The process for gaining information on deposits, products, and services will follow a similar set of instructions.

Summary

For all of these scenarios and more, Xplenty can integrate QuickBooks data with and to other data sources for quick data analysis. Our drag-and-drop interface lets you build ETL pipelines within minutes, without much complex coding involved. Contact us to book your demo and experience Xplenty for yourself.

Integrate Your Data Today!

Try Xplenty free for 14 days. No credit card required.