Accelerate the Value of Data

Mapping Nested Objects and Relations

Salesforce attributes can only be mapped to Reltio relationship attributes if the Reltio relationship attribute is declared as a reference attribute of an entity.

Mapping a Reltio reference attribute to an Salesforce child object requires some procedure.

The following example illustrates how to map the Reltio HCP Address attribute to the Account child Address entity:

Table 1. Mapping Table
OptionDescription
OptionDescription
typeReltio reference attribute e.g. configuration/entityTypes/Organization/attributes/Address
rootThe root of expression evaluation. e.g.."*/attributes/Address/@@@@"
refentitytrue: is refentity for the described entity

Declaring the Reference Attribute in entityMapping

See the sample below:

Relations

List of fields to configure relations like Affiliations:

Table 2. Relations Mapping Table
NameTypeRequiredAvailable ValuesDescription
typeStringYes-Type of relation
salesforceCrosswalkTypeStringYes-Source crosswalk type
sourceSfdcCrosswalkJselYes-Destination child account ID
destSfdcCrosswalkJselYes-Destination parent account ID
destSfdcObjectStringYes-Destination relation table name
junctionMapYes-Contains mapping of Parent and Child.
Example:
"junction": {
    "Parent_Account_vod__c": "@@@destSfdcCrosswalk@@@",
    "Child_Account_vod__c": "@@@sourceSfdcCrosswalk@@@"
    }

@@@destSfdcCrosswalk@@@ will be replaced with TODO

@@@sourceSfdcCrosswalk@@@ will be replaced with TODO

junctionRemoveMapYes-Destination relation Id
Example:
"junctionRemove": {
    "Id": "//crosswalks/*[@type='configuration/sources/Veeva' and not(@deleteDate)]/@value"
}