Quickbooks
info
API Documentation: Quickbooks API Documentation
The QuickBooks Online Accounting API allows you to access and manage financial data related to your business’s accounting records. The integration focuses on pulling data for the following types of reports:
- Account Information Reports: These reports provide detailed information about the various accounts within your QuickBooks Online organization, including account types, names, balances, and transactions. This data is useful for understanding your financial structure and managing assets, liabilities, and equity accounts.
- Transaction Reports: These reports provide insights into the transactions associated with each account, including journal entries, bills, invoices, and payments. This data helps track financial activity and ensure accurate bookkeeping for business operations.
Source Setup Guide
Step 1
in the Edit Source form to the left.
Step 2
Follow the authentication flow (OAuth) in Quickbooks's website to grant Extract the required permissions.
Step 3
Confirm you can see your email and profile picture, and that the source is Connected.
Connection Setup Guide
Once you conneted Quickbooks to a destination, you will also need to configure:
- Connection Pull Schedule: Determines how frequently data is extracted from the source.
- Backfill (Days): Specifies the duration for which historical data will be retrieved during each connection run.
- Destination specific settings: different settings such as "Dataset Name" or "Target Schema" (depanding on your destination)
- Schema Migration Policy: Controls how Extract will handle schema changes from the sourcee source.
Connector Information
Schema ERD
Explore the interactive entity relationship diagram for Quickbooks.
Data Streams
account
Loading ....
bill_line
Loading ....
bill_linked_txn
Loading ....
bill_payment_line
Loading ....
bill_payment
Loading ....
bill
Loading ....
budget_detail
Loading ....
budget
Loading ....
credit_memo_line
Loading ....
credit_memo
Loading ....
customer
Loading ....
deposit_line
Loading ....
deposit
Loading ....
employee
Loading ....
estimate_custom_field
Loading ....
estimate_line
Loading ....
estimate_linked_txn
Loading ....
estimate
Loading ....
invoice_custom_field
Loading ....
invoice_line
Loading ....
invoice_linked_txn
Loading ....
invoice
Loading ....
item
Loading ....
journal_entry_line
Loading ....
journal_entry
Loading ....
payment_line
Loading ....
payment_method
Loading ....
payment
Loading ....
purchase_line
Loading ....
purchase_linked_txn
Loading ....
purchase_order_custom_field
Loading ....
purchase_order_line
Loading ....
purchase_order
Loading ....
purchase
Loading ....
refund_receipt_custom_field
Loading ....
refund_receipt_line
Loading ....
refund_receipt
Loading ....
sales_receipt_custom_field
Loading ....
sales_receipt_line
Loading ....
sales_receipt_linked_txn
Loading ....
sales_receipt
Loading ....
term
Loading ....
time_activity
Loading ....
transfer
Loading ....
vendor_credit_line
Loading ....
vendor_credit_linked_txn
Loading ....
vendor_credit
Loading ....
vendor
Loading ....