Wanted to see how you made out, did find out details from my tech.
They use reltio-util-bulkdelete-1.9.1-jar-with-dependencies.jar
It does hard delete the source/crosswalk from the input file.
#Password Encrypted
#Mon Apr 26 16:35:30 IST 2021
ACTION=crosswalks
RECORDS_PER_POST=50
ENVIRONMENT_URL=yourtenent.reltio.com
INPUT=DeleteHRSFDC.txt (input txt file)
available_actions=[filter, uris, crosswalks, sourcesystem, relationsByType, relationbycrosswalks,relationsByEntitiesCrossWalks,relationsuris,crosswalksuris]
DELIMITER=\#
THREAD_COUNT=30
TENANT_ID=your tenant id
USERNAME=userid
AUTH_URL=https\://auth.reltio.com/oauth/token
OUTPUT_FILE=DeleteHRSFDC_out.txt
PASSWORD=ENC(pwd)
Command: java -jar reltio-util-bulkdelete-1.9.1-jar-with-dependencies.jar configuration.properties y > failedrecord.log
uses
------------------------------
Angela Wawrzaszek
Manager, MDM governance and Application Enablement
------------------------------
Original Message:
Sent: 02-03-2022 05:59
From: Rupam Dutta
Subject: API to delete a specific crosswalk for a MDM entity
Appreciate your response Angela. Deactivating profile by updating delete date is currently in our practice and process is automated however I'm modifying the process to delete the complete crosswalk if receives the signal from source to stay in a complete sync. API proposed by Snehil definitely helps but crosswalk URI to be captured first by referring crosswalk API call.
I'll shout back if any questions, thanks again for your reply!
------------------------------
Rupam Dutta
Data Architecture Manager
Cloudera
Original Message:
Sent: 02-02-2022 17:58
From: Angela Wawrzaszek
Subject: API to delete a specific crosswalk for a MDM entity
Rupam,
I will get the details from my technical but this is something we have utilized alot to delete profiles with a delete-date or other business reasons. I believe it is through a ROCS utiliy.
I provide Tech with a list of Source, Crosswalk Key's and they run the job to hard delete these from Reltio. In addition we must also run a similar job to hard delete from any published tables used.
So not automated, because the 'definition' of a hard delete varies. We do on an as needed basis.
Let me know if you would like the details.
thankyou,
Angie
------------------------------
Angela Wawrzaszek
Manager, MDM governance and Application Enablement
Original Message:
Sent: 01-17-2022 10:18
From: Rupam Dutta
Subject: API to delete a specific crosswalk for a MDM entity
Thanks Snehil, appreciate your responses.
------------------------------
Rupam Dutta
Data Architecture Manager
Cloudera
Dublin
Original Message:
Sent: 01-14-2022 09:09
From: Snehil Kamal
Subject: API to delete a specific crosswalk for a MDM entity
Hi Rupam,
I am afraid there is no such API available at the moment which takes source system name and crosswalk value as the input. However, there is an open source utility using which you can do this.
The utility takes a file as an input where you can supply the list of crosswalk values. See Action=Crosswalk in the QuickStart file of this utility. The sourc code of this JAVA utility is publicly available and you can also modify it as per your requirements.
Hope this helps.
------------------------------
Thanks,
Snehil Kamal
Solution Architect
Reltio
Bangalore
Original Message:
Sent: 01-14-2022 07:46
From: Rupam Dutta
Subject: API to delete a specific crosswalk for a MDM entity
Thanks Snehil for sharing the API, Is there any way to delete the crosswalk by referring Crosswalk ID (not the URI generated by Reltio) and Source ID.
For example - Each crosswalk is tagged with an unique id from source and source type (e.g. Salesforce, SAP), Relto generates any URI of that crosswalk and above API can delete that crosswalk by referring the URI, I'm looking for an API where source type and unique ID can be parameterised for the deletion.
Thanks
Rupam
------------------------------
Rupam Dutta
Data Architecture Manager
Cloudera
Dublin
Original Message:
Sent: 01-13-2022 09:56
From: Snehil Kamal
Subject: API to delete a specific crosswalk for a MDM entity
Hi Rupam,
Below is the API you are looking for
DELETE {{tenantURL}}/entities/015BfjW/crosswalks/7VqDySK/
015BfjW is the Entity URI and 7VqDySK is the crosswalk URI in the above example
Alternatively, you can find APIs for any operation from your browser's developer console. Just open developer console (Ctrl+Shift+I in Chrome), simulate the operation from UI, and grab the API definition
Hope this helps. Please let me know if you have any questions.
------------------------------
Thanks,
Snehil Kamal
Solution Architect
Reltio
Bangalore
Original Message:
Sent: 01-13-2022 07:32
From: Rupam Dutta
Subject: API to delete a specific crosswalk for a MDM entity
Many Source system crosswalks contribute of creating a MDM entity (Organisation, Person etc.), I'm looking for an API to delete specific crosswalk for a MDM profile upon receiving request from source system that same is removed. MDM profile should stay as it is only specific crosswalk needs to be deleted, I can do the same from UI but looking for the API so can automate the integration.
Reltio Doc reference (could not locate the API)
https://docs.reltio.com/profiles/objectdeletion.html?hl=delete%2Ccrosswalk
If retaining representation of its previous presence is not important, then a best practice is to delete the crosswalk entirely from the entity to avoid build-up of unnecessary crosswalks in your tenant. Additionally, if you wish the values contributed by the crosswalk to cease being used to attract similar values in match rules, then again this is a good reason to delete the crosswalk entirely.
Thanks,
Rupam
------------------------------
Rupam Dutta
Data Architecture Manager
Cloudera
Dublin
------------------------------