Current Date in REST connector (SAP SuccessFactors)

[ayane_ahmed]

Hello everyone,

We need to import all users with a startdate greater than the current date using the SAP SuccessFactors Connector (REST). 

Is there a way to put the current date in the URL Path ?

We have tried with the following paths but none of them are working :

- https://apiXXX/odata/v2/User?empInfo/startDate%20gt%20${Calendar.instance.format('yyyy-MM-dd')}

- https://apiXXX/odata/v2/User?empInfo/startDate%20gt%20$%7B{Calendar.instance.format('yyyy-MM-dd')%7D...

- https://apiXXX/odata/v2/User?empInfo/startDate%20gt%20${NewDate().format('yyyy-MM-dd')}

- https://apiXXX/odata/v2/User?empInfo/startDate%20gt%20$%7B{NewDate().format('yyyy-MM-dd')%7D}

Thank You.

Regards,

[Manu269]

Try checking this post if it helps :

SuccessFactors incremental import based on lastMod... - Saviynt Forums - 31815

sap success factor increment connector - #1623445 - Saviynt Forums - 33482

[ayane_ahmed · Accepted solution]

Hello,

After investigating, the solution I found is the following:

- current date ==> ${Calendar.getInstance().getTime().format('yyyyMMdd')}

- Encode all the '$' used in the URL (expand, select...) with %24 except for the current date

Regards,

[sanjananv]

For other users who may have a similar question, can you please share exact URL that was used and working? (Masking domain name and any PII information.) Thank you.