execute_odata_query
Execute CRUD operations on SAP S/4HANA OData services. GET returns CSV data; POST, PATCH, DELETE return JSON results. Supports filtering, selecting, pagination, and key-based access.
Instructions
Executes OData CRUD operations against SAP S/4HANA. GET requests return data as CSV for easy reading. POST, PATCH, and DELETE return JSON with the operation result. Use discover_sap_services to find service names, get_entity_metadata for field names, and get_field_values for valid input values before writing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| service | Yes | OData service name, e.g. API_BUSINESS_PARTNER | |
| entity | Yes | Entity set name, e.g. A_BusinessPartner | |
| method | No | HTTP method — GET reads (returns CSV), POST creates, PATCH updates, DELETE removes | GET |
| entityKey | No | Key predicate for a single-record operation, e.g. "'1000001'" or "BusinessPartner='1000001'" | |
| filter | No | OData $filter expression, e.g. "BusinessPartnerCategory eq '1'" | |
| select | No | Fields to return, e.g. ["BusinessPartner", "BusinessPartnerFullName"] | |
| top | No | Maximum rows to return for GET requests (default 100) | |
| skip | No | Rows to skip for GET pagination | |
| orderBy | No | OData $orderby expression, e.g. "BusinessPartner asc" | |
| payload | No | Request body for POST and PATCH operations |