Best way to connect to Quickbooks Online

[TimCr]

Hello! I am working with a customer that is looking to connect to Quickbooks Online environments.  They are a consultant and will be connecting to different environments from week to week (not just one). 

There seem to be some 3rd party connections via ODBC, but curious if there are any connectors people have used to connect that they feel work particularly well.  Any recommendations?

[RishiK]

Hi there

Not sure if you know, but you can connect directly to the QBO API within Alteryx.  You can get a trial account and full access is available via a paid account via http://developer.intuit.com/us.

Here is some more information about accessing data via APIs within our platform.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connecting-to-an-API/td-p/50483

Hope this helps!

[PeterP · Accepted solution]

Hi @TimCr ,

I have had a number of customers asking for a simple way to directly access their reports within QuickBooks as well so I took the liberty of building out a tool that will bring in the JSON Response from the requested report. 

Here is a link to a community article I posted showing step by step how to access the Quickbooks API.

Below is also the direct link to download the YXI installer for the tool. This will automatically download the tool into the "Connectors" Tab in your Designer tool palette:

https://www.dropbox.com/s/nsi5002tikm1qyl/quickbooks_input.yxi?dl=0

[TimCr]

Thank you Peter!!