Reltio Connect

 View Only
  • 1.  Removing an item from a nest

    Reltio Partner
    Posted 9 days ago
    Folks,
    The team and I are trying to find a simple way to remove an item from a nest, based on the same source that placed the item. Imagine source A posts items A1, A2,and A3 into say the Identifiers nest while also posting attributes outside the nest such as First, Last, Address, etc.. Now an update comes along from Source A regarding the nest. The update wants to remove A3, leaving only A1 and A2. As far as I can tell from the Reltio docs, the partialOverride request in conjunction with KeyAttributeURIs, is easily able to update the values within A3 (and if desired add A4, A5,..)  But I don't see a straightforward way to remove A3. Seems we would have to write a script that queries the entity to discover the actual URI for A3 and delete it.  Correct?  Now if that is true, then to me, I think it would be very helpful if partialOverride could be enhanced with a simple "delete" option as well. The KeyAttributeURIs would serve as the key to the item of interest, and "partialOveride with delete" could delete that item while protecting the other items. 
    Another approach might be to enhance partialOveride to let Source A replace all its items in the nest with a new set (from Source A's perspective of course). In this case the new set would contain just A1 and A2. 
    Assistance and thoughts pls
    Curt

    ------------------------------
    Curt Pearlman
    PwC
    Agoura Hills CA
    ------------------------------


  • 2.  RE: Removing an item from a nest

    Reltio Employee
    Posted 4 days ago
    Hello Curt,

    The solution should be - to pass a null value for a sub-nested, that you'd like to remove.

    e.g.
    POST {tenantUrl}/entities?options=partialOverride
      
    [
      {
        "type": "configuration/entityTypes/HCP",
        "attributes": {
          "License": [
            {
              "value": {
                "Category": [
                  {
                    "value": null
                  }
                ],
                "State": [
                  {
                    "value": "CA"
                  }
                ],

    Please see these articles for more details:
    https://docs.reltio.com/entitiesapi/enablenestedpartialoverrideoption.html?hl=nested%2Cupdate
    https://docs.reltio.com/entitiesapi/keyattributeurisoption.html?hl=keyattributeuris

    Thanks,
    Artem

    ------------------------------
    Artem Kovalevsky
    ------------------------------



  • 3.  RE: Removing an item from a nest

    Reltio Partner
    Posted 3 days ago
      |   view attached
    Artem,
    We will try your idea. My fear is that we will get the unwanted behavior that we recently experienced while using "Clear Attribute" via Bulk Update in the UI, on each sub-attribute within a nested item. The result was that the item continued to exist, just with null values.  We had a label defined for the nest in the UI of TYPE + " - " + ID. After using Bulk Update, the item clearly remained in the nest but displayed as "-". After more experimentation, we then determined that we could use "Clear Attribute" at the identifier nest level (see attached screenshot) rather than at the sub-attribute level, and this actually produced the outcome we wanted. In theory, since Bulk Update was able to accomplish this, then the API must support it as well. But even so, it would likely take a lot of work to craft the proper POST to accomplish this when an item becomes missing in a source file, which is nested in Reltio. Again, my suggestion is that it would be very powerful to simply enhance partialOverride with a "delete" option.

    ------------------------------
    Curt Pearlman
    PwC
    Agoura Hills CA
    ------------------------------