fetch_query
Execute FETCH queries on ONE Framework for retrieving, filtering, aggregating, and exploring data across linked entities, enabling reports and data model discovery.
Instructions
Execute a FETCH query against the ONE Framework instance. FETCH is a custom query language for retrieving, filtering, and aggregating data from one or more entities. Use this to: explore data, discover relationships, run reports, and understand the data model.
Syntax examples:
FETCH entity (key, name) LIMIT 10— basic retrievalFETCH entity (key, name) FILTER name CONTAINS "invoice"— filteredFETCH invoice (key, total) { invoice_item TO invoice (key, product_name) }— with linked entities
The query is always executed under the security privileges of the authenticated user.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | The FETCH query to execute. Must start with FETCH. |