Back to QuickBooks Purchases
Connect Knoon AI with QuickBooks Purchases (QuickBooks) to automate AI workflows.
Run a QuickBooks Online SQL-like query for Purchase (defaults to SELECT * FROM Purchase).
quickBooksPurchaseQuery
BETA
Internal
Permissions
Optional permissions
There are no items to display.
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| query | mustache | Optional. Full QBO query to run. If omitted, the backend uses the default query for this entity. | No |
| minorVersion | mustache | Optional QuickBooks minor version (defaults to 75). | No |
Returns
| Name | Type | Description |
|---|---|---|
| id | string | Record ID. |
| name | string | Name or display name. |
| docNumber | string | Document number. |
| txnDate | string | Transaction date. |
| totalAmount | number | Total amount. |
| active | boolean | Whether the record is active. |
| syncToken | string | Sync token. |
| currencyCode | string | Currency code. |
QuickBooks Bookkeeping (With VAT/GST) & OneDrive Upload
Automate QuickBooks bookkeeping with bill processing, duplicate checks, unpaid bill payments, and OneDrive receipt filing.
6 min
Record Receipts & Attachments in QuickBooks (Without VAT/GST)
Records no-tax receipts in QuickBooks and attaches the original receipt file to each transaction.
4 min