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 Type

Airbyte Type

Notes

string

string

number

number

array

array

object

object

Features

Feature

Supported?(Yes/No)

Notes

Full Refresh Sync

Yes

Incremental Sync

Yes

SSL connection

Yes

Namespaces

No

Getting started

  1. Create an app

  2. 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.