Reltio Connect

 View Only

  • 1.  Information about deleted contacts in Reltio.

    Posted 06-18-2021 07:14
    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
    ------------------------------


  • 2.  RE: Information about deleted contacts in Reltio.

    Founding Member
    Posted 06-18-2021 08:03
    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
    ------------------------------

    Original Message


  • 3.  RE: Information about deleted contacts in Reltio.
    Best Answer

    Reltio Employee
    Posted 06-21-2021 09:11
    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
    ------------------------------

    Original Message


  • 4.  RE: Information about deleted contacts in Reltio.

    Posted 06-21-2021 10:39
    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