You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
45
Views
1
Comments
edited Jul 2, 2020 10:03AM in Visual Builder 1 comment

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!