Rest connector Last logon date not getting imported

[vivekmistry]

Hi,

Trying to fetch last logon date from a rest connector but the date format is in GMT, dates not getting updated in last logon date in accounts table.

Config used:

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

"colsToPropsMap":

"LASTLOGONDATE" : "lastLoggedTime~#~date" --> not working

"LASTLOGONDATE" : "lastLoggedTime~#~datetime" --> not working

"lastlogondate" : "${SimpleDateFormat simpleformat = new SimpleDateFormat(\"YYYY-MM-DD HH:MM:SS\"); return simpleformat.format(lastLoggedTime)}~#~datetime" --> Not working

Above image has the date in logs but not getting updated.

API doc timing:

[NM]

LASTLOGONDATE" : "#CONST#reaponse.lastlogindate.format('MM-dd-yyyy')}~#~date" 

@vivekmistry try abive

[vivekmistry · Accepted solution]

Started working with global setting Thanks 🙂

{
"globalSettings": {
"dateFormat": "yyyy-MM-dd'T'HH:mm:ss"
},

[NM]

@vivekmistry did you assign the lastlogin date directly?