Human Capital Management Blogs by SAP
Get insider info on HCM solutions for core HR and payroll, time and attendance, talent management, employee experience management, and more in this SAP blog.
cancel
Showing results for 
Search instead for 
Did you mean: 
yogananda
Product and Topic Expert
Product and Topic Expert
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


Example 7: In this scenario, using expand - will retrieve PayeeId , Position Name and Period with
filtering parameter becomes a little complex expression but will filter payment results only for single PayeeId


Example 8: In this scenario, Payments - you will have to include Accept : application/json




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.
6 Comments