Salesforce reconciliation issue

[Srujan]

I have mapped the Attribute in create account Json for Salesforce as "Title": "${User.jobcodedesc}".
After provisioning the account, I am able to see the attribute 'Title' on the salesforce end. But after account recon is successful, I am unable to see the "Title" Attribute under the Salesforce Account Details.
I have mapped following in the field_mapping_json "customproperty4":"Title~#~char".

Please let me know if there are any changes required in order to bring all the possible data from the target.

Thanks.

[Raghu]

@Srujan  Account Filter query can you share what are columns mapping , title is available ?

[Srujan]

Hi @Raghu , thanks for the response. We are not using Account Filter query. Is this Account Filter query is required in the connection?

[Amit_Malik]

@Srujan , have you added title in ACCOUNT_FIELD_QUERY. 

For salesforce connector, we would need to update attribute in both ACCOUNT_FIELD_QUERY and FIELD_MAPPING_JSON.

[akumar98]

Thanks @Amit_Malik for your response, it worked after adding the Account_field query.

Is it required to add all the attributes in account _field query which we are using in the FIELD_MAPPING_JSON?

[Manu269]

To filter the attributes of the account that you want to import, specify the value of the ACCOUNT_FIELD_QUERY parameter. 

All attributes in ACCOUNT_FIELD_QUERY must be mapped in FIELD_MAPPING_JSON. If any attribute in ACCOUNT_FIELD_QUERY is not mapped in FIELD_MAPPING_JSON, the import fails.

[Amit_Malik]

Yes @akumar98 , you need to add it in both places if you are extending attributes from default ones.

Below doc can help know more - https://docs.saviyntcloud.com/bundle/Salesforce-v24x/page/Content/Configuring-the-Integration-for-Im...

Review the following guidelines before creating the mapping:

• Map all Salesforce user attributes to EIC account attributes as specified in ACCOUNT_FIELD_QUERY using FIELD_MAPPING_JSON.

• If both ACCOUNT_FIELD_QUERY and FIELD_MAPPING_JSON are empty, the connector imports the default mapping

list of default attrs are - https://docs.saviyntcloud.com/bundle/Salesforce-v24x/page/Content/Configuring-the-Integration-for-Im...

[Srujan]

Hi @Amit_Malik, we tried adding ACCOUNT_FIELD_QUERY and FIELD_MAPPING_JSON. After running the accounts import job, it is making all the account's status as "Inactive".

ACCOUNT_FIELD_QUERY:
 Id,Username,CreatedDate,LastName,FirstName,Name,Title,LastLoginDate,LastPasswordChangeDate,LastModifiedDate

FIELD_MAPPING_JSON:

{
"accountfield_mapping": {
"accountID": "Id~#~char",
"name": "Username~#~char",
"customproperty2": "LastName~#~char",
"customproperty1": "FirstName~#~char",
"displayName": "Name~#~char",
"customproperty4":"Title~#~char",
"lastlogondate": "LastLoginDate~#~date",
"lastpasswordchange": "LastPasswordChangeDate~#~date",
"CREATED_ON": "CreatedDate~#~date",
"customproperty8": "LastModifiedDate~#~date"
}
}

[rushikeshvartak]

• Can you share logs ?
• Also confirm if status threshold configs in connector ?
• 

• FIELD_MAPPING_JSON

{
	"profilefield_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"
	},
	"permissionsetfield_mapping": {
		"entitlementID": "Id~#~char",
		"entitlement_value": "Name~#~char",
		"customproperty2": "LastModifiedDate~#~char",
		"customproperty4": "UserLicenseId~#~char",
		"customproperty6": "IsOwnedByProfile~#~char",
		"customproperty7": "CreatedDate~#~char",
		"customproperty8": "CreatedById~#~char",
		"customproperty9": "LastModifiedById~#~char",
		"customproperty18": "Name~#~char",
		"customproperty19": "SystemModstamp~#~char"
	},
	"rolefield_mapping": {
		"entitlementID": "Id~#~char",
		"entitlement_value": "Name~#~char",
		"customproperty2": "Name~#~char",
		"customproperty3": "Type~#~char",
		"customproperty4": "OwnerId~#~char",
		"customproperty5": "DoesIncludeBosses~#~char",
		"customproperty7": "CreatedDate~#~char",
		"customproperty18": "LastModifiedDate~#~char",
		"customproperty19": "SystemModstamp~#~char"
	},
"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",
    "customproperty21": "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"
  }

}

• STATUS_THRESHOLD_CONFIG

{
"statusAndThresholdConfig" : {
      "accountThresholdValue" : 50,
     "statusColumn":"status",
      "activeStatus":[1],
      "correlateInactiveAccounts": true,
      "deleteLinks": true
}
}​

[Amit_Malik]

@Srujan , you have not mapped status column

Id,Username,CreatedDate,LastName,FirstName,Name,Title,LastLoginDate,LastPasswordChangeDate,LastModifiedDate,IsActive 

{
"accountfield_mapping": {
"accountID": "Id~#~char",
"name": "Username~#~char",
"customproperty2": "LastName~#~char",
"customproperty1": "FirstName~#~char",
"displayName": "Name~#~char",
"customproperty4":"Title~#~char",
"lastlogondate": "LastLoginDate~#~date",
"lastpasswordchange": "LastPasswordChangeDate~#~date",
"CREATED_ON": "CreatedDate~#~date",
"customproperty8": "LastModifiedDate~#~date",

"status": "IsActive~#~bool",
}
}