Reltio Connect

I have two entity types in Reltio - Contact and Individual. The Contact entity contains a reference attribute that links to an Individual, but the Individual entity does not contain a reference back to Contact. I need to bulk hard delete all Individual entities that are not referenced by any Contact (orphan Individuals without relation).

Can someone help, is there any direct API approach to achieve in bulk without looping through each profile for relation exists and then delete.

Hi Prasad, 

Unfortunately, there isn't a single bulk API approach for your use case. However, you should be able to do it in steps as below. 

• Extract All Individual entity ids from Reltio. 
• Extract Individual Contact Relationship. Make sure that you are extracting the Start Oject and End Object Entity Id. Use options = resolveMergedEntities, so that you can get winner URIs only as start or end object entity id for merged records. 
• Then the goal will be find out the Individual entity ids that are not present in the relations dataset. You can do this by loading the two exports in a database table and join them to identify the required data or write a script to programmatically identify. 
  
• Once the entity ids are identified, you can trigger bulk update for those records in two ways
  • Update a Tag for all these records in Reltio, Search using that tag in the Advanced search and trigger bulk delete. 
  • Or you can use the URI list and the bulk delete ROCS utility to perform the delete. 

I have two entity types in Reltio - Contact and Individual. The Contact entity contains a reference attribute that links to an Individual, but the Individual entity does not contain a reference back to Contact. I need to bulk hard delete all Individual entities that are not referenced by any Contact (orphan Individuals without relation).

Can someone help, is there any direct API approach to achieve in bulk without looping through each profile for relation exists and then delete.

Hi Diparnab,

Thank you for your response. This is very helpful, and we will follow the steps you outlined to meet the requirement.

Hi Prasad, 

Unfortunately, there isn't a single bulk API approach for your use case. However, you should be able to do it in steps as below. 

• Extract All Individual entity ids from Reltio. 
• Extract Individual Contact Relationship. Make sure that you are extracting the Start Oject and End Object Entity Id. Use options = resolveMergedEntities, so that you can get winner URIs only as start or end object entity id for merged records. 
• Then the goal will be find out the Individual entity ids that are not present in the relations dataset. You can do this by loading the two exports in a database table and join them to identify the required data or write a script to programmatically identify. 
  
• Once the entity ids are identified, you can trigger bulk update for those records in two ways
  • Update a Tag for all these records in Reltio, Search using that tag in the Advanced search and trigger bulk delete. 
  • Or you can use the URI list and the bulk delete ROCS utility to perform the delete. 

I have two entity types in Reltio - Contact and Individual. The Contact entity contains a reference attribute that links to an Individual, but the Individual entity does not contain a reference back to Contact. I need to bulk hard delete all Individual entities that are not referenced by any Contact (orphan Individuals without relation).

Can someone help, is there any direct API approach to achieve in bulk without looping through each profile for relation exists and then delete.

Hi Diparnab,

Thank you for your response. This is very helpful, and we will follow the steps you outlined to meet the requirement.

Hi Prasad, 

Unfortunately, there isn't a single bulk API approach for your use case. However, you should be able to do it in steps as below. 

• Extract All Individual entity ids from Reltio. 
• Extract Individual Contact Relationship. Make sure that you are extracting the Start Oject and End Object Entity Id. Use options = resolveMergedEntities, so that you can get winner URIs only as start or end object entity id for merged records. 
• Then the goal will be find out the Individual entity ids that are not present in the relations dataset. You can do this by loading the two exports in a database table and join them to identify the required data or write a script to programmatically identify. 
  
• Once the entity ids are identified, you can trigger bulk update for those records in two ways
  • Update a Tag for all these records in Reltio, Search using that tag in the Advanced search and trigger bulk delete. 
  • Or you can use the URI list and the bulk delete ROCS utility to perform the delete. 

I have two entity types in Reltio - Contact and Individual. The Contact entity contains a reference attribute that links to an Individual, but the Individual entity does not contain a reference back to Contact. I need to bulk hard delete all Individual entities that are not referenced by any Contact (orphan Individuals without relation).

Can someone help, is there any direct API approach to achieve in bulk without looping through each profile for relation exists and then delete.

We are exploring one more approach. In our case, relationships are soft deleted, so we can export only inactive relationships (where activeness = NOT_ACTIVE). This ensures that only inactive relationships are included in the export.

After the export, we can read the start object/end object URIs to retrieve the individual entity IDs and proceed with deleting the corresponding profiles. This approach will help reduce the export size and allow us to run the process effectively as a daily task. Further we can implement hops API call before hard deleting the profile to check other related relationships to make sure all our conditions are satisfied.

Please note that this solution applies only to relationship soft-delete scenarios and will not work for hard deletes.

Let us know your thoughts.

Hi Diparnab,

Thank you for your response. This is very helpful, and we will follow the steps you outlined to meet the requirement.

Hi Prasad, 

Unfortunately, there isn't a single bulk API approach for your use case. However, you should be able to do it in steps as below. 

• Extract All Individual entity ids from Reltio. 
• Extract Individual Contact Relationship. Make sure that you are extracting the Start Oject and End Object Entity Id. Use options = resolveMergedEntities, so that you can get winner URIs only as start or end object entity id for merged records. 
• Then the goal will be find out the Individual entity ids that are not present in the relations dataset. You can do this by loading the two exports in a database table and join them to identify the required data or write a script to programmatically identify. 
  
• Once the entity ids are identified, you can trigger bulk update for those records in two ways
  • Update a Tag for all these records in Reltio, Search using that tag in the Advanced search and trigger bulk delete. 
  • Or you can use the URI list and the bulk delete ROCS utility to perform the delete. 

I have two entity types in Reltio - Contact and Individual. The Contact entity contains a reference attribute that links to an Individual, but the Individual entity does not contain a reference back to Contact. I need to bulk hard delete all Individual entities that are not referenced by any Contact (orphan Individuals without relation).

Can someone help, is there any direct API approach to achieve in bulk without looping through each profile for relation exists and then delete.