SalesForce Connector - Access (Entitlements)Import is not working

[IAM_99]

Hi Team ,

We are working Salesforce connector - we are able to pull Accounts but not Entitlements.

Here is    FIELD_MAPPING_JSON

{
"accountfield_mapping": {
"accountID": "Id~#~char",
"name": "Username~#~char",
"customproperty2": "LastName~#~char",
"customproperty1": "FirstName~#~char",
"displayName": "Name~#~char",
"customproperty3": "CompanyName~#~char",
"customproperty4": "Email~#~char",
"status": "IsActive~#~bool",
"customproperty5": "UserRoleId~#~char",
"customproperty6": "ProfileId~#~char",
"accounttype": "UserType~#~char",
"customproperty7": "ManagerId~#~char",
"lastlogondate": "LastLoginDate~#~date",
"lastpasswordchange": "LastPasswordChangeDate~#~date",
"CREATED_ON": "CreatedDate~#~date",
"creator": "CreatedById~#~char",
"customproperty8": "LastModifiedDate~#~date",
"updateUser": "LastModifiedById~#~char",
"updatedate": "SystemModstamp~#~date",
"customproperty9": "ContactId~#~char",
"customproperty10": "AccountId~#~char",
"customproperty13": "FederationIdentifier~#~char",
"customproperty20": "UserPermissionsSupportUser~#~bool",
"customproperty23":"CommunityNickname~#~char"
},
"permissionsetfield_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"
},
"profilefield_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"
}
}

please let us know any inputs ?

[rushikeshvartak]

Your FIELD_MAPPING_JSON is correct

Please check configuration for OBJECT_TO_BE_IMPORTED & ACCOUNT_FIELD_QUERY

Please share logs if not fixed

[IAM_99]

Thanks for the update.

Here is my Account_Field_query JSON

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

[rushikeshvartak]

It does not correct query did u pasted some createaccountjson ?

[IAM_99]

Yeah my bad , I posted now

[IAM_99]

do you need any other details or logs ?

[rushikeshvartak]

It seems you have } closing bracket in ACCOUNT_FIELD_QUERY

[IAM_99]

Different Question on Provisioning - In CreateAccountJSON there is a mandatory  attribute called 'ProfileID' , how to find this value ?  When we pass dummy values it was throwing error as ' ID incorrecttype ......'

[rushikeshvartak]

Each Salesforce account is mapped with one profile. 

You can create dynamic attribute (Query on existing account's custom property 6 of salesforce endpoint) / make profile entitlement type requestable. 

[IAM_99]

Hi ,

We have changed to new environment (UAT URL )and tried to import entitltements, it imported in Saviynt (841 entitlements created for this end point)but the job is failed with the below error

InvalidBatch : Failed to process query: MALFORMED_QUERY: unexpected token: '{'

any idea on this ?

[rushikeshvartak]

You might have syntax error in JSON inside connection

[IAM_99]

I checked looks fine .

infact if we would have syntax error it would have not saved.

[rushikeshvartak]

Can you share json

[IAM_99]

PFB

Feild_mapping_JSON

{
"accountfield_mapping": {
"accountID": "Id~#~char",
"name": "Username~#~char",
"customproperty2": "LastName~#~char",
"customproperty1": "FirstName~#~char",
"displayName": "Name~#~char",
"customproperty3": "CompanyName~#~char",
"customproperty4": "Email~#~char",
"status": "IsActive~#~bool",
"customproperty5": "UserRoleId~#~char",
"customproperty6": "ProfileId~#~char",
"accounttype": "UserType~#~char",
"customproperty7": "ManagerId~#~char",
"lastlogondate": "LastLoginDate~#~date",
"lastpasswordchange": "LastPasswordChangeDate~#~date",
"CREATED_ON": "CreatedDate~#~date",
"creator": "CreatedById~#~char",
"customproperty8": "LastModifiedDate~#~date",
"updateUser": "LastModifiedById~#~char",
"updatedate": "SystemModstamp~#~date",
"customproperty9": "ContactId~#~char",
"customproperty11": "AccountId~#~char",
"customproperty13": "FederationIdentifier~#~char",
"customproperty20": "UserPermissionsSupportUser~#~bool",
"customproperty23":"CommunityNickname~#~char"
},
"permissionsetfield_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"
},
"profilefield_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"
}
}