Entity → Get Many
AI-generatedSummary
Retrieve multiple entities from a specified SAP OData service and entity set, optionally filtering, sorting, expanding, and paginating the results using OData query parameters.
Inputs
- Authentication (required) — Select the authentication method to connect to the SAP OData service (Basic Auth / None, None for public services, or OAuth2).
- Service (required) — Specify the SAP OData service path either by selecting from a list or entering the path manually (e.g. /sap/opu/odata/sap/API_BUSINESS_PARTNER/).
- Entity Set (required) — Choose the entity set to query from the selected service by selecting from a list or entering its name/URL directly (e.g. A_SalesOrder, ProductSet).
- Query Parameters — Use OData query options like $filter, $select, $expand, $orderby, $top, $skip, $count, $apply, and $search to filter, shape, and paginate the returned entities.
- Options (Advanced) — Additional settings including data type conversion, removal of metadata fields, cache clearing before execution, and inclusion of execution metrics.
Output shape
a list of JSON objects representing the retrieved entities, with optional metadata fields removed or added metrics if enabled
By default, the operation returns a limited number of entities (default 50). The limit can be adjusted with $top or the limit parameter. Supports pagination using batch size to retrieve large result sets. Data types are optionally converted from SAP-specific formats to native JavaScript types. Metadata fields (__metadata) can be removed for cleaner output. Execution metrics are appended to the last item if enabled. Authentication supports Basic, None, and OAuth2 methods depending on SAP service type.
Examples
Example 1: Retrieve all customers from the CustomerSet entity of the SAP API_BUSINESS_PARTNER service with names starting with 'A', selecting only CustomerID and CustomerName fields.
Service path set to the API_BUSINESS_PARTNER service, Entity Set to CustomerSet, $filter to 'startswith(Name,'A')', $select to 'CustomerID,CustomerName', with returnAll enabled.