Pass a dynamic date in URL in Rest API Call

[GeSaviynt]

Hi Team,

I am trying to pass the dynamic date  in URL for Rest API call for Workday, with hardcoded value I am able to fetch the RASS report.

https:///ccx/service/customreport2/travelhrportal//CR_New_Hire_Report_for_AccessIT_-_Manual_Run_RAAS?Effective_as_of_Date=Effective_as_of_Date=2022-06-14-07:00&Employee_ID=0001686&format=json . For the attribute 'Effective_as_of_Date' have to pass dynamic date so that report will run for today date as per job schedule. Can you please provide syntax for this?

Thanks in Advance

Geeta

[sahajranajee]

Hello,

Please try the following :

"url": "https://ccx/service/customreport2/travelhrportal//CR_New_Hire_Report_for_AccessIT_-_Manual_Run_RAAS?Effective_as_of_Date=${requestAccessAttributes.Effective_as_of_Date}=2022-06-14-07:00&Employee_ID=0001686&format=json"

[GeSaviynt]

Hi ,

Workday is trusted source, we are pulling the data from Workday to Saviynt.

https:///ccx/service/customreport2/travelhrportal//CR_New_Hire_Report_for_AccessIT_-_Manual_Run_RAAS?Effective_as_of_Date=Effective_as_of_Date=2022-06-14-07:00&Employee_ID=0001686&format=json

Note : Effective_as_of_Date is attribute available in Workday not in Saviynt. '2022-06-14-07:00' we have to pass this date as dynamic so that whenever job will run it will pick today date.

Can you please help on this.

Thanks,

Geeta

[sundas7]

Hi Geeta

Can you please check the below sample format. I found the below reference in one of our old FD ticket created for similar Work day related requirement by our implementation team where in there is reference to another link posted in our legacy forum.

Please check the resolution comments in the end of that post and see if it resolves your issue!

Courtesy/Reference

Sample URL format: https://<url>?%24format=json&%24filter=status%20in%20%27t%27,%27f%27&fromDate=${(new Date()).format('yyyy-MM-dd')}

Resolution: If you have a $ in your URL, Saviynt tries to replace that and fails and hence it doesnt replace any ${} code. To fix, replace $ with %24 (URLEncoded value for $ ) . Replace all $ other than the ${new Date....}

Thanks

Shyam