Skip to Content
Technical Articles

SAP Commissions – RestAPI filtering Parameter 🧩

API design is becoming a core pillar of API product strategy regardless if the API is public or used internally. Good API design improves the overall Developer Experience. It provides the filter the parameter to fetch your content with endless possibilities!

Filtering

  1. Used to filter result set and narrow down result set or drill down into the results
  2. Controlled via special input parameter called “filters” containing JSON structure inside the value
  3. Multiple filters can be chained together inside the same JSON structure, simply add another filter field definition after the first one
  4. Multiple value formats for each key are supported inside JSON structure including simple string/scalar, array, or associative array ( key => value )


Refer API Documentation

A practical examples of a filter:

The filter query parameter is used to filter items in a resource collection to return a subset of resources in response. The subset includes only those resources that satisfy the parameter value specified in the query

Example 1: To return results for 1 transaction record from Sales Transactions

Example 2: To return results from a field name in the following request :

Example 3: In this scenario, more than one field is passed in the filtering parameter

Example 4: In this scenario, more than one field is passed in the filtering parameter but operator sign checks for greater than (gt) field value

Example 5: In this scenario, the filtering parameter is a little complex expression but operator sign checks for greater than (gt) field value with subfields.

Example 6: In this, the complex expression is passed in the filtering parameter with grouping open & close () and OR condition to check if not equal null


Please feel free to reach out in case of any clarifications/API development work for your Project

Kindly share this blog with your friends below the icons.

4 Comments
You must be Logged on to comment or reply to a post.