Integrating Quickbooks Community Connector with Airbyte for QBO Prod Application

Slack Knowledge Base Q&A Connector Development
, , , ,
1

Summary

The user is looking to integrate their QBO prod application (oAuth2) with Airbyte using the Quickbooks community connector. They have questions regarding connection persistence with refresh tokens and retrieving RealmID (CompanyId) without custom transformations.


Question

Hi all :wave:,
I’m working with the <QuickBooks | Airbyte Documentation community connector> and am looking to integrate my QBO prod application (oAuth2) with Airbyte and have a few questions.

  1. Connection persistence - According to the QBO documentation, refresh tokens are updated every 24 hours, which requires reconfiguring the source with a fresh token upon every expiration. Is there a way around this within the UI (<Issues · airbytehq/airbyte · GitHub old issue in github>), or does it require custom integration to maintain a persistent connection to my oauth app?
  2. RealmID (CompanyId) - Does anyone know of a good way to retrieve this from the available endpoints and append to all of the streams without using a custom transformation? If a custom transformation is the answer, what’s the best way to implement that since this connector cannot be uploaded as YAML into the low-code builder?
    Thanks in advance!

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["quickbooks-community-connector", "qbo-prod-application", "oauth2", "connection-persistence", "refresh-tokens", "realmid", "companyid", "custom-transformation"]
2

<@U041EQ42F8T> any ideas? Sorry to ping you directly :stuck_out_tongue:

3

:wave: <@U06FVATD45N> as of v3.0.3 the refresh token should automatically get updated so after the initial connector configuration you should be good to go. The easiest way to get the realm id, access token and initial refresh token is through the quickbooks/intuit <https://developer.intuit.com/app/developer/qbo/docs/develop/authentication-and-authorization/oauth-2.0-playground|playground here>. Definitely check out <https://docs.airbyte.com/integrations/sources/quickbooks|the docs here> as well.

4

Oh, right on! I just upgraded my connector to that version and will test today :call_me_hand: