Reltio Connect

 View Only
  • 1.  Create ref entity inside an entity

    Posted 10-14-2021 04:29
    Hey!
    I was wondering if I could create a reference entity inside an entity, when using the entity api.

    [
    {
    "type": "configuration/entityTypes/Counterparty",
    "attributes": {
    "Name": [
    {
    "value": "TestCounter142"
    }
    ],
    "Address": [
    {
    "value": {
    "Type": [
    {
    "value": "Type2"
    }
    ],
    "BusinessArea": [
    {
    "value": "GlobalAddressId2"
    }
    ],
    "AddressLine1": [
    {
    "value": "AddressLine122"
    }
    ]
    }
    }
    ],
    "Active": [
    {
    "value": "true"
    }
    ],
    "FromEquinor": [
    {
    "value": "true"
    }
    ],
    "FromDC": [
    {
    "value": "false"
    }
    ]
    },
    "crosswalks": [
    {
    "type": "configuration/sources/EQ_SAP",
    "sourceTable": "Counterparty",
    "value": "7684"
    }
    ]
    }
    ]

    If I send the json body above, the entity Counterparty is created with the reference entity Address. From the response, the crosswalk for Address has Reltio type and a generated value.

    "refEntity": {
    "type": "configuration/entityTypes/Address",
    "crosswalks": [
    {
    "uri": "entities/1vdj81bD/crosswalks/1vdj85rT.2m0lGKtbb",
    "type": "configuration/sources/Reltio",
    "value": "1vdj85rT",
    "attributeURIs": [
    "entities/1vdj81bD/attributes/Address/jo1xSS7",
    "entities/1vdj81bD/attributes/Address/jo1xSS7/GlobalAddressId/2m0lGKLVX",
    "entities/1vdj81bD/attributes/Address/jo1xSS7/Type/2m0lGKPln",
    "entities/1vdj81bD/attributes/Address/jo1xSS7/BusinessArea/2m0lGKU23",
    "entities/1vdj81bD/attributes/Address/jo1xSS7/AddressLine1/2m0lGKYIJ"
    ]
    }
    ],
    "objectURI": "entities/1vdj85rT"
    },

    Is it possible to set our own crosswalk type and value for reference entity Address without using the relation api?


  • 2.  RE: Create ref entity inside an entity
    Best Answer

    Reltio Employee
    Posted 10-14-2021 09:28
    Hi Minh,

    Thanks for asking this question.

    And yes, its possible to specify the refEntity crosswalk in the POST Entity API payload. Please see the below example

    [
    	{
    		"type": "configuration/entityTypes/Organization",
    		"attributes": {
    			"Name": [
    				{
    					"value": "Facebook"
    				}
    			],
    			"Address": [
    				{
    					"value": {
    						"AddressLine1": [
    							{
    								"value": "1601 Willow Rd"
    							}
    						],
    						"City": [
    							{
    								"value": "Menlo Park"
    							}
    						],
    						"StateProvince": [
    							{
    								"value": "United States"
    							}
    						],
    						"Country": [
    							{
    								"value": "CA"
    							}
    						],
    						"Zip": [
    							{
    								"value": {
    									"Zip5": [
    										{
    											"value": "94025"
    										}
    									]
    								}
    							}
    						]
    					},
    					"refEntity": {
    						"crosswalks": [
    							{
    								"type": "configuration/sources/Salesforce",
    								"value": "Surrogate"
    							}
    						]
    					}
    				}
    			],
    			"DUNSNumber": [
    				{
    					"value": "123456789"
    				}
    			]
    		},
    		"crosswalks": [
    			{
    				"type": "configuration/sources/Salesforce",
    				"value": "RefAttributeTestOrg1"
    			}
    		]
    	}
    ]​

    Please let me know if this helps!


  • 3.  RE: Create ref entity inside an entity

    Posted 10-14-2021 10:33
    It solved my problem.

    Thank you, Snehil!


  • 4.  RE: Create ref entity inside an entity

    Posted 10-14-2021 11:55
    Is it possible to set startDate and endDate for refEntity too?