Reltio Connect

 View Only
Expand all | Collapse all

How to Map StartDate & EndDate of Relationship In Salesforce Connector Mapping

  • 1.  How to Map StartDate & EndDate of Relationship In Salesforce Connector Mapping

    Reltio Partner
    Posted 02-22-2023 23:55

    Hi Team,

    can anyone help me in mapping StartDate and EndDate fields of Relationship in Salesforce Connector Mapping.

    Thanks,

    Karthik



    ------------------------------
    Karthik karthik
    PWC
    ------------------------------


  • 2.  RE: How to Map StartDate & EndDate of Relationship In Salesforce Connector Mapping

    Reltio Employee
    Posted 03-09-2023 09:12

    Hi Karthik,
    You can try to create mapping like

    [
    {
    "description": "WorkingAt relation mapping to separate object",
    "isActive": true,
    "processMerge": false,
    "sfdcSource": "configuration/sources/SFDC",
    "sobject": {
    "type": "WorkingAt__c",
    "startField": "PersonAccountId__c",
    "endField": "BusinessAccountId__c"
    },
    "relation": true,
    "reltioObjectType": "configuration/relationTypes/WorkingAt",
    "startObjectType": "configuration/entityTypes/HCP",
    "endObjectType": "configuration/entityTypes/Company",
    "to_salesforce": {
    "attributeMapping": [
    {
    "sfdcAttrName": "Title__c",
    "value": "configuration/relationTypes/WorkingAt/attributes/Title"
    },
    {
    "sfdcAttrName": "StartDate__c",
    "value": "configuration/relationTypes/WorkingAt/attributes/StartDate"
    },
    {
    "sfdcAttrName": "EndDate__c",
    "value": "configuration/relationTypes/WorkingAt/attributes/EndDate"
    }
    ]
    },
    "to_reltio": {
    "attributeMapping": [
    {
    "uri": "configuration/relationTypes/WorkingAt/attributes/Title",
    "value": "Title__c"
    },
    {
    "uri": "configuration/relationTypes/WorkingAt/attributes/StartDate",
    "value": "StartDate__c"
    },
    {
    "uri": "configuration/relationTypes/WorkingAt/attributes/EndDate",
    "value": "EndDate__c"
    }
    ]
    }
    }
    ]

    Regards,
    Tatyana



    ------------------------------
    Tatyana Pogorelova
    ------------------------------