Run saved query
run_saved_queryExecutes an administrator-approved saved query against SAP Business One data, using only the saved query name, optional parameters, and row limit to return predefined business results without free SQL.
Instructions
Run a query that an administrator pre-registered in the saved-queries config file. No free SQL or free filters are accepted. Available: customers_over_balance: Customers whose account balance is above a threshold, highest first; invoices_due_before: Open A/R invoices due before a date; sales_by_month: Net A/R sales per month for a year (needs SQLQueries entry KN_SALES_BY_MONTH created by your admin)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | Yes | Saved query name | |
| limit | No | Max rows to return (1-50, default 20) | |
| params | No | Parameters declared by that saved query |