Back to QuickBooks Customers
Connect Knoon AI with QuickBooks Customers (QuickBooks) to automate AI workflows.
Run a QuickBooks Online SQL-like query for customers (defaults to SELECT * FROM Customer).
quickBooksCustomerQuery
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 | Customer ID. |
| displayName | string | Display name. |
| givenName | string | Given name. |
| familyName | string | Family name. |
| companyName | string | Company name. |
| primaryEmail | string | Primary email. |
| phone | string | Primary phone. |
| balance | number | Open balance. |
| active | boolean | Whether the customer is active. |
| syncToken | string | Sync token for updates. |
