Rest API to get only future startdate records

[sppnra]

Hi Saviynt Team,

We need to find a logic to just to pull future start date user records. Write now I am trying to use below suggestions from related forums 

https://forums.saviynt.com/t5/identity-governance/rest-connector-specify-a-date-that-is-15-days-in-t...

I have added this function in ConnectionJSON and trying to call that in ImportUserJSON

But its not working getting [error:Error Illegal character in query at index 2470:

Please let me know what may be the issue

[GSR]

Please follow below sample

$filter=employmentNav/jobInfoNav/startDate+gt+datetime'${new Date(Calendar.getInstance().getTimeInMillis()).format('yyyy-MM-dd')}T00:00:01'&fromDate=${new Date(Calendar.getInstance().getTimeInMillis()).format('yyyy-MM-dd')}&toDate=${new Date(Calendar.getInstance().getTimeInMillis()+(15*86400000)).format('yyyy-MM-dd')}

[sppnra]

Getting the same error @GSR 

[This post has been edited by a Moderator to remove tags to employees and other forum users.]

[Dhruv_S]

Hi @sppnra 

We are looking into this and will keep you posted.

Regards,

Dhruv Sharma

[sppnra · Accepted solution]

Hi @Dhruv_S ,

This issue is resolved please ignore it, please find the below JSON to use in URI for get the future dated records 

%24filter=startDate%20gt%20datetimeoffset'${Calendar aa=Calendar.getInstance();aa.getTime().format(\"yyyy-MM-dd'T'H:mm:ss'Z'\")}'",

thanks,

Rahul

[This message has been edited by moderator to remove hyperlink]