Reltio Connect

Hi All,

we are pulling contact information from Reltio to our data warehouse using python requests for our reporting needs. One of the business requirement is not to show any records in reports which are deleted in Reltio. Is there any easy way to find this information in Reltio If any contact is deleted so that we can delete the records in our warehouse as well?

Thanks,

------------------------------
Rajendra Ravikrindi
------------------------------

A very elegant solution is to have the Data Warehouse subscribe to the business event ENTITY_REMOVED in the SQS queue.

------------------------------
Walt Feldman
Solutions Architect
Tenerity
------------------------------

I agree with Walt - the business event would be the cleanest approach.  If you are doing any batch extracts, deleted records will not be in them, so the absence of a record is hard to detect in the export.  

If you are doing extracts based on a time stamp, you could query the Activity Log for delete events since the last batch extract, then flag those records in your warehouse.  

This can be done either through the Dashboard UI or via the API.  Details on the API are available at: https://docs.reltio.com/activitylogapi/activitylogapi.html

The specific query is a REST GET: https://{{environment}}.reltio.com/reltio/api/{{tenantID}}/activities?filter=(gte(timestamp,%271613491471401%27)%20and%20equals(items.data.type,%20ENTITY_REMOVED%20))&offset=0&max=25

REST GET: https://{{environment}}.reltio.com/reltio/api/{{tenantID}}/activities?filter=(gte(timestamp,%271613491471401%27)%20and%20equals(items.data.type,%20ENTITY_REMOVED%20))&offset=0&max=25​

------------------------------
Dan Gage
Principal Solution Consultant
------------------------------

Thanks Dan Gage and Walt Feldman for your inputs.

Since we are fetching extracts based on timestamp I tried REST API but I see only my activities and seems I don't have permissions to see activities of other users. Is there any specific permissions that we need to see all the activities related to all users in Reltio?

Regards,

------------------------------
Rajendra Ravikrindi
Equinix
------------------------------

Original Message:
Sent: 06-21-2021 09:10
From: Daniel Gage
Subject: Information about deleted contacts in Reltio.

I agree with Walt - the business event would be the cleanest approach.  If you are doing any batch extracts, deleted records will not be in them, so the absence of a record is hard to detect in the export.  

If you are doing extracts based on a time stamp, you could query the Activity Log for delete events since the last batch extract, then flag those records in your warehouse.  

This can be done either through the Dashboard UI or via the API.  Details on the API are available at: https://docs.reltio.com/activitylogapi/activitylogapi.html

The specific query is a REST GET: https://{{environment}}.reltio.com/reltio/api/{{tenantID}}/activities?filter=(gte(timestamp,%271613491471401%27)%20and%20equals(items.data.type,%20ENTITY_REMOVED%20))&offset=0&max=25

------------------------------
Dan Gage
Principal Solution Consultant
------------------------------