QuickBooks
QuickBooks ETL connector for data replication
Snapshot
Features | Details |
Release Status | Released |
Source API Version | v2 |
Table Selection | Yes |
Column Selection | Yes |
Edit Integration | Yes |
Replication Type Selection | No |
Authentication Parameters | Quickbooks email Quickbooks password |
Replication Type | Full Replication Key based Replication |
Replication Key | NA DATE |
Suggested Replication Frequency | 24 hrs |
Tables/APIs Supported | |
Bills | Accounts |
Companyinfo | Invoice |
Preferences | Purchase |
Vendor | TaxAgency |
Payment | Item |
Employee | Customer |
Integrate Quickbooks with Daton
Signin to Daton
Select quickbooks from Integrations page
Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
Provide your quickbooks account email and Password.
After providing the email and password it prompts for the company, select the company to authorize Daton to periodically extract data from quickbooks.
Post successful authentication you will be prompted to choose from the list of available tables
Then select all required fields for each table
Submit the integration.
Workflow
Integrations would be in Pending state initially and will be moved to Active state as soon as the first job loads data successfully on to the configured warehouse
Users would be able to edit/pause/re-activate/delete integration anytime
Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
QUICKBOOKS Data
Bills
Purpose: Returns all the results of bills.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/bill#query-a-bill
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
DueDate | DATE |
Balance | NUMERIC |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
TxnDate | DATE |
CurrencyRef | RECORD |
Line | RECORD |
TxnTaxDetail | RECORD |
VendorRef | RECORD |
APAccountRef | RECORD |
TotalAmt | NUMERIC |
GlobalTaxCalculation | STRING |
Accounts
Purpose: Returns a list of all the accounts.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/account#query-an-account
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Name | STRING |
SubAccount | BOOLEAN |
FullyQualifiedName | STRING |
Active | BOOLEAN |
Classification | STRING |
AccountType | STRING |
AccountSubType | STRING |
CurrentBalance | NUMERIC |
CurrentBalanceWithSubAccounts | NUMERIC |
CurrencyRef | RECORD |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
Companyinfo
Purpose:Returns the results of all the companies and their info.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/companyinfo#query-companyinfo
Replication: Full Replication
Replication Key: NA
Fields
Name | Target Datatype |
CompanyName | STRING |
LegalName | STRING |
CompanyAddr | RECORD |
CustomerCommunicationAddr | RECORD |
LegalAddr | RECORD |
CompanyStartDate | DATE |
FiscalYearStartMonth | STRING |
Country | STRING |
RECORD | |
SupportedLanguages | STRING |
NameValue | RECORD |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
Invoice
Purpose:Returns a result of all the invoices generated.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/invoice#query-an-invoice
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
AllowIPNPayment | BOOLEAN |
AllowOnlinePayment | BOOLEAN |
AllowOnlineCreditCardPayment | BOOLEAN |
AllowOnlineACHPayment | BOOLEAN |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
DocNumber | INTEGER |
TxnDate | DATE |
CurrencyRef | RECORD |
LinkedTxn | RECORD |
Line | RECORD |
TxnTaxDetail | RECORD |
CustomerRef | RECORD |
FreeFormAddress | BOOLEAN |
SalesTermRef | RECORD |
DueDate | DATE |
GlobalTaxCalculation | STRING |
TotalAmt | NUMERIC |
PrintStatus | STRING |
EmailStatus | STRING |
Balance | NUMERIC |
DiscountAmt | NUMERIC |
Preferences
Purpose:Returns a result of all the preferences.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/preferences#query-preferences
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
AccountingInfoPrefs | RECORD |
ProductAndServicesPrefs | RECORD |
SalesFormsPrefs | RECORD |
EmailMessagesPrefs | RECORD |
VendorAndPurchasesPrefs | RECORD |
TimeTrackingPrefs | RECORD |
TaxPrefs | RECORD |
CurrencyPrefs | RECORD |
ReportPrefs | RECORD |
domain | STRING |
sparse | BOOLEAN |
Id | STRING |
SyncToken | STRING |
MetaData | RECORD |
Purchase
Purpose: Returns a list of all the purchases made.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/purchase#query-a-purchase
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
AccountRef | RECORD |
PaymentType | STRING |
TotalAmt | NUMERIC |
PrintStatus | STRING |
GlobalTaxCalculation | STRING |
PurchaseEx | RECORD |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
DocNumber | STRING |
TxnDate | DATE |
CurrencyRef | RECORD |
Line | RECORD |
Vendor
Purpose:Returns list of all the vendors.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/vendor#query-a-vendor
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Balance | NUMERIC |
Vendor1099 | BOOLEAN |
CurrencyRef | RECORD |
GSTIN | STRING |
GSTRegistrationType | STRING |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
DisplayName | STRING |
PrintOnCheckName | STRING |
Active | BOOLEAN |
TaxAgency
Purpose:Returns a list of all the taxes generated.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/taxagency#query-a-taxagency
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
TaxTrackedOnPurchases | BOOLEAN |
TaxTrackedOnSales | BOOLEAN |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
DisplayName | STRING |
Payment
Purpose:Returns a list of all the payments.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/payment#query-a-payment
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
CustomerRef | RECORD |
DepositToAccountRef | RECORD |
PaymentMethodRef | RECORD |
PaymentRefNum | INTEGER |
TotalAmt | NUMERIC |
UnappliedAmt | NUMERIC |
ProcessPayment | BOOLEAN |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
TxnDate | DATE |
CurrencyRef | RECORD |
Line | RECORD |
Item
Purpose:Returns the list of all the items boughtsold by the company.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/item#query-an-item
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Name | STRING |
Active | BOOLEAN |
FullyQualifiedName | STRING |
Taxable | BOOLEAN |
SalesTaxIncluded | BOOLEAN |
UnitPrice | NUMERIC |
Type | STRING |
IncomeAccountRef | RECORD |
PurchaseTaxIncluded | BOOLEAN |
PurchaseCost | NUMERIC |
TrackQtyOnHand | BOOLEAN |
AbatementRate | NUMERIC |
ReverseChargeRate | NUMERIC |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
Employee
Purpose: Returns the list of all the employees in the company.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/employee#query-an-employee
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
EmployeeNumber | STRING |
SSN | STRING |
PrimaryAddr | RECORD |
BillableTime | BOOLEAN |
BillRate | NUMERIC |
BirthDate | DATE |
Gender | STRING |
HiredDate | DATE |
ReleasedDate | DATE |
V4IDPseudonym | STRING |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
Title | STRING |
GivenName | STRING |
FamilyName | STRING |
DisplayName | STRING |
PrintOnCheckName | STRING |
Active | BOOLEAN |
Customer
Purpose: Returns the list of all the customers.
Source API Documentation https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/customer#query-a-customer
Replication: Key-Based Replication
Replication Key: lastRunDate
Fields
Name | Target Datatype |
Taxable | BOOLEAN |
Job | BOOLEAN |
BillWithParent | BOOLEAN |
Balance | NUMERIC |
BalanceWithJobs | INTEGER |
CurrencyRef | RECORD |
PreferredDeliveryMethod | STRING |
IsProject | BOOLEAN |
GSTRegistrationType | STRING |
domain | STRING |
sparse | BOOLEAN |
Id | INTEGER |
SyncToken | STRING |
MetaData | RECORD |
GivenName | STRING |
FullyQualifiedName | STRING |
DisplayName | STRING |
PrintOnCheckName | STRING |
Active | BOOLEAN |
Last updated