Reltio Connect

 View Only
  • 1.  Single JSON payload including crosswalks for attribute values from two sources

    Posted 23 days ago

    Can someone please point me to any documentation on this or share your experience. I want to send one JSON payload using postman. It contains attributes that have values from two sources, one regular source from internal company systems and one an enrichment source from a third party. The data model for Organization contains attributes from both sources. Eg., Organization name, address etc are from an internal source but revenue, company size, company reputation etc are from an external third party. I am not interested in the connectors like D&B and ZoomInfo available in Reltio.

    How would you mention all attributes and crosswalks for both sources in a single payload. A small example would be helpful.



    ------------------------------
    Shashi Prakash
    Newmark
    ------------------------------


  • 2.  RE: Single JSON payload including crosswalks for attribute values from two sources

    Reltio Partner
    Posted 22 days ago

    Hello Shashi,
    I've worked through a very similar scenario and wanted to share what worked for us when wanting to achieve a creation of two crosswalks, contributing different data, into Reltio.

    If you want to load internal and third-party data with a single POST request, you can do this by sending two objects with shared crosswalks. Each can contribute part of the data but still merge into one entity because they both mention the same crosswalks. To achieve this, you will need to set the "dataProvider": true/false separating the data based on which source should be pushing the data. This example can be used in Postman's Body: 

    [
    	{
    		"type": "configuration/entityTypes/Organization",
    		"crosswalks": [
    			{
    				"type": "configuration/sources/InternalCRM",
    				"value": "ORG_12345",
    				"sourceTable": "orgs",
    				"dataProvider": true
    			},
    			{
    				"type": "configuration/sources/EnrichmentAPI",
    				"value": "EXTR_56789",
    				"sourceTable": "external",
    				"dataProvider": false
    			}
    		],
    		"attributes": {
    			"Name": [
    				{
    					"value": "Example Corporation",
    				}
    			],
    			"Address": [
    				{
    					"value": {
    						"AddressLine1": [
    							{
    								"value": "123 Main St"
    							}
    						],
    						"City": [
    							{
    								"value": "Metropolis"
    							}
    						]
    					}
    				}
    			]
    		}
    	},
    	{
    		"type": "configuration/entityTypes/Organization",
    		"crosswalks": [
    			{
    				"type": "configuration/sources/InternalCRM",
    				"value": "ORG_12345",
    				"sourceTable": "orgs",
    				"dataProvider": false
    			},
    			{
    				"type": "configuration/sources/EnrichmentAPI",
    				"value": "EXTR_56789",
    				"sourceTable": "external",
    				"dataProvider": true
    			}
    		],
    		"attributes": {
    			"Revenue": [
    				{
    					"value": "5,000,000"
    				}
    			],
    			"Name": [
    				{
    					"value": "Example Corporation",
    				}
    			],
    			"Address": [
    				{
    					"value": {
    						"AddressLine1": [
    							{
    								"value": "123 Main St"
    							}
    						],
    						"City": [
    							{
    								"value": "Metropolis"
    							}
    						]
    					}
    				}
    			]
    		}
    	}
    ]

    As a result, you will create a single Reltio entity having the two crosswalks "glued" to each other, each of which contributing only the specified data in the request above (with a single event generated).
    To read more about dataProvider and contributorProvider options of Reltio crosswalks and to look at examples, you can check out this post: https://ulpia.tech/how-to-add-a-crosswalk-to-an-existing-entity/

    Hope this helps!



    ------------------------------
    Daniel Shahanski
    UPLIA TECH
    ------------------------------



  • 3.  RE: Single JSON payload including crosswalks for attribute values from two sources

    Posted 14 days ago

    Hi Daniel

    Thanks so much. That is a good solution and much appreciated!!

    Kind regards

    Shashi Prakash



    ------------------------------
    Shashi Prakash
    Newmark
    ------------------------------