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.