Perform advanced search -findByAdvancedSearchQuery Oracle Fusion HCM API
I am trying to call the following API:/hcmRestApi/resources/latest/dataLoadDataSets/action/findByAdvancedSearchQuery
I am passing the below request payload:
{
"filters": [{"CreatedBy": ["TestUser1","TestUser2"]}],
"limit": 5,
"displayFields": ["RequestId", "DataSetId", "DataSetName", "CreatedBy", "CreationDate"],
"sort": [{"name": "CreationDate", "direction": "desc"}]
}
However, the response is coming back as null with a 400 Bad Request error.
If I remove the "filters" attribute, the response returns successfully with 200 OK.
Can someone please help identify what is incorrect with the filters in request payload? Or if anyone has used query attribute?
Here's the oracle doc link: https://docs.oracle.com/en/cloud/saas/human-resources/farws/op-dataloaddatasets-action-findbyadvancedsearchquery-post.html