Click HERE to see how Saviynt Intelligence is transforming the industry. |
09/24/2024 11:39 PM
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.
09/25/2024 01:26 AM
@Srujan Account Filter query can you share what are columns mapping , title is available ?
09/25/2024 01:37 AM
Hi @Raghu , thanks for the response. We are not using Account Filter query. Is this Account Filter query is required in the connection?
09/25/2024 01:56 AM
@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.
09/25/2024 03:17 AM
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?
09/25/2024 04:09 AM
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.
09/25/2024 04:17 AM - edited 09/25/2024 04:20 AM
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.
list of default attrs are - https://docs.saviyntcloud.com/bundle/Salesforce-v24x/page/Content/Configuring-the-Integration-for-Im...
09/25/2024 06:01 AM
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"
}
}
09/25/2024 06:17 AM