AroFlo: Query Zone
aroflo_query_zoneQuery AroFlo zones with WHERE/ORDER/JOIN clauses to filter, sort, and join data. Use compact mode and field selection to reduce payload size and retrieve specific information from the AroFlo API.
Instructions
Query an arbitrary AroFlo zone using WHERE/ORDER/JOIN clauses. Use pipe-delimited WHERE clauses like "and|field|=|value", ORDER clauses like "field|asc", and JOIN areas like "lineitems". where/order/join accept either a single string or an array. Set compact=true and optionally select=["field","nested.field"] to reduce payload size. mode: data|verbose|debug|raw (default: data). See resource "aroflo://docs/api" for the extracted zone docs.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| zone | Yes | ||
| where | No | ||
| order | No | ||
| join | No | ||
| page | No | ||
| pageSize | No | ||
| autoPaginate | No | ||
| maxPages | No | ||
| maxResults | No | ||
| maxItemsTotal | No | ||
| validateWhere | No | ||
| mode | No | ||
| verbose | No | ||
| debug | No | ||
| raw | No | ||
| compact | No | ||
| select | No | ||
| maxItems | No | ||
| extra | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||