QuickBooks
Read records from QuickBooks Online into a Strata flow. One connection covers one company. Oplema can't write to QuickBooks.
Before you start
- A QuickBooks Online company you can sign in to.
- Permission Oplema asks for:
com.intuit.quickbooks.accounting. Oplema only reads with it. - Requests to QuickBooks come from Oplema's servers, not your browser. Oplema doesn't promise a fixed IP address; contact us if you need to allowlist.
Connect
- In Strata, select an Input block.
- Set Source to Connectors.
- In the connector dropdown below it, choose QuickBooks.
- Open the Connection dropdown and choose Create new connection.
- Set Name (optional). Without a name, the connection is labeled with the company ID. The dropdown always shows the company ID next to the name.
- Select Connect to QuickBooks. Intuit's own sign-in opens in a popup. Approve access there.
The popup closes, the new connection is selected and the pickers below it load. If access later expires or you need more permissions, select the connection, then select Reconnect to QuickBooks.
To read a second company, create a second connection.
Read
| Setting | What it does |
|---|---|
| Object | Invoice, Estimate, Sales receipt, Credit memo, Refund receipt, Customer payments, Bill, Vendor bill payments, Expenses, checks and card purchases, Purchase order, Vendor credit, Deposit, Transfer, Journal entry, Customer, Vendor, Employee, Account, Item, Class, Department, Term, Payment method, Tax code, Tax rate, Tax agency, Time activity, Attachment metadata, Budget, Recurring transactions, Company information or Company preferences. |
| Active status | For customers, vendors, accounts and other list objects: All records, Active only or Inactive only. |
| Transaction from and Transaction to | For transactions and time activity. Inclusive. Blank means no limit. |
| Rows | For invoices, bills and estimates: Records or Line items. Line items omit parent totals; join on ParentId and CompanyId. |
Select Refresh data to read again. Use Parse → JSON for nested details.
Limits and billing
- Reads: the first 50 MB of each download is free. After that, each download costs $0.01 per GB from your usage. Failed reads aren't charged, and a read stops when your usage runs out.
See Billing for who pays and how usage works.
Troubleshooting
| Message | What to do |
|---|---|
QuickBooks: <code>: <detail>. Reconnect this company. | Select Reconnect to QuickBooks. |
QuickBooks: <detail>. Retry after <n> seconds. | QuickBooks is rate-limiting. Wait, then run again. |
QuickBooks company changed. Create a separate connection for the other company. | You signed in to a different company while reconnecting. Reconnect to the original, or create a new connection. |
QuickBooks: missing or invalid company ID; reconnect this company | Select Reconnect to QuickBooks. |
QuickBooks: records repeated across pages; the company may have changed during this read. Refresh data. | Select Refresh data. |
This transfer exceeds the free 50 MB and the available usage credits | The read passed 50 MB and your usage ran out. Add usage, or read less data. |
Prepare your data. Build it in Strata.
Strata opens in your browser, with no account.