QuickBooks Online connector for Amazon AppFlow
QuickBooks Online is a cloud-based accounting solution for businesses. If you're a QuickBooks Online user, your account contains data about your accounts, customers, invoices, and more. You can use Amazon AppFlow to transfer data from QuickBooks Online to certain AWS services or other supported applications.
Amazon AppFlow support for QuickBooks Online
Amazon AppFlow supports QuickBooks Online as follows.
- Supported as a data source?
Yes. You can use Amazon AppFlow to transfer data from QuickBooks Online.
- Supported as a data destination?
No. You can't use Amazon AppFlow to transfer data to QuickBooks Online.
Before you begin
To use Amazon AppFlow to transfer data from QuickBooks Online to supported destinations, you must meet these requirements:
-
You have an account with QuickBooks Online that contains the data that you want to transfer. For more information about the QuickBooks Online data objects that Amazon AppFlow supports, see Supported objects.
-
In your Intuit developer account, you've created an app for Amazon AppFlow. This app provides the client credentials that Amazon AppFlow uses to access your data securely when it makes authenticated calls to your account. For the steps to create an app, see Create and start developing your app
in the Intuit Developer documentation. -
You've configured your app to permit the
com.intuit.quickbooks.accounting
scope.
Note the following values because you specify them in the connection settings in Amazon AppFlow.
-
The client ID and client secret from your app settings.
-
The company ID from your QuickBooks Online account settings.
Connecting Amazon AppFlow to your QuickBooks Online account
To connect Amazon AppFlow to your QuickBooks Online account, provide details from your app so that Amazon AppFlow can access your data. If you haven't yet configured your QuickBooks Online account for Amazon AppFlow integration, see Before you begin.
To connect to QuickBooks Online
Sign in to the AWS Management Console and open the Amazon AppFlow console at https://console.aws.amazon.com/appflow/
. -
In the navigation pane on the left, choose Connections.
-
On the Manage connections page, for Connectors, choose QuickBooks Online.
-
Choose Create connection.
-
In the Connect to QuickBooks Online window, enter the following information:
-
Client ID – The client ID from your app settings.
-
Client secret – The client secret from your app settings.
-
Instance URL – The endpoint where Amazon AppFlow sends requests to access your data. Choose one of the following:
-
https://sandbox-quickbooks.api.intuit.com – The base URL for the QuickBooks Online development environment. For more information about this environment and the data that it contains, see Create and test with a sandbox company
in the Intuit Developer documentation. -
https://quickbooks.api.intuit.com – The base URL for the QuickBooks Online production environment.
-
-
QuickBooks CompanyId – The company ID from your QuickBooks Online account settings.
-
-
Optionally, under Data encryption, choose Customize encryption settings (advanced) if you want to encrypt your data with a customer managed key in the AWS Key Management Service (AWS KMS).
By default, Amazon AppFlow encrypts your data with a KMS key that AWS creates, uses, and manages for you. Choose this option if you want to encrypt your data with your own KMS key instead.
Amazon AppFlow always encrypts your data during transit and at rest. For more information, see Data protection in Amazon AppFlow.
If you want to use a KMS key from the current AWS account, select this key under Choose an AWS KMS key. If you want to use a KMS key from a different AWS account, enter the Amazon Resource Name (ARN) for that key.
-
For Connection name, enter a name for your connection.
-
Choose Continue.
-
In the window that appears, sign in to your Intuit account, and grant access to Amazon AppFlow.
On the Manage connections page, your new connection appears in the Connections table. When you create a flow that uses QuickBooks Online as the data source, you can select this connection.
Transferring data from QuickBooks Online with a flow
To transfer data from QuickBooks Online, create an Amazon AppFlow flow, and choose QuickBooks Online as the data source. For the steps to create a flow, see Creating flows in Amazon AppFlow.
When you configure the flow, choose the data object that you want to transfer. For the objects that Amazon AppFlow supports for QuickBooks Online, see Supported objects.
Also, choose the destination where you want to transfer the data object that you selected. For more information about how to configure your destination, see Supported destinations.
Supported destinations
When you create a flow that uses QuickBooks Online as the data source, you can set the destination to any of the following connectors:
Supported objects
When you create a flow that uses QuickBooks Online as the data source, you can transfer any of the following data objects to supported destinations:
Object |
Field |
Data type |
Supported filters |
---|---|---|---|
Account |
AccountAlias |
String |
|
AccountSubType |
String |
||
AccountType |
Struct |
||
AcctNum |
String |
||
Active |
Boolean |
EQUAL_TO |
|
Classification |
String |
||
CreateTime |
DateTime |
||
CurrencyRef |
Struct |
||
CurrentBalance |
BigDecimal |
||
CurrentBalanceWithSubAccounts |
BigDecimal |
||
Description |
String |
||
FullyQualifiedName |
String |
||
Id |
String |
||
LastUpdatedTime |
DateTime |
||
Name |
String |
||
ParentRef |
Struct |
||
SubAccount |
Boolean |
EQUAL_TO |
|
SyncToken |
String |
||
TaxCodeRef |
Struct |
||
TxnLocationType |
String |
||
Bill |
APAccountRef |
Struct |
|
Balance |
BigDecimal |
||
CreateTime |
DateTime |
||
CurrencyRef |
Struct |
||
DepartmentRef |
Struct |
||
DocNumber |
String |
||
DueDate |
Date |
||
ExchangeRate |
BigDecimal |
||
GlobalTaxCalculation |
Struct |
||
HomeBalance |
BigDecimal |
||
Id |
String |
||
IncludeInAnnualTPAR |
Boolean |
||
LastUpdatedTime |
DateTime |
||
Line |
Struct |
||
LinkedTxn |
Struct |
||
MetaData |
Struct |
||
PrivateNote |
String |
||
RecurDataRef |
Struct |
||
SalesTermRef |
Struct |
||
SyncToken |
String |
||
TotalAmt |
BigDecimal |
||
TransactionLocationType |
String |
||
TxnDate |
Date |
||
TxnTaxDetail |
Struct |
||
VendorRef |
Struct |
||
Company Info |
CompanyAddr |
Struct |
|
CompanyName |
String |
||
CompanyStartDate |
DateTime |
||
Country |
String |
||
CreateTime |
DateTime |
||
CustomerCommunicationAddr |
Struct |
||
Struct |
|||
FiscalYearStartMonth |
Struct |
||
Id |
String |
||
LastUpdatedTime |
DateTime |
||
LegalAddr |
Struct |
||
LegalName |
String |
||
MetaData |
Struct |
||
NameValue |
Struct |
||
PrimaryPhone |
Struct |
||
SupportedLanguages |
String |
||
SyncToken |
String |
||
WebAddr |
Struct |
||
Customer |
ARAccountRef |
Struct |
|
Active |
Boolean |
EQUAL_TO |
|
AlternatePhone |
Struct |
||
Balance |
BigDecimal |
||
BalanceWithJobs |
BigDecimal |
||
BillAddr |
Struct |
||
BillWithParent |
Boolean |
||
BusinessNumber |
String |
||
CompanyName |
String |
||
CreateTime |
DateTime |
||
CurrencyRef |
Struct |
||
CustomerTypeRef |
String |
||
DefaultTaxCodeRef |
Struct |
||
DisplayName |
String |
||
FamilyName |
String |
||
Fax |
Struct |
||
FullyQualifiedName |
String |
||
GSTIN |
String |
||
GSTRegistrationType |
String |
||
GivenName |
String |
||
Id |
String |
||
IsProject |
Boolean |
||
Job |
Boolean |
||
LastUpdatedTime |
DateTime |
||
Level |
BigInteger |
||
MetaData |
Struct |
||
MiddleName |
String |
||
Mobile |
Struct |
||
Notes |
String |
||
OpenBalanceDate |
Date |
||
ParentRef |
Struct |
||
PaymentMethodRef |
Struct |
||
PreferredDeliveryMethod |
String |
||
PrimaryEmailAddr |
Struct |
||
PrimaryPhone |
Struct |
||
PrimaryTaxIdentifier |
String |
||
PrintOnCheckName |
String |
||
ResaleNum |
String |
||
SalesTermRef |
Struct |
||
SecondaryTaxIdentifier |
String |
||
ShipAddr |
Struct |
||
Source |
String |
||
Suffix |
String |
||
SyncToken |
String |
||
TaxExemptionReasonId |
BigInteger |
||
Taxable |
Boolean |
||
Title |
String |
||
WebAddr |
Struct |
||
Employee |
Active |
Boolean |
EQUAL_TO |
BillRate |
BigDecimal |
||
BillableTime |
Boolean |
||
BirthDate |
Date |
||
CostRate |
BigDecimal |
||
CreateTime |
DateTime |
||
DisplayName |
String |
||
EmployeeNumber |
String |
||
FamilyName |
String |
||
Gender |
String |
||
GivenName |
String |
||
HiredDate |
Date |
||
Id |
String |
||
LastUpdatedTime |
DateTime |
||
MetaData |
Struct |
||
MiddleName |
String |
||
Mobile |
Struct |
||
Organization |
Boolean |
||
PrimaryAddr |
Struct |
||
PrimaryEmailAddr |
Struct |
||
PrimaryPhone |
Struct |
||
PrintOnCheckName |
String |
||
ReleasedDate |
Date |
||
SSN |
String |
||
Suffix |
String |
||
SyncToken |
String |
||
Title |
String |
||
V4IDPseudonym |
String |
||
Estimate |
AcceptedBy |
String |
|
AcceptedDate |
Date |
||
ApplyTaxAfterDiscount |
Boolean |
||
BillAddr |
Struct |
||
BillEmail |
Struct |
||
ClassRef |
Struct |
||
CreateTime |
DateTime |
||
CurrencyRef |
Struct |
||
CustomField |
Struct |
||
CustomerMemo |
Struct |
||
CustomerRef |
Struct |
||
DepartmentRef |
Struct |
||
DocNumber |
String |
||
DueDate |
Date |
||
EmailStatus |
String |
||
ExchangeRate |
BigDecimal |
||
ExpirationDate |
Date |
||
FreeFormAddress |
Boolean |
||
GlobalTaxCalculation |
Struct |
||
HomeTotalAmt |
BigDecimal |
||
Id |
String |
||
LastUpdatedTime |
DateTime |
||
Line |
Struct |
||
LinkedTxn |
Struct |
||
MetaData |
Struct |
||
PrintStatus |
String |
||
PrivateNote |
String |
||
RecurDataRef |
Struct |
||
SalesTermRef |
Struct |
||
ShipAddr |
Struct |
||
ShipDate |
Date |
||
ShipFromAddr |
Struct |
||
ShipMethodRef |
Struct |
||
SyncToken |
String |
||
TaxExemptionRef |
Struct |
||
TotalAmt |
BigDecimal |
||
TransactionLocationType |
String |
||
TxnDate |
Date |
||
TxnStatus |
String |
||
TxnTaxDetail |
Struct |
||
Invoice |
AllowOnlineACHPayment |
Boolean |
|
AllowOnlineCreditCardPayment |
Boolean |
||
ApplyTaxAfterDiscount |
Boolean |
||
Balance |
BigDecimal |
||
BillAddr |
Struct |
||
BillEmail |
Struct |
||
BillEmailBcc |
Struct |
||
BillEmailCc |
Struct |
||
ClassRef |
Struct |
||
CreateTime |
DateTime |
||
CurrencyRef |
Struct |
||
CustomField |
Struct |
||
CustomerMemo |
Struct |
||
CustomerRef |
Struct |
||
DeliveryInfo |
Struct |
||
DepartmentRef |
Struct |
||
Deposit |
BigDecimal |
||
DepositToAccountRef |
Struct |
||
DocNumber |
String |
||
DueDate |
Date |
||
EmailStatus |
String |
||
ExchangeRate |
BigDecimal |
||
FreeFormAddress |
Boolean |
||
GlobalTaxCalculation |
Struct |
||
HomeBalance |
BigDecimal |
||
HomeTotalAmt |
BigDecimal |
||
Id |
String |
||
InvoiceLink |
String |
||
LastUpdatedTime |
DateTime |
||
Line |
Struct |
||
LinkedTxn |
Struct |
||
MetaData |
Struct |
||
PrintStatus |
String |
||
PrivateNote |
String |
||
RecurDataRef |
Struct |
||
SalesTermRef |
Struct |
||
ShipAddr |
Struct |
||
ShipDate |
Date |
||
ShipFromAddr |
Struct |
||
ShipMethodRef |
Struct |
||
SyncToken |
String |
||
TaxExemptionRef |
Struct |
||
TotalAmt |
BigDecimal |
||
TrackingNum |
String |
||
TransactionLocationType |
String |
||
TxnDate |
Date |
||
TxnSource |
String |
||
TxnTaxDetail |
Struct |
||
Item |
AbatementRate |
BigDecimal |
|
Active |
Boolean |
EQUAL_TO |
|
AssetAccountRef |
Struct |
||
ClassRef |
Struct |
||
CreateTime |
DateTime |
||
Description |
String |
||
ExpenseAccountRef |
Struct |
||
FullyQualifiedName |
String |
||
Id |
String |
||
IncomeAccountRef |
Struct |
||
InvStartDate |
Date |
||
ItemCategoryType |
String |
||
LastUpdatedTime |
DateTime |
||
Level |
Integer |
||
MetaData |
Struct |
||
Name |
String |
||
ParentRef |
Struct |
||
PrefVendorRef |
Struct |
||
PurchaseCost |
BigDecimal |
||
PurchaseDesc |
String |
||
PurchaseTaxCodeRef |
Struct |
||
PurchaseTaxIncluded |
Boolean |
||
QtyOnHand |
BigDecimal |
||
ReorderPoint |
BigDecimal |
||
ReverseChargeRate |
BigDecimal |
||
SalesTaxCodeRef |
Struct |
||
SalesTaxIncluded |
Boolean |
||
ServiceType |
String |
||
Sku |
String |
||
Source |
String |
||
SubItem |
Boolean |
||
SyncToken |
String |
||
TaxClassificationRef |
Struct |
||
Taxable |
Boolean |
||
TrackQtyOnHand |
Boolean |
||
Type |
String |
||
UQCDisplayText |
String |
||
UQCId |
String |
||
UnitPrice |
BigDecimal |
||
Payment |
ARAccountRef |
Struct |
|
CreateTime |
DateTime |
||
CreditCardPayment |
Struct |
||
CurrencyRef |
Struct |
||
CustomerRef |
Struct |
||
DepositToAccountRef |
Struct |
||
ExchangeRate |
BigDecimal |
||
Id |
String |
||
LastUpdatedTime |
DateTime |
||
Line |
Struct |
||
MetaData |
Struct |
||
PaymentMethodRef |
Struct |
||
PaymentRefNum |
String |
||
PrivateNote |
String |
||
SyncToken |
String |
||
TaxExemptionRef |
Struct |
||
TotalAmt |
BigDecimal |
||
TransactionLocationType |
String |
||
TxnDate |
Date |
||
TxnSource |
String |
||
UnappliedAmt |
BigDecimal |
||
Preference |
AccountingInfoPrefs |
Struct |
|
CreateTime |
DateTime |
||
CurrencyPrefs |
Struct |
||
EmailMessagesPrefs |
Struct |
||
Id |
String |
||
LastUpdatedTime |
DateTime |
||
MetaData |
Struct |
||
OtherPrefs |
Struct |
||
ProductAndServicesPrefs |
Struct |
||
ReportPrefs |
Struct |
||
SalesFormsPrefs |
Struct |
||
SyncToken |
String |
||
TaxPrefs |
Struct |
||
TimeTrackingPrefs |
Struct |
||
VendorAndPurchasesPrefs |
Struct |
||
Profit And Loss |
Accounting Method |
String |
EQUAL_TO |
Adjusted Gain Loss |
String |
EQUAL_TO |
|
Class |
String |
EQUAL_TO |
|
Columns |
Struct |
||
Customer |
String |
EQUAL_TO |
|
Date Macro |
String |
EQUAL_TO |
|
Department |
String |
EQUAL_TO |
|
End Date |
Date |
EQUAL_TO |
|
Header |
Struct |
||
Item |
String |
EQUAL_TO |
|
Rows |
Struct |
||
Sort Order |
String |
EQUAL_TO |
|
Start Date |
Date |
EQUAL_TO |
|
Summarize Column By |
String |
EQUAL_TO |
|
Vendor |
String |
EQUAL_TO |
|
qzurl |
String |
EQUAL_TO |
|
Tax Agency |
CreateTime |
DateTime |
|
DisplayName |
String |
||
Id |
String |
||
LastFileDate |
Date |
||
LastUpdatedTime |
DateTime |
||
MetaData |
Struct |
||
SyncToken |
String |
||
TaxAgencyConfig |
String |
||
TaxRegistrationNumber |
String |
||
TaxTrackedOnPurchases |
Boolean |
||
TaxTrackedOnSales |
Boolean |
||
Vendor |
APAccountRef |
Struct |
|
AcctNum |
String |
||
Active |
Boolean |
EQUAL_TO |
|
AlternatePhone |
Struct |
||
Balance |
BigDecimal |
||
BillAddr |
Struct |
||
BillRate |
BigDecimal |
||
BusinessNumber |
String |
||
CompanyName |
String |
||
CostRate |
BigDecimal |
||
CreateTime |
DateTime |
||
CurrencyRef |
Struct |
||
DisplayName |
String |
||
FamilyName |
String |
||
Fax |
Struct |
||
GSTIN |
String |
||
GSTRegistrationType |
String |
||
GivenName |
String |
||
HasTPAR |
Boolean |
||
Id |
String |
||
LastUpdatedTime |
DateTime |
||
MetaData |
Struct |
||
MiddleName |
String |
||
Mobile |
Struct |
||
OtherContactInfo |
Struct |
||
PrimaryEmailAddr |
Struct |
||
PrimaryPhone |
Struct |
||
PrintOnCheckName |
String |
||
Source |
String |
||
Suffix |
String |
||
SyncToken |
String |
||
T4AEligible |
Boolean |
||
T5018Eligible |
Boolean |
||
TaxIdentifier |
String |
||
TaxReportingBasis |
String |
||
TermRef |
Struct |
||
Title |
String |
||
Vendor1099 |
Boolean |
||
VendorPaymentBankDetail |
Struct |
||
WebAddr |
Struct |