Skip to main content

QuickBooks

Overview

The QuickBooks source supports both Full Refresh and Incremental syncs. You can choose if this connector will copy only the new or updated data, or all rows in the tables and columns you set up for replication, every time a sync is run.

This source wraps the Singer QuickBooks Tap.

Output schema

This Source is capable of syncing the following Streams:

Data type mapping

Integration TypeAirbyte TypeNotes
stringstring
numbernumber
arrayarray
objectobject

Features

FeatureSupported?(Yes/No)Notes
Full Refresh SyncYes
Incremental SyncYes
SSL connectionYes
NamespacesNo

Getting started

  1. Create an Intuit Developer account
  2. Create an app
  3. Obtain credentials

Requirements

  • Client ID
  • Client Secret
  • Realm ID
  • Refresh token

The easiest way to get these credentials is by using Quickbook's OAuth 2.0 playground

Important note: The refresh token expires every 100 days. You will need to manually revisit the Oauth playground to obtain a refresh token every 100 days, or your syncs will expire. We plan on offering full Oauth support soon so you don't need to redo this process manually.

CHANGELOG

VersionDatePull RequestSubject
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