Back to QuickBooks Bill Payments
Connect Knoon AI with QuickBooks Bill Payments (QuickBooks) to automate AI workflows.
Run a QuickBooks Online SQL-like query for bill payments (defaults to SELECT * FROM BillPayment).
quickBooksBillPaymentQuery
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 | Bill payment ID. |
| vendorId | string | Vendor ID. |
| txnDate | string | Transaction date. |
| totalAmount | number | Total amount. |
| payType | string | Payment method type. |
| apAccountId | string | Accounts payable account ID. |
| bankAccountId | string | Bank or credit-card account ID used to pay. |
| privateNote | string | Private note. |
| currencyCode | string | Currency code. |
| syncToken | string | Sync token for updates. |
