Knowledgebase

Setup Quickbooks components

1. Connection component setup to connect to Intuit Sandbox account
   1. Sign up for Intuit developer account (if you don’t have one yet): https://developer.intuit.com
   2. Login to developer area and open My Apps: https://developer.intuit.com/v2/ui#/app/dashboard
   3. Create App in Developer area (if you don’t have it yet)
   4. Open Key tab, get App Token, OAuth Consumer Key and OAuth Consumer Secret. Store them.
   5. Sing in to your Sandbox . You can find the link from upper right menu in Developer Area.
   6. Click on your name in upper right corner, to open your Account settings page. Get Company ID, store it.
   7. Open app in Developer area
   8. Click on Test connect to app (OAuth), to open Playground
   9. Increase Access token duration to some really long time
   10. In Playground, Click Connect to Quickbooks. It asks now for your Sandbox password if you are not logged in yet. Then click Authorize.
   11. You are back in Playground. Click now ”Reconnect …."
   12. New browser tab opens. Now be fast and copy the long string from browser command line, before it redirects. You must be fast! Try again if needed by clicking Reconnect.
   13. Paste the result now somewhere like notepad and you will find Access Token and Access Token’s Secret inside the long url. Grab values of “access_token=“ and “access_secret=“. Store them.
   14. Open Talend and open your Job you have Quickbooks components in. Input all earlier stored values to the tCBIntuitQuickBooksConnection component.
   15. Choose Sandbox from drop down menu in tCBIntuitQuickBooksConnection component
   16. Input license key. You can find it under your account in Services area in Cloudbee Client Area: https://cloudbee.com/bl
   17. In production jobs we recommend using Talend context functionality for storing license keys, because key may change in some situations, like reinstalling components in some other computer. In that case ask for new license key from Cloudbee support.

Additional Technical Info

All tCBIntuitQuickBooks components are using QuickBooks Online API v3. Pay attention to required fields in every object.
API documentation: https://developer.intuit.com/docs/95_legacy/qbd_v3/qbd_v3_reference 
API Playground: https://developer.intuit.com/v2/apiexplorer?apiname=V3QBO#?id=Account 

Quickbooks API has some limits set. For example, you can't make more then 500 requests per minute.
About API limits you can read here: https://developer.intuit.com/docs/0050_quickbooks_api/0040_more/limits_and_throttles 

Read also this article about Intuit Quickbooks token expiring policy: https://developer.intuit.com/docs/0100_accounting/0060_authentication_and_authorization/connect_from_within_your_app#/manage