Successfactor User Import not working

[AtrayeeDutta]

Hi Team,

We are trying to import a user using SucessFactor REST Connection with date filter one day from system date,

we are using the query: "${Calendar.getInstance().getTime().format(\"yyyy-MM-dd'T'HH:mm:ss'Z'\")}-1)"

We are getting below error after Import Job

Cannot invoke method get() on null object

Please let us know how we can resolve this.

[rushikeshvartak]

What if above condition removed ?

[AtrayeeDutta]

Hi Rushikesh,

Cannot invoke method get() on null object was due to connectionJSON issue, Job is running as success but it doesn't pull data, nothing is updated in JOB logs also. 

The issue is that if we try to run incremental import of users using SucessFactor REST Connection with date filter as one day from system date,"${Calendar.getInstance().getTime().format(\"yyyy-MM-dd'T'HH:mm:ss'Z'\")}-1)", it doesn't fetch users feed. Import Job runs but no Data, hard coding the date value also results in same pattern.

From Postman hard coded date works fine. Below is filter working fine from postman. but from saviynt it is also failing hard coded.

(lastModifiedDateTime+ge+datetimeoffset'2023-07-02T00:00:00Z')

[rushikeshvartak]

Does hardcoded works in Saviynt ?

[AtrayeeDutta]

Yes, it is working

[AtrayeeDutta]

I tried below filter for dynamic date it worked for us

(lastModifiedDateTime%20ge%20datetimeoffset'${Calendar aa=Calendar.getInstance(); aa.add(Calendar.DATE,-1);aa.getTime().format(\"yyyy-MM-dd'T'HH:mm:ss'Z'\")}')