Reltio Connect

 View Only

  • 1.  Export History of every changes made to a profile in Reltio

    Posted 02-06-2024 10:03

    Hello,

    We have got an audit requirement where the auditors want to see who has modified the vendor profiles and when.

    I know we can see this in the "History" tab from the Reltio UI for each profile. However, it is impossible for me to check 10k plus profiles individually so is there a way I can export the history (showing who updated the profile, when and what) for all the profiles at once for a given time frame.

    Thanks in advance for your help

    Nikhil



    ------------------------------
    Nikhil Shah
    Amneal Pharmaceuticals
    ------------------------------



  • 2.  RE: Export History of every changes made to a profile in Reltio

    Posted 02-06-2024 15:07

    Hi Nikhil,

    I am not sure about achieving this by a single API call.

    1. Identify the audit period

    2. Export all the  entities URI based on the  audit period

    3.  For each of the entity URI, you need to make multiple calls to history the profile. This can be done through Java or Python.  Download any of the ROCS utilities, and modify them according to your requirements .
       a. https://dev.reltio.com/nui/reltioAPI/api/XXXXX/entities/AAAAAAA/_changesWithTotal?filter=(equals(type%2C%20%27ENTITY_CREATED%27)%20or%20equals(type%2C%20%27ENTITY_REMOVED%27)%20or%20equals(type%2C%20%27ENTITY_LOST_MERGE%27)%20or%20equals(type%2C%20%27ENTITIES_MERGED%27)%20or%20equals(type%2C%20%27ENTITIES_MERGED_MANUALLY%27)%20or%20equals(type%2C%20%27ENTITIES_MERGED_ON_THE_FLY%27)%20or%20equals(type%2C%20%27ENTITIES_SPLITTED%27)%20or%20equals(type%2C%20%27ENTITY_CHANGED%27))%20and%20(not%20equals(user%2C%20%27collaboration-service%27))&showAll=true&order=desc

    This should return all the changes to the entities along with the total number of changes.

    {
        "changes": [
            {
                "timestamp": 1707207089770,
                "user": "XXX",
                "type": "ENTITY_CHANGED"
            },
            {
                "timestamp": 1706865357960,
                "user": "XXX",
                "type": "ENTITY_CHANGED"
            },
            {
                "timestamp": 1705625084546,
                "user": "XXXX",
                "type": "ENTITY_CHANGED"
            },
            {
                "timestamp": 1705625081464,
                "user": "XXX",
                "type": "ENTITY_CHANGED"
            },
            {
                "timestamp": 1701733317087,
                "user": "XXXX",
                "type": "ENTITY_CHANGED"
            },
            {
                "timestamp": 1699625944431,
                "user": "XXXX",
                "type": "ENTITY_CHANGED"
            },
            {
                "timestamp": 1699625939867,
                "user": "XXX",
                "type": "ENTITY_CHANGED"
            }
        ],
        "total": 7
    }

    4.  Loop through each of the changes and report them  based on the below api call

    https://dev.reltio.com/nui/reltioAPI/api/XXXXX/entities/AAAAAAA?time=1707207089770&options=sendHidden%2CaddRefAttrUriToCrosswalk

    Repeat the same for all the  URI's.

    Please let me know.

     



    ------------------------------
    Radhakrishnan Ramalingam
    Architect
    San Ramon CA
    ------------------------------

    Original Message


  • 3.  RE: Export History of every changes made to a profile in Reltio

    Founding Member
    Posted 02-07-2024 23:41

    You can export all the activities in Reltio MDM. Here is the API to fetch various kind of updates on all the records in specific timeframe. You can add or remove filters as per your need

    {{tenantURL}}/activities?filter=(equals(items.data.type, ENTITY_CREATED) or equals(items.data.type, ENTITIES_MERGED_MANUALLY) or equals(items.data.type, ENTITY_REMOVED) or equals(items.data.type, ENTITIES_SPLITTED) or equals(items.data.type, ENTITY_CHANGED)) and (gte(timestamp, 1699418304056)) and (not equals(user, 'collaboration-service'))&max=10&offset=0



    ------------------------------
    Ashish Rawat
    Sr. Manager
    Fresh Gravity
    Bangalore
    ------------------------------

    Original Message


Related Content