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

[ganimkt]

Hello Everyone,

Usecase: Importing Identities (users) from Oracle HCM ( Authoritative Source ) for users terminated with a specific date range.

Problem Statement: Saviynt fails to import users from Oracle HCM REST API when filtered with termination date. The same REST API filtered with termination date returns expected results in Postman. 

Details: 

Below are the URLs with different query filter parmeter that are working in Postman but fails when used in Saviynt for user import.

• https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber...>'2024-09-01'%20and%20workRelationships.TerminationDate<'2024-09-28 '
• https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber...
• https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber...>'2024-09-01'%20and%20workRelationships.TerminationDate<'2024-09-28 '
• https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber... >'2024-09-01'%20and%20workRelationships.TerminationDate<'2024-09-28'
• https://XXXXXXXX/hcmRestApi/resources/xx.xx.xx.xx/workers?onlyData=true&fields=PersonId,PersonNumber... '

I am also attaching the sample import JSON for your reference.

[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.