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.
This Source is capable of syncing the following Streams:
- Accounts
- BillPayments
- Budgets
- Bills
- Classes
- CreditMemos
- Customers
- Departments
- Deposits
- Employees
- Estimates
- Invoices
- Items
- JournalEntries
- Payments
- PaymentMethods
- Purchases
- PurchaseOrders
- RefundReceipts
- SalesReceipts
- TaxAgencies
- TaxCodes
- TaxRates
- Terms
- TimeActivities
- Transfers
- VendorCredits
- Vendors
| Integration Type | Airbyte Type | Notes |
|---|---|---|
string |
string |
|
number |
number |
|
array |
array |
|
object |
object |
| Feature | Supported?(Yes/No) | Notes |
|---|---|---|
| Full Refresh Sync | Yes | |
| Incremental Sync | Yes | |
| SSL connection | Yes | |
| Namespaces | No |
- Create an Intuit Developer account
- Create an app
- Obtain credentials
- 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.
| Version | Date | Pull Request | Subject |
|---|---|---|---|
0.1.3 |
2021-08-10 | 4986 | Using number data type for decimal fields instead string |
0.1.2 |
2021-07-06 | 4539 | Add AIRBYTE_ENTRYPOINT for Kubernetes support |