Query OData data via destination, system or URL
query_odata_dataRun OData queries on SAP entity sets and get JSON rows. Supports $filter, $select, $expand, $top, $skip, $orderby, and $count across BTP destinations, SAP systems, or full service URLs.
Instructions
Executes an OData query (V2 or V4) against an entity set and returns the rows as JSON. Target: a BTP destination (destination + optional servicePath), a configured SAP system (systemName + servicePath from list_sap_systems), or a full serviceUrl. Supports $filter, $top, $skip, $select, $orderby, $expand and $count. This is the remote counterpart of query_cap_data.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | $top (max rows returned by the service, default 50) | |
| skip | No | $skip | |
| count | No | Ask the service for the total number of rows | |
| expand | No | $expand navigation properties, e.g. '_Travel,_Agency' | |
| filter | No | OData $filter, e.g. "Status eq 'A' and Price gt 100" | |
| select | No | $select comma-separated fields | |
| maxRows | No | Max rows included in the tool output (safety limit) | |
| orderBy | No | $orderby, e.g. 'CreatedAt desc' | |
| entitySet | Yes | Entity set name, e.g. 'Travel' or 'Products' | |
| serviceUrl | No | Full service URL (used when no destination/system is given) | |
| systemName | No | Configured SAP system name (see list_sap_systems) | |
| destination | No | BTP destination name (see list_btp_destinations) | |
| servicePath | No | Service path relative to the destination/system URL, e.g. /sap/opu/odata4/sap/zui_travel_ov4/srv | |
| odataVersion | No | Service OData version. Only affects how the total is requested: $count=true in V4, $inlinecount=allpages in V2. When omitted, V4 is tried first and V2 is retried automatically if the service rejects it. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| count | Yes | Rows in this response | |
| total | No | Total rows reported by the service (only when count:true was requested) | |
| source | Yes | ||
| hasMore | Yes | ||
| nextSkip | Yes | Value to pass as skip on the next call, or null | |
| rowCount | Yes | Deprecated alias of count; use count | |
| appliedUrl | Yes | ||
| destination | No | ||
| inlineCount | No | Raw $count value reported by the service | |
| truncatedTo | No | Set when the service returned more rows than maxRows | |
| odataVersion | Yes | Convention used to request the total: '4.0' ($count) or '2.0' ($inlinecount) |