QuickBooks
QuickBooks ETL connector for data replication
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 |
- 1.Signin to Daton
- 2.Select quickbooks from Integrations page
- 3.Provide Integration Name Replication Frequency and History. Integration name would be used in creating tables for the integration and cannot be changed later
- 4.Provide your quickbooks account email and Password.
- 5.After providing the email and password it prompts for the company, select the company to authorize Daton to periodically extract data from quickbooks.
- 6.Post successful authentication you will be prompted to choose from the list of available tables
- 7.Then select all required fields for each table
- 8.Submit the integration.
- 1.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
- 2.Users would be able to edit/pause/re-activate/delete integration anytime
- 3.Users can view job status and process logs from the integration details page by clicking on the integration name from the active list
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.
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.
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 |
Email | 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.
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.
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.
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.
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.
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.
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 modified 28d ago