Reltio Connect

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
------------------------------

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
------------------------------

Original Message:
Sent: 08-04-2022 14:41
From: Curt Pearlman
Subject: Removing an item from a nest

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
------------------------------

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
------------------------------

Original Message:
Sent: 08-10-2022 01:49
From: Artem Kovalevsky
Subject: Removing an item from a nest

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

Original Message:
Sent: 08-04-2022 14:41
From: Curt Pearlman
Subject: Removing an item from a nest

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
------------------------------