Skip to main content

QuickBooks

Availability
Available CoreAvailable StandardAvailable PlusAvailable ProAvailable Enterprise FlexAvailable Self-Managed EnterpriseAvailable PyAirbyte
Support Level
Marketplace
Connector Version
4.0.4 (last updated 9 months ago)
CDK Version
4.6.2
Sync Success Rate
Medium
Usage Rate
High
Data workers used
0.2 per sync (Learn more)
Definition ID
cf9c4355-b171-4477-8f2d-6c5cc5fc8b7e

This page contains the setup guide and reference information for the QuickBooks Source connector.

Prerequisites​

Setup guide​

Step 1: Set up QuickBooks​

  1. Create an Intuit Developer account
  2. Create an application
  3. Obtain credentials. The easiest way to get these credentials is by using Quickbook's OAuth 2.0 playground

Step 2: Set up the QuickBooks connector in Airbyte​

For Airbyte Cloud:

  1. Log into your Airbyte Cloud account.
  2. In the left navigation bar, click Sources. In the top-right corner, click + new source.
  3. On the source setup page, select QuickBooks from the Source type dropdown and enter a name for this connector.
  4. Client ID - The OAuth2.0 application ID
  5. Client Secret - The OAuth2.0 application secret
  6. Refresh Token - Refresh token used to get new access token every time the current one is expired
  7. Access Token - Access token to perform authenticated API calls with
  8. Token Expiry Date - DateTime when the access token becomes invalid
  9. Realm ID - The Labeled Company ID you'd like to replicate data for streams.
  10. Start date - The date starting from which you'd like to replicate data.
  11. Sandbox - Turn on if you're going to replicate the data from the sandbox environment.
  12. Click Set up source.

For Airbyte Open Source:

  1. Client ID - The OAuth2.0 application ID
  2. Client Secret - The OAuth2.0 application secret
  3. Refresh Token - Refresh token used to get new access token every time the current one is expired
  4. Access Token - Access token to perform authenticated API calls with
  5. Token Expiry Date - DateTime when the access token becomes invalid
  6. Realm ID - The Labeled Company ID you'd like to replicate data for streams.
  7. Start date - The date starting from which you'd like to replicate data.
  8. Sandbox - Turn on if you're going to replicate the data from the sandbox environment.

Supported sync modes​

The Quickbooks Source connector supports the following sync modes:

Supported Streams​

This Source is capable of syncing the following Streams:

Data type map​

Integration TypeAirbyte TypeNotes
stringstring
numbernumber
arrayarray
objectobject

IP allow list​

If you use Airbyte Cloud and your organization restricts access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Reference​

Config fields reference

Field
Type
Property name
string
access_token
string
client_id
string
client_secret
string
realm_id
string
refresh_token
boolean
sandbox
string
start_date
string
token_expiry_date
auth_type
"oauth2.0"
auth_type

Changelog​

Expand to review
VersionDatePull RequestSubject
4.1.82025-05-2460468Update dependencies
4.1.72025-05-1060170Update dependencies
4.1.62025-05-0359500Update dependencies
4.1.52025-04-2758481Update dependencies
4.1.42025-04-1257880Update dependencies
4.1.32025-04-0557355Update dependencies
4.1.22025-03-2956800Update dependencies
4.1.12025-03-2256202Update dependencies
4.1.02025-03-1455776Promoting release candidate 4.1.0-rc.1 to a main version.
4.1.0-rc.12025-03-1055263Migrate to manifest-only
4.0.42025-03-0855527Update dependencies
4.0.32025-03-0155075Update dependencies
4.0.22025-02-2354573Update dependencies
4.0.12025-02-1546789Update dependencies
4.0.02025-01-1851615Remove nested credentials object from config to enable overwriting of new refresh token in config
3.0.262024-11-0148089Promoting release candidate 3.0.26-rc.1 to a main version.
3.0.26-rc.12024-09-1044560Replace Custom Components with Airbyte CDK features
3.0.252024-10-0546424Update dependencies
3.0.242024-09-2846142Update dependencies
3.0.232024-09-2145727Update dependencies
3.0.222024-09-1445517Update dependencies
3.0.212024-09-0745231Update dependencies
3.0.202024-08-3144961Update dependencies
3.0.192024-08-2444713Update dependencies
3.0.182024-08-1744282Update dependencies
3.0.172024-08-1243829Update dependencies
3.0.162024-08-1043563Update dependencies
3.0.152024-08-0343052Update dependencies
3.0.142024-07-2742666Update dependencies
3.0.132024-07-2042358Update dependencies
3.0.122024-07-1341745Update dependencies
3.0.112024-07-1041414Update dependencies
3.0.102024-07-1041325Update dependencies
3.0.92024-07-0940660Fix configured catalog, inline schemas
3.0.82024-07-0640885Update dependencies
3.0.72024-06-2540355Update dependencies
3.0.62024-06-2239955Update dependencies
3.0.52024-06-0639285[autopull] Upgrade base image to v1.2.2
3.0.42024-05-2138518[autopull] base image + poetry + up_to_date
3.0.32024-03-2236389Add refresh token updater and add missing properties to streams
3.0.22024-02-2032236Small typo in spec correction
3.0.12023-11-0632236Upgrade to airbyte-cdk>=0.52.10 to resolve refresh token issues
3.0.02023-09-2630770Update schema to use number instead of integer
2.0.52023-09-2630766Fix improperly named keyword argument
2.0.42023-06-2827803Update following state breaking changes
2.0.32023-06-0827148Update description and example values of a Start Date in spec.json
2.0.22023-06-0726722Update CDK version and adjust authenticator configuration
2.0.12023-05-2826722Change datatype for undisclosed amount field in payments
2.0.02023-04-1125045Fix datetime format, disable OAuth button in cloud
1.0.02023-03-2024324Migrate to Low-Code
0.1.52022-02-1710346Update label Quickbooks -> QuickBooks
0.1.42021-12-208960Update connector fields title/description
0.1.32021-08-104986Using number data type for decimal fields instead string
0.1.22021-07-064539Add AIRBYTE_ENTRYPOINT for Kubernetes support
Was this page helpful?