[REST] - Oracle HCM import job fails to import user with query filter for Termination Date

[ganimkt]

Hello Everyone,

I am not able to use query parameter in postman for an attribute called personid and I am also able to pull the record using the same URL in Saviynt. See below screenshot for reference. 

Similarly I am not able pull the records using the query parameter workRelationships.TerminationDate in Saviynt. But I can pull the records in Saviynt using the same URL with query parameter.

Below are the links that are working in Postman but not working Saviynt.

https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber,addresses,names,emails,phones,workRelationships;workRelationships:assignments,workRelationshipsDFF;workRelationships.assignments:assignmentsDFF,managers&limit=50&offset=0&totalResults=true&q=workRelationships.TerminationDate%3D%272024%2D09%2D02%27 

https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber,addresses,names,emails,phones,workRelationships;workRelationships:assignments,workRelationshipsDFF;workRelationships.assignments:assignmentsDFF,managers&totalResults=true&limit=50&q=workRelationships.TerminationDate>'2024-09-01'%20and%20workRelationships.TerminationDate<'2024-09-28 '

"url": "https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber,addresses,names,emails,phones,workRelationships;workRelationships:assignments,workRelationshipsDFF;workRelationships.assignments:assignmentsDFF,managers&totalResults=true&limit=50&q=workRelationships.TerminationDate >'2024-09-01'%20and%20workRelationships.TerminationDate<'2024-09-28'

"url": "https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber,addresses,names,emails,phones,workRelationships;workRelationships:assignments,workRelationshipsDFF;workRelationships.assignments:assignmentsDFF,managers&totalResults=true&limit=50&q=workRelationships.TerminationDate='2024-09-02 '",

Please suggest on this.

[This message has been edited by moderator to disable URL hyperlink]

[NM]

@ganimkt can you resend the full link in text instead hyperlink.. having issues accessing it.

[ganimkt]

@NM Sure,  Here it is https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber,addresses,names,emails,phones,workRelationships;workRelationships:assignments,workRelationshipsDFF;workRelationships.assignments:assignmentsDFF,managers&totalResults=true&limit=50&q=workRelationships.TerminationDate >'2024-09-01'%20and%20workRelationships.TerminationDate<'2024-09-28'

PLease note that, in the above URL %20 means space, url encoding u can remove and keep space as well, that is also working.