Query SAP data
sap_queryQuery SAP OData V2 entity sets to filter, select, order, expand, page, and count records for targeted data retrieval.
Instructions
Read records from an SAP OData V2 entity set using OData query options. Filter syntax examples: "SalesOrderType eq 'OR'", "TotalNetAmount gt 1000", "substringof('Inc', BusinessPartnerName)". Dates: "CreationDate ge datetime'2024-01-01T00:00:00'".
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"service": "<service>",
"entitySet": "<entitySet>"
},
"name": "sap_query"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top | No | Max rows (server caps this) | |
| skip | No | ||
| count | No | Include total matching row count | |
| expand | No | Navigation properties to include, e.g. to_Item | |
| filter | No | OData V2 $filter expression | |
| select | No | Fields to return (keep it small!) | |
| orderBy | No | e.g. ["CreationDate desc"] | |
| service | Yes | Service name from sap_list_services | |
| entitySet | Yes | Entity set, e.g. A_SalesOrder |