Mapping Field Definitions

The mapping file consists of the following constructs in the JSON file:

Table 1. Mapping Fields
Mapping Field Name	Required	Default Value	Description
`description`	false	none	Mapping description
`isActive`	false	true	Status of mapping
`reltioObjectType`	true	none	Reltio entity type URI
`sobject\|sobject{type, recordTypeId, startField, endField}`	true	none	Object with next attributes: `type` - Salesforce Object, example (Account,Contact) `recordTypeId` - Record Type Id of the particular Salesforce Object, example (01234000001ABcDAAA) `startField` - Specifies a field name of `SObject` that contains a reference to the start object of the relation `endField` - Specifies a field name of `SObject` that contains a reference to the end object of the relation Note: The `startField` and `endField` details are required for objects of the relation type only. Example: `sobject : { type: Account, recordTypeId : "01234000001ABcDAAA" }`
`sfdcSource`	false	none	Salesforce crosswalk type
`relation`	false	true for relation types	Specifies that this mapping entry is a custom object relation. This must be set to `true` for relation types.
`startObjectType`	For relation types only	none	Reltio entity type for the start object of the relation.
`endObjectType`	For relation types only	none	Reltio entity type for the end object of the relation
`to_salesforce`	false	none	Mapping of field for replication from Reltio to Salesforce
`to_salesforce/filter`	false	none	Salesforce to Reltio filter for entire entity. For example: [equals(attributes.SyncFlag, True)]
`to_salesforce/attributeMapping`	true	none	List of one to one attribute mappings
`/attributeMapping/sfdcAttrName`	true	none	Salesforce field Name
`/attributeMapping/value`	true	none	Value that must be propagated to the Salesforce object. Possible values are: Operational value from the entity URI. For example, `configuration/entityTypes/Org/attributes/Name` Apply transformation function before sending the field value
`to_salesforce/relatedObjects`	false	none	List of the Salesforce object related to the root Salesforce object
`/relatedObjects/sobject\|sobject{type,recordTypeId}`	true	none	Related object with attributes: type - SObject type, ex(Address_vod__c,Contact) recordTypeId - Record Type Id for particular SObject, ex(01234000001ABcDAAA) `Example: sobject : Address_vod__c sobject : { type: Address_vod__c, recordTypeId : “01234000001ABcDAAA” }`
`/relatedObjects/filter`	false	none	Filter criteria for relation objects while replicating data from Reltio to Salesforce. For example: `[equals(configuration/entityTypes/Org/attributes/Address/attributes/Rank,1)]`
`/relatedObjects/relationshipName`	false	none	Relationship names of the related object. Example: `Address_vod__r` By default, must get first relationship in Salesforce
`/relatedObjects/rootUri`	false	none	Reltio attribute URI
`/relatedObjects/recordTypeId`	false	none
`/relatedObjects/attributeMapping`	true	none	List of one to one mapping for the related object.
`/relatedObjects/attributeMapping/sfdcAttrName`	true	none	Salesforce object attribute name Salesforce object fields that are External ID fields cannot be mapped.
`/relatedObjects/attributeMapping/value`	true	none	Value that must be propagated to the Salesforce object. Possible values are: Operational value from the entity URI. For example, `configuration/entityTypes/Org/attributes/Name` Apply transformation function before sending the field value
`to_salesforce/deleteRelatedObjects`	false	none	Custom Salesforce objects mapped to a nested entity attribute will be removed if the entire nested attribute is removed in Reltio platform. This parameter needs to be placed under `to_salesforce`. You can remove this parameter from all other places
`/relations`	false	none	List of objects. Multiple relation types are supported for entity types applicable only for Salesforce lookup relations. It must be configured for a child Salesforce object that has a special field with a reference ID to the parent object.
`/relations/relationType`	true	none	This is the `Relation type` defined in Reltio metadata. The `startObject` type defined in relation metadata should be present in the mapping and match the parent Reltio object type defined in the mapping (type inheritance is not supported). The `endObject` type defined in relation metadata should match the Reltio object type defined in mapping where relation is configured (type inheritance is not supported). For example: `configuration/relationTypes/Affiliation`.
`/relations/sfdcAttrName`	true	none	This is the Salesforce object field name that contains a reference to the parent object (Salesforce lookup relation). The Parent object type is determined by Salesforce metadata and should match to the Salesforce object type defined in parent object mapping.
`to_reltio`	false	none	Defines mapping of fields to be replicated from Salesforce to Reltio
`to_reltio/filter`	false	none	Filter criteria for the object to be replicated to Reltio. For example `[equals(attributes.Name, Main Street)]`. Same structure as other Reltio filters.
`to_reltio/attributeMapping`	true	none	List of one to one attribute mapping
`/attributeMapping/uri`	true	none	Reltio entity URI
`/attributeMapping/value`	true	none	Value that must be propagated to the Salesforce object. Possible values are: uri - For example: `configuration/entityTypes/Org/attributes/Name` - always get FIRST OV value. Function concation: `=source` - same as URI or string `concat` `split` `get` `equals` Can contain another attribute mapping: For example: `=source(configuration/entityTypes/Organization/attributes/WebsiteURL).split('.').get(1)` Allow to join first and last name to the full name.
`/attributeMapping/sobject`	false	none	Can be string (recordTypeId is Master Record Type) or object with next attributes: `type` - SObject type. For example (Address_vod__c,Contact) `recordTypeId` - Record Type Id of particular SObject. For example - (01234000001ABcDAAA) `Example: sobject : Address_vod__c sobject : { type: Address_vod__c, recordTypeId : “01234000001ABcDAAA” }`
`/attributeMapping/filter`	false	none	Filter criteria for the entire entity. For example - `[equals(attributes.Name, Main Street)]` Same structure as other Reltio filters.
`/attributeMapping/compoundFieldName`	false	none	Must be filled with `compoundFieldName` for embedded Address. Example: `ShippingAddress`
`/attributeMapping/forceRefEntityMerge`	false	true	`forceRefEntityMerge` allows you to create new values for reference attributes instead of updating the existing operational values (OV). For example, when a user changes address in Salesforce, the connector creates a new location attribute instead of updating the existing location with new values that become OVs. Match rule is used to merge the values. If the `forceRefEntityMerge` parameter is set to `true` (the default value) or not specified, then the current behaviour of updating the existing values in OV continues. If the `forceRefEntityMerge` parameter is set to `false`, then new values for the reference attribute are created. If the `forceRefEntityMerge` parameter is specified for a Salesforce attribute mapped to Reltio's simple or nested attribute, it will be ignored.
`/relations`	false	none	Array of objects. Multiple relation types are supported for `Sobject`.
`/relations/relationType`	true	none	This is the `Relation type` defined in Reltio metadata. For example: `configuration/relationTypes/Contact`.
`/relations/sfdcAttrName`	true	none	This is the `Sobject` field name that contains a reference to the parent.

Unify and manage your data

Mapping Field Definitions

Footer