Fetching data from REST API based on the child subset attributes - VBCS

Summary

Fetching data from REST API based on the child subset attributes - VBCS

Content

Hi All,

I have one REST API created service connection with that in VBCS, which returns all the parent and respective child (subsets - one or many subsets for each parent).There are one or more childObjects for each parentObject.

https://hostname//hcmRestApi/resources/11.13.18.05/parentObject?onlyData=true&expand=childObject&limit=1000

I have used query parameter (q) to filter the REST API response based on the parentObject attributes.
I want to know if there is a way to filter the records in GET operation by any of the attribute in childObject. Let's say childObject has an attribute "Date", then we need to check for every parentObject if any of the childObject's "Date" attribute is less than the sysdate(currentDate) and "Date" attribute is not NULL. Then to fetch only those records instead of all the records.