Role Entitlement type import failing from Salesforce

[piyushm]

Hello,

We are using OOTB salesforce connector to import Entitlements from Salesforce application.

In the Objects to be Imported field  we have mentioned - PermissionSet,Profile,Group,Role

The first 3 entitlement types are getting imported into Saviynt. But the "Role" entitlement type import is failing with below error.

Exception in Iterating Role for entitlementId - 0J0D000000943ctKAA: \n","stream":"stdout","time":"2023-05-01T13:33:46.31462893Z"}"
"ecm-worker","2023-05-01T13:33:55.825+00:00","{"log":"java.text.ParseException: Unparseable date: \"ApexClass

The roles are present in the salesforce application.

 Could this be failing due to some configuration issue on the saviynt side?

[sudeshjaiswal]

Hello @piyushm,

The error message specifically mentions "Unparseable date", which suggests that there is an issue with parsing a date field associated with the Role object.
You may want to check the format of the date field associated with the Role.

Can you provide the json for the Role?

@RakeshMG 

For Ref:- https://docs.saviyntcloud.com/bundle/Salesforce-v23x/page/Content/Configuring-the-Integration-for-Im... 
Thanks,

[piyushm]

@sudeshjaiswal  Did you mean the Field mapping json?

Please see the mapping for Role

"roleld_mapping": {
"entitlementID": "Id~#~char",
"entitlement_value": "Name~#~char",
"customproperty2": "LastModifiedDate~#~date",
"customproperty4": "UserLicenseId~#~char",
"customproperty7": "CreatedDate~#~date",
"customproperty8": "CreatedById~#~char",
"customproperty9": "LastModifiedById~#~char",
"customproperty18": "UserType~#~char",
"customproperty19": "SystemModstamp~#~date"
}

[rushikeshvartak]

please use below mapping

"roleld_mapping": {
"entitlementID": "Id~#~char",
"entitlement_value": "Name~#~char",
"customproperty2": "LastModifiedDate~#~char",
"customproperty4": "UserLicenseId~#~char",
"customproperty7": "CreatedDate~#~char",
"customproperty8": "CreatedById~#~char",
"customproperty9": "LastModifiedById~#~char",
"customproperty18": "UserType~#~char",
"customproperty19": "SystemModstamp~#~char"
}

[sudeshjaiswal]

Hello @piyushm,

Please attempt to provide only the integer value for the date.
The error message indicates that the date value "2023-05-01T13:33:46.31462893Z" includes a character value as well so it may be causing the error.

Thanks

[sachinjain]

Hi @piyushm 

You can try below if you are using REST

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

Thanks,

Sachin Jain