version: 1.0.0

Category: Finance

Tier: 3

Api minor version: 69

Type: Source

Authentication: OAuth

Resources Supported:

Reference: https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account

Resource Name

Account

Bill

BillPayment

Budget

Class

CreditMemo

Customer

CustomerType

Department

Deposit

Employee

Estimate

Invoice

Item

JournalEntry

PaymentMethod

Payment

PurchaseOrder

Purchase

RefundReceipt

SalesReceipt

TaxAgency

TaxCode

TaxRate

Term

TimeActivity

Transfer

Vendor

Connection Properties

Name

Mandatory

Description

Connection Name

Yes

Name of the connection

Description

No

Description of connection

image-20240331-000253.png

Creating a connection

image-20240331-000414.png

image-20240331-001118.png

Fields

The fields are based on schema defined in https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account but automatically flattened to be able to map easily

image-20240331-001502.png

Running a Pipeline with quickbooks as Source

image-20240331-001546.png

Quickbooks data:

image-20240331-001605.png

Target:

image-20240331-001616.png

NOTE: Refresh token expiration is 100 days, but the system every time it uses it checks the response if a new refresh token is available in the response and updates the connection details automatically. See

https://help.developer.intuit.com/s/article/Validity-of-Refresh-Token#:~:text=Each%20Refresh%20Token%20lasts%20up,API%20call%2C%20whichever%20is%20later.

Reauthorize:

If Refresh token has been stale or invalid or you are receiving invalid grant error, You can reauthorize your connection by clicking the Reauthorize button

image-20240331-001831.png