Saviynt unveils its cutting-edge Intelligence Suite products to revolutionize Identity Security!
Click HERE to see how Saviynt Intelligence is transforming the industry.
Saviynt Copilot Icon

Import Error || Salesforce

vm
Regular Contributor II
Regular Contributor II

Hello Team,

We are facing error in the import of entitlements and accounts using the Salesforce connector. The connection is working as expected. 

Vidhimehta_0-1728544552340.png

Postman response is also not the details we would need:

Vidhimehta_1-1728544663525.png

Any idea on the issue? 

Kindly note: We already have 2 instances of Salesforce in Prod which are working as expected.

Regards,

Vidhi.

[This message has been edited by moderator to mask URL from an image attached]

7 REPLIES 7

rushikeshvartak
All-Star
All-Star

PLease share connector configs and logs in text file


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

vm
Regular Contributor II
Regular Contributor II

Hello Rushikesh,

Below config details:

OBJECT_TO_BE_IMPORTED: Profile,Group,Role,FeatureLicense,Territory2

FEATURE_LICENSE_JSON: {
"Marketing User": "UserPermissionsMarketingUser",
"Offline User": "UserPermissionsOfflineUser",
"Flow User": "UserPermissionsInteractionUser",
"Salesforce CRM Content User": "UserPermissionsSFContentUser"
}

CREATEACCOUNTJSON: {
"Alias": "${user?.getFirstname()}",
"Email": "${user?.getEmail()}",
"Username": "${arstasksObj?.accountName}",
"CommunityNickname": "${user?.getFirstname()}${user?.getLastname()}",
"FirstName": "${user?.getFirstname()}",
"LastName": "${user?.getLastname()}",
"Department": "${user.departmentname}",
"Address": "${user.city}",
"City": "${user.city}",
"Country": "${user.country}",
"Street": "${user.street}",
"Title": "${user.title}",
"IsActive": true,
"ManagerId": "${ if (managerAccount == null || managerAccount?.accountID == null || managerAccount?.accountID == ''" ) else {managerAccount?.accountID} }",
"FederationIdentifier": "${user.email}",
"ProfileId": "${profileId}",
"TimeZoneSidKey": "${user.customproperty26}"
}

ACCOUNT_FIELD_QUERY: Id, Username, LastName, FirstName, Name, CompanyName, Email, IsActive, UserRoleId, ProfileId, UserType, ManagerId, LastLoginDate, LastPasswordChangeDate, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, ContactId, AccountId, FederationIdentifier, UserPermissionsSupportUser

FIELD_MAPPING_JSON: {"accountfield_mapping":{
"accountID":"Id~#~char",
"name":"Username~#~char",
"displayName":"Name~#~char",
"status":"IsActive~#~bool",
"accounttype":"UserType~#~char",
"lastlogondate":"LastLoginDate~#~date",
"lastpasswordchange":"LastPasswordChangeDate~#~date",
"CREATED_ON":"CreatedDate~#~date",
"creator":"CreatedById~#~char",
"updateUser":"LastModifiedById~#~char",
"updatedate":"SystemModstamp~#~date",
"customproperty1":"FirstName~#~char",
"customproperty2":"LastName~#~char",
"customproperty3":"CompanyName~#~char",
"customproperty4":"Email~#~char",
"customproperty5":"UserRoleId~#~char",
"customproperty6":"ProfileId~#~char",
"customproperty7":"ManagerId~#~char",
"customproperty8":"LastModifiedDate~#~date",
"customproperty9":"ContactId~#~char",
"customproperty10":"AccountId~#~char",
"customproperty11":"FederationIdentifier~#~char",
"customproperty12":"IsActive~#~bool",
"customproperty12":"UserPermissionsSupportUser~#~bool",
"customproperty13":"featureLicense~#~char",
"customproperty14":"Fortive_ID__c~#~char",
"customproperty15":"Department~#~char",
"customproperty16":"Start_Date__c~#~date",
"customproperty22":"isFrozen__c~#~char"
},
"profilefield_mapping": {
"entitlementID": "Id~#~char",
"entitlement_value": "Name~#~char",
"description": "Description~#~char",
"updatedate": "SystemModstamp~#~date",
"customproperty1": "UserType~#~char",
"customproperty2": "UserLicenseId~#~char",
"customproperty3": "CreatedDate~#~date",
"customproperty4": "CreatedById~#~char",
"customproperty5": "LastModifiedDate~#~date",
"customproperty6": "LastModifiedById~#~char",
"customproperty7": "Id~#~char"
}
}

MODIFYACCOUNTJSON: {
"ProfileId": "${profileId}",
"ManagerId": "${ if (managerAccount == null || managerAccount?.accountID == null || managerAccount?.accountID == ''") else {managerAccount?.accountID} }",
}

STATUS_THRESHOLD_CONFIG: {"statusAndThresholdConfig":{"accountThresholdValue":100,"statusColumn":"customproperty12","activeStatus":["true"],"deleteLinks":true,"lockedStatusColumn":"customproperty22","lockedStatusMapping":{"Locked":["1"],"Unlocked":["0"]}}}

CUSTOMCONFIGJSON: {"disableAccountForRevokeTask":false,"defaultEntitlementId":"","connectionTimeoutConfig":{"connectionTimeout":10,"readTimeout":120,"writeTimeout":120,"retryWait":10,"retryCount":5}}

Logs attached.

 

Regards,

Vidhi.

[This message has been edited by moderator to mask sensitive information]

Try with limited objects 

OBJECT_TO_BE_IMPORTED: Profile


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

vm
Regular Contributor II
Regular Contributor II

Hello @rushikeshvartak,

Tried importing just the profiles but still facing the same issue.

Regards,

Vidhi.

It seems issue with client secret . Does provisioning wokring ?


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.

vm
Regular Contributor II
Regular Contributor II

Hello @rushikeshvartak ,

Getting the below error while running the provisioning. The provisioning job ran successfully, but the task was errored.

Error in creating user = Failed to parse template script (your template may contain an error or be trying to use expressions not currently supported): startup failed: SimpleTemplateScript1048.groovy: 16: expecting anything but ''\n''; got it anyway @ line 16, column 161. anagerAccount?.accountID} }\", ^ 1 error

We dont have any entitlements imported, so requested for new account only.

Regards,

Vidhi.

Share full logs and json in text file


Regards,
Rushikesh Vartak
If this helped you move forward, click 'Kudos'. If it solved your query, select 'Accept As Solution'.