and more in a single search tool across platforms. Read the announcement here. |
03/13/2024 12:01 PM
Hello!
I am attempting to convert the incoming StartDate and EndDate dates (mapped to ValidFrom and ValidThrough, respectfully) in the ImportAccountEntJSON. We are reading in the dates as:
I have tried setting the attribute "dateFormat" (inside of "globalSettings") to:
and set my date attributes and values to:
"colsToPropsMap": {
Is a date conversion possible in this way?
Solved! Go to Solution.
03/14/2024 12:48 AM
you can try like below format
${new java.text.SimpleDateFormat('MM-dd-yyyy').format(user.startdate)}
03/14/2024 11:50 AM
Hi Raghu!
Thank you for your response!
Where would this go in the ImportAccountEntJSON? StartDate and EndDate are coming from an external application, so those values wouldn't be in the user table.
Thank you,
- Wes
03/14/2024 08:07 PM
"colsToPropsMap": {
03/15/2024 04:18 PM
Hi Rushikesh,
Unfortunately no luck here, I don't think Saviynt was recognizing "datetime" as a data type.
Thank you,
- Wes
03/17/2024 06:09 PM
Use const ${Calendar.getInstance().getTime().format('yyyyMMddHHmmss')}Z function
03/21/2024 02:12 PM
This doesn't seem to work unfortunately. When I try to put any sort of Groovy code or function in the contents of the date conversion value, it either fails to import that value or it spits out exactly what I have written in.
For example, I tried this earlier:
03/21/2024 06:46 PM
Can you confirm saviynt version. As above logic works for us
03/25/2024 01:32 PM
So this does look to work, but it is populating the current time and not imported time unfortunately (I tested this in a customproperty.
I tried populating the validfrom/validthrough attributes by using this to see what would happen and it appears that they were not populated (even after I changed the datatype to "date")
03/25/2024 07:29 PM
try
millisec
04/15/2024 01:55 PM - edited 04/15/2024 01:56 PM
It took a while, but I figured out something I was doing previously works, I just inputted it slightly different now. All I had to add was this: