Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Want to populate lastLogin field from Okta into LASTLOGONDATE of Saviynt

ssaundatti
New Contributor
New Contributor

Hi Team,

We have a requirement where we need to populate the lastlogin date coming from the okta application to the last logon date field in Saviynt. Looking through the documentation we can see that the default place for the last login field in customproperty4 and it comes into Saviynt in the following format

2021-06-08T05:2:15.000Z

When we try putting this mapping in the ACCOUNTFIELDMAPPING field in the connector 

lastlogondate = lastLogin

 

We get a data truncation error after running the job and the required value does not populate.

Error message :- Data truncation: Incorrect datetime value

 

Can you let us know what modifications we need to do make the lastlogon field populate in the desired field.

5 REPLIES 5

Raghu
All-Star
All-Star

@ssaundatti  Below use full

 

{
"globalSettings": {
"dateFormat": "yyyy-MM-dd'T'HH:mm:ss"
},
"accountParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"call": {
"call1": {
"callOrder": 0,
"stageNumber": 0,
"http": {
"url": "URL",
"httpHeaders": {
"x-api-key": "${connection.xapikey}"
},
"httpContentType": "application/json",
"httpMethod": "GET"
},
"listField": "users",
"keyField": "accountID",
"statusConfig": {
"active": "enabled",
"inactive": "disabled"
},
"colsToPropsMap": {
"accountID": "id~#~char",
"name": "email~#~char",
"displayName": "#CONST#${return response.name.first+\" \" +response.name.last}~#~char",
"customproperty2": "email~#~char",
"status": "status~#~char",
"lastlogondate": "last-login-date~#~date",
"customproperty11": "#CONST#${response.tags.size() > 0 ? response.tags[0].replace('[','').replace('TM','').replace(']','') : null}~#~char",
"customproperty31": "STORE#ACC#ENT#MAPPINGINFO~#~char"
}
}
},
"acctEntMappings": {
"Role": {
"importAsEntitlement": true,
"listPath": "",
"idPath": "role",
"keyField": "entitlementID",
"colsToPropsMap": {
"entitlement_value": "entitlement_value~#~char",
"entitlementID": "entitlementID~#~char"
}
}
}
},
"entitlementParams": {
"connection": "userAuth",
"processingType": "SequentialAndIterative",
"entTypes": {
"Role": {}
}
},
"acctEntParams": {
"processingType": "acctToEntMapping"
}
}


Thanks,
Raghu
If this reply answered your question, Please Accept As Solution and hit Kudos.

We are using Okta ootb connector from Saviynt

rushikeshvartak
All-Star
All-Star

This may not be supported currently 

For any desired improvements or enhancements to this process, Saviynt encourages you to submit your proposal through Saviynt's Ideas Portal at https://ideas.saviynt.com/ideas/

Your valuable input is crucial to shaping the evolution of Saviynt systems.

Please notify us once the idea ticket has been created.


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.

ssaundatti
New Contributor
New Contributor

Just to confirm there is no way to truncate the data in config JSON if not I will create a idea in the idea portal

No, Please create idea ticket


Regards,
Rushikesh Vartak
If you find this response useful, kindly consider selecting 'Accept As Solution' and clicking on the 'Kudos' button.