Reltio Connect

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
------------------------------

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
------------------------------

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
------------------------------