Converting Date Format in Rest Connector Account Import JSON

[Wes]

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:

"globalSettings": {

      "dateFormat": "yyyy-MM-dd'T'HH:mm:ss'+'hh:mm"

}

and set my date attributes and values to:

"colsToPropsMap": {

          "validfrom": "StartDate~#~date",

          "validthrough": "EndDate~#~date"

}

I got the idea to do this from this post.

The logs indicate that the StartDate and EndDate values are unparsable: 

Is a date conversion possible in this way?

[CR]

you can try like below format

${new java.text.SimpleDateFormat('MM-dd-yyyy').format(user.startdate)}

[Wes]

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

[rushikeshvartak]

"colsToPropsMap": {

          "validfrom": "StartDate~#~datetime",

          "validthrough": "EndDate~#~datetime"

}

[Wes]

Hi Rushikesh,

Unfortunately no luck here, I don't think Saviynt was recognizing "datetime" as a data type.

Thank you,

- Wes

[rushikeshvartak]

Use const ${Calendar.getInstance().getTime().format('yyyyMMddHHmmss')}Z function

[Wes]

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:

"customproperty20": "#CONST#${SimpleDateFormat simpleformat = new SimpleDateFormat(\"MM-dd-yyyy HH:mm:ss\"); return simpleformat.format(StartDate)}~#~char"

I'm using customproperty20 so I can see better what is getting passed.

What ends up happening is that the value of customproperty20 will end up being this:

#CONST#${SimpleDateFormat simpleformat = new SimpleDateFormat(\"MM-dd-yyyy HH:mm:ss\"); return simpleformat.format(StartDate)}

[rushikeshvartak]

Can you confirm saviynt version. As above logic works for us

[Wes]

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")

[rushikeshvartak]

try 

millisec

[Wes · Accepted solution]

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:

  "globalSettings": {

    "dateFormat": "yyyy-MM-dd'T'HH:mm:ss"

  }

Initially, my format was incorrect, which I think was causing the issue.

Edit: I got the idea from this post: https://forums.saviynt.com/t5/application-access-governance/rest-connector-query-issue-with-importin...