Back to QuickBooks Items
Connect Knoon AI with QuickBooks Items (QuickBooks) to automate AI workflows.
Run a QuickBooks Online SQL-like query for items (defaults to SELECT * FROM Item).
quickBooksItemQuery
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 | Item ID. |
| name | string | Item name. |
| type | string | Item type. |
| sku | string | SKU. |
| active | boolean | Whether the item is active. |
| unitPrice | number | Unit price. |
| incomeAccountId | string | Income account ID. |
| expenseAccountId | string | Expense account ID. |
| assetAccountId | string | Asset account ID. |
| syncToken | string | Sync token for updates. |
