Reltio Connect

 View Only
  • 1.  Data is getting loaded even when we pass Null value to Crosswalk ID value

    Reltio Partner
    Posted 06-27-2023 02:23

    Hi Team,

    We encountered a strange behavior , we tried to load data from file to Reltio using RIH and  we passed Null Value as a crosswalk Id Value for one source and we excepted the record will be rejected.

    For our surprise the record got loaded with null Value as Crosswalk Id Value and we can see the profile in Reltio UI.

    We tried replicating the same using console Data loader and  data is rejecting  



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


  • 2.  RE: Data is getting loaded even when we pass Null value to Crosswalk ID value

    Reltio Partner
    Posted 06-27-2023 02:59

    Hi Karthik,

    I believe RIH is replica of API's. So, try performing similar action via Create Entity API and i think it would create a new record as RIH.

    So, we need to manually perform the check before we send the data to create action of Reltio connector.

    One possible way is to create a SQL Table using SQL Collection and apply filters so that you can get rid of unwanted data and send the same in email so that users/operations team can take necessary action.

    Let me know if you need more assistance.



    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------



  • 3.  RE: Data is getting loaded even when we pass Null value to Crosswalk ID value

    Reltio Employee
    Posted 06-28-2023 09:35

    Hi Karthik

    just to confirm, you are saying that via RIH it allowed you to load a record with null as the crosswalk value? 

    I just tried creating a record with null as the crosswalk value and got this error in the output below. Perhaps we are doing something slightly different in our recipes:

    {
        "index": 0,
        "errors": {
            "severity": "Error",
            "errorMessage": "Crosswalk 'value' property missed.",
            "errorCode": 126,
            "errorDetailMessage": "Crosswalk 'value' property missed {\"type\":\"Salesforce\",\"value\":null}."
        },
        "successful": false
    }

    this was my input:

    {
        "object": "entity",
        "type": "configuration/entityTypes/Organization",
        "record": {
            "crosswalks": [
                {
                    "type": "Salesforce",
                    "value": null
                }
            ],
            "attributes": {
                "Name": "A NAME WITHOUT ADDRESS",
                "Address": [
                    {
                        "AddressLine1": null,
                        "Zip": [
                            {
                                "Zip5": null
                            }
                        ],
                        "StateProvince": null,
                        "City": null,
                        "refEntity": {
                            "crosswalks": [
                                {
                                    "type": null,
                                    "value": null
                                }
                            ]
                        },
                        "refRelation": {
                            "crosswalks": [
                                {
                                    "type": null,
                                    "value": null
                                }
                            ]
                        }
                    }
                ]
            }
        }
    }



    ------------------------------
    Guy Vorster
    ------------------------------



  • 4.  RE: Data is getting loaded even when we pass Null value to Crosswalk ID value

    Reltio Partner
    Posted 06-28-2023 09:45

    Hi Guy,

    In RIH passing null to crosswalk value would become "null" internally and it would be posted.

    Can you try with "null" it will be posted via API and RIH too



    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------



  • 5.  RE: Data is getting loaded even when we pass Null value to Crosswalk ID value

    Reltio Employee
    Posted 06-28-2023 09:52

    if you use "null" as the input then yes that would work and per the example above I would have a record with a crosswalk value of "null".  But null and "null" are not the same in RIH.



    ------------------------------
    Guy Vorster
    ------------------------------



  • 6.  RE: Data is getting loaded even when we pass Null value to Crosswalk ID value

    Reltio Partner
    Posted 06-28-2023 09:57

    What i meant is null in RIH is same as "null" in API

    As we provide value/ datapill to attribute or crosswalks and in turn they are converted to JSON to post into Reltio Tenant during this process attribute values are wrapped in " 



    ------------------------------
    Sheshadri V
    Fresh Gravity
    ------------------------------