Bulk Delete of Entities Without Executing LCA

5. RE: Bulk Delete of Entities Without Executing LCA

Recommend

Reltio Partner

karthick s

Posted 10-10-2022 00:32

Hi Chetan ,
Thanks for yr response.
2 ways you have mentioned will bulk delete the data but the problem here is that it will delete data as well as it will execute LCAs if any configured in Delete Hooks.
So my Ask is that We need to bulk detele the data and it should not execute any LCAs that were configured in Delete Hooks.

We are able to satisfy the requirement with smaller amount of data but with bulk amount of data we are searching a way to achieve it.

------------------------------
karthick s
Consultant
Capgemini
Chennai
------------------------------

Original Message

Original Message:
Sent: 10-10-2022 00:17
From: Chetan P
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Post-reading the above conversation, I could see two ways of performing Bulk deletion.

Way 1 - Through Front-End UI
Details : Choose the appropriate dataset (entities) using the search filter in UI and then click on 3 dots stating the bulk operation
In Bulk Operation, we need to select Bulk delete post reviewing we are selecting & deleting appropriate entities.

Way 2 - ROCS Utility
Details : Link to docs (https://docs.reltio.com/addonutilities/aboutaddons.html)
We can run the ROCS utility with the desired configuration to delete a profile w.r.t Entity, Crosswalk, source system, filter

------------------------------
Chetan P
Freshworks
------------------------------

Original Message:
Sent: 09-27-2022 09:45
From: karthick s
Subject: Bulk Delete of Entities Without Executing LCA

HI Shivaputrappa Patil,
I have used API given below..

API is working fine but parameter executeLCA=false is not working...Since we need to delete some entities without executing the LCA

POST {TenantURL}/entities/_delete?executeLCA=false

with some filter condition  in body

{  "objects": {    "filter": "equals(type, 'configuration/entityTypes/Individual')"  }}

Also we have used the ROCS utility to perform bulk delete but there also in config file we have used the parameter
EXECUTE_LCA=false as well as
executeLCA=false

but it did not worked..

So just want to know is there any other way to bulk delete records without executing LCAs?

------------------------------
karthick s
Consultant
Capgemini
Chennai

Original Message:
Sent: 09-27-2022 09:17
From: Shivaputrappa Patil
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Thank you for posting the question,

However, I would like to know to more about the API you are using to delete the records and the API param you are using

Would you please add more details on that?

------------------------------
Shivaputrappa Patil

6. RE: Bulk Delete of Entities Without Executing LCA

Recommend

Founding Member

Ashish Rawat

Posted 10-10-2022 03:03

Hi karthick,

If I understood your requirement clearly, you want to disable LCA while you are executing bulk delete. In my mind you can always turn of LCA from AWS Lambda or take it out of configuration, both these steps can be automated if bulk delete is a regular process you have.

------------------------------
Ashish Rawat
Manager
Fresh Gravity
Bangalore
------------------------------

Original Message

Original Message:
Sent: 10-10-2022 00:31
From: karthick s
Subject: Bulk Delete of Entities Without Executing LCA

Hi Chetan ,
Thanks for yr response.
2 ways you have mentioned will bulk delete the data but the problem here is that it will delete data as well as it will execute LCAs if any configured in Delete Hooks.
So my Ask is that We need to bulk detele the data and it should not execute any LCAs that were configured in Delete Hooks.

We are able to satisfy the requirement with smaller amount of data but with bulk amount of data we are searching a way to achieve it.

------------------------------
karthick s
Consultant
Capgemini
Chennai
------------------------------

Original Message:
Sent: 10-10-2022 00:17
From: Chetan P
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Post-reading the above conversation, I could see two ways of performing Bulk deletion.

Way 1 - Through Front-End UI
Details : Choose the appropriate dataset (entities) using the search filter in UI and then click on 3 dots stating the bulk operation
In Bulk Operation, we need to select Bulk delete post reviewing we are selecting & deleting appropriate entities.

Way 2 - ROCS Utility
Details : Link to docs (https://docs.reltio.com/addonutilities/aboutaddons.html)
We can run the ROCS utility with the desired configuration to delete a profile w.r.t Entity, Crosswalk, source system, filter

------------------------------
Chetan P
Freshworks

Original Message:
Sent: 09-27-2022 09:45
From: karthick s
Subject: Bulk Delete of Entities Without Executing LCA

HI Shivaputrappa Patil,
I have used API given below..

API is working fine but parameter executeLCA=false is not working...Since we need to delete some entities without executing the LCA

POST {TenantURL}/entities/_delete?executeLCA=false

with some filter condition  in body

{  "objects": {    "filter": "equals(type, 'configuration/entityTypes/Individual')"  }}

Also we have used the ROCS utility to perform bulk delete but there also in config file we have used the parameter
EXECUTE_LCA=false as well as
executeLCA=false

but it did not worked..

So just want to know is there any other way to bulk delete records without executing LCAs?

------------------------------
karthick s
Consultant
Capgemini
Chennai

Original Message:
Sent: 09-27-2022 09:17
From: Shivaputrappa Patil
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Thank you for posting the question,

However, I would like to know to more about the API you are using to delete the records and the API param you are using

Would you please add more details on that?

------------------------------
Shivaputrappa Patil

7. RE: Bulk Delete of Entities Without Executing LCA

Recommend

Founding Member

Gowthamprabhu Sivaraj

Posted 10-10-2022 03:08

Hi Karthick,

To support Ashish's point you can also try the Conditional execution of LCA. Conditional Execution of LCA

Reltio

remove preview

Conditional Execution of LCA

You can configure LCA to run only after requests from UI while ensuring that LCA is not triggered for other activies, such as data loads. In this case, we can apply filtering by clientType for the LCA.

View this on Reltio >

------------------------------
Gowthamprabhu Sivaraj
AstraZeneca
------------------------------

Original Message

Original Message:
Sent: 10-10-2022 03:03
From: Ashish Rawat
Subject: Bulk Delete of Entities Without Executing LCA

Hi karthick,

If I understood your requirement clearly, you want to disable LCA while you are executing bulk delete. In my mind you can always turn of LCA from AWS Lambda or take it out of configuration, both these steps can be automated if bulk delete is a regular process you have.

------------------------------
Ashish Rawat
Manager
Fresh Gravity
Bangalore
------------------------------

Original Message:
Sent: 10-10-2022 00:31
From: karthick s
Subject: Bulk Delete of Entities Without Executing LCA

Hi Chetan ,
Thanks for yr response.
2 ways you have mentioned will bulk delete the data but the problem here is that it will delete data as well as it will execute LCAs if any configured in Delete Hooks.
So my Ask is that We need to bulk detele the data and it should not execute any LCAs that were configured in Delete Hooks.

We are able to satisfy the requirement with smaller amount of data but with bulk amount of data we are searching a way to achieve it.

------------------------------
karthick s
Consultant
Capgemini
Chennai

Original Message:
Sent: 10-10-2022 00:17
From: Chetan P
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Post-reading the above conversation, I could see two ways of performing Bulk deletion.

Way 1 - Through Front-End UI
Details : Choose the appropriate dataset (entities) using the search filter in UI and then click on 3 dots stating the bulk operation
In Bulk Operation, we need to select Bulk delete post reviewing we are selecting & deleting appropriate entities.

Way 2 - ROCS Utility
Details : Link to docs (https://docs.reltio.com/addonutilities/aboutaddons.html)
We can run the ROCS utility with the desired configuration to delete a profile w.r.t Entity, Crosswalk, source system, filter

------------------------------
Chetan P
Freshworks

Original Message:
Sent: 09-27-2022 09:45
From: karthick s
Subject: Bulk Delete of Entities Without Executing LCA

HI Shivaputrappa Patil,
I have used API given below..

API is working fine but parameter executeLCA=false is not working...Since we need to delete some entities without executing the LCA

POST {TenantURL}/entities/_delete?executeLCA=false

with some filter condition  in body

{  "objects": {    "filter": "equals(type, 'configuration/entityTypes/Individual')"  }}

Also we have used the ROCS utility to perform bulk delete but there also in config file we have used the parameter
EXECUTE_LCA=false as well as
executeLCA=false

but it did not worked..

So just want to know is there any other way to bulk delete records without executing LCAs?

------------------------------
karthick s
Consultant
Capgemini
Chennai

Original Message:
Sent: 09-27-2022 09:17
From: Shivaputrappa Patil
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Thank you for posting the question,

However, I would like to know to more about the API you are using to delete the records and the API param you are using

Would you please add more details on that?

------------------------------
Shivaputrappa Patil

8. RE: Bulk Delete of Entities Without Executing LCA

Recommend

Reltio Partner

karthick s

Posted 10-11-2022 00:39

HI Gowtham,
This option looks like better ..Thanks we will try it out and share the results over here.

------------------------------
karthick s
Consultant
Capgemini
Chennai
------------------------------

Original Message

Original Message:
Sent: 10-10-2022 03:07
From: Gowthamprabhu Sivaraj
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

To support Ashish's point you can also try the Conditional execution of LCA. Conditional Execution of LCA

Reltio

remove preview

Conditional Execution of LCA

You can configure LCA to run only after requests from UI while ensuring that LCA is not triggered for other activies, such as data loads. In this case, we can apply filtering by clientType for the LCA.

View this on Reltio >

------------------------------
Gowthamprabhu Sivaraj
AstraZeneca
------------------------------

Original Message:
Sent: 10-10-2022 03:03
From: Ashish Rawat
Subject: Bulk Delete of Entities Without Executing LCA

Hi karthick,

If I understood your requirement clearly, you want to disable LCA while you are executing bulk delete. In my mind you can always turn of LCA from AWS Lambda or take it out of configuration, both these steps can be automated if bulk delete is a regular process you have.

------------------------------
Ashish Rawat
Manager
Fresh Gravity
Bangalore

Original Message:
Sent: 10-10-2022 00:31
From: karthick s
Subject: Bulk Delete of Entities Without Executing LCA

Hi Chetan ,
Thanks for yr response.
2 ways you have mentioned will bulk delete the data but the problem here is that it will delete data as well as it will execute LCAs if any configured in Delete Hooks.
So my Ask is that We need to bulk detele the data and it should not execute any LCAs that were configured in Delete Hooks.

We are able to satisfy the requirement with smaller amount of data but with bulk amount of data we are searching a way to achieve it.

------------------------------
karthick s
Consultant
Capgemini
Chennai

Original Message:
Sent: 10-10-2022 00:17
From: Chetan P
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Post-reading the above conversation, I could see two ways of performing Bulk deletion.

Way 1 - Through Front-End UI
Details : Choose the appropriate dataset (entities) using the search filter in UI and then click on 3 dots stating the bulk operation
In Bulk Operation, we need to select Bulk delete post reviewing we are selecting & deleting appropriate entities.

Way 2 - ROCS Utility
Details : Link to docs (https://docs.reltio.com/addonutilities/aboutaddons.html)
We can run the ROCS utility with the desired configuration to delete a profile w.r.t Entity, Crosswalk, source system, filter

------------------------------
Chetan P
Freshworks

Original Message:
Sent: 09-27-2022 09:45
From: karthick s
Subject: Bulk Delete of Entities Without Executing LCA

HI Shivaputrappa Patil,
I have used API given below..

API is working fine but parameter executeLCA=false is not working...Since we need to delete some entities without executing the LCA

POST {TenantURL}/entities/_delete?executeLCA=false

with some filter condition  in body

{  "objects": {    "filter": "equals(type, 'configuration/entityTypes/Individual')"  }}

Also we have used the ROCS utility to perform bulk delete but there also in config file we have used the parameter
EXECUTE_LCA=false as well as
executeLCA=false

but it did not worked..

So just want to know is there any other way to bulk delete records without executing LCAs?

------------------------------
karthick s
Consultant
Capgemini
Chennai

Original Message:
Sent: 09-27-2022 09:17
From: Shivaputrappa Patil
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Thank you for posting the question,

However, I would like to know to more about the API you are using to delete the records and the API param you are using

Would you please add more details on that?

------------------------------
Shivaputrappa Patil

9. RE: Bulk Delete of Entities Without Executing LCA

Recommend

Reltio Partner

karthick s

Posted 10-11-2022 00:36

Hi Ashish ,
Thanks for your valuable Suggestion.. We are already having this as our last Option in mind to do if nothing is possible. Since Client does not want to turn off any LCAs in Prod and also it was a regular activity. SO if no other go,then we will be doing this only.

------------------------------
karthick s
Consultant
Capgemini
Chennai
------------------------------

Original Message

Original Message:
Sent: 10-10-2022 03:03
From: Ashish Rawat
Subject: Bulk Delete of Entities Without Executing LCA

Hi karthick,

If I understood your requirement clearly, you want to disable LCA while you are executing bulk delete. In my mind you can always turn of LCA from AWS Lambda or take it out of configuration, both these steps can be automated if bulk delete is a regular process you have.

------------------------------
Ashish Rawat
Manager
Fresh Gravity
Bangalore
------------------------------

Original Message:
Sent: 10-10-2022 00:31
From: karthick s
Subject: Bulk Delete of Entities Without Executing LCA

Hi Chetan ,
Thanks for yr response.
2 ways you have mentioned will bulk delete the data but the problem here is that it will delete data as well as it will execute LCAs if any configured in Delete Hooks.
So my Ask is that We need to bulk detele the data and it should not execute any LCAs that were configured in Delete Hooks.

We are able to satisfy the requirement with smaller amount of data but with bulk amount of data we are searching a way to achieve it.

------------------------------
karthick s
Consultant
Capgemini
Chennai

Original Message:
Sent: 10-10-2022 00:17
From: Chetan P
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Post-reading the above conversation, I could see two ways of performing Bulk deletion.

Way 1 - Through Front-End UI
Details : Choose the appropriate dataset (entities) using the search filter in UI and then click on 3 dots stating the bulk operation
In Bulk Operation, we need to select Bulk delete post reviewing we are selecting & deleting appropriate entities.

Way 2 - ROCS Utility
Details : Link to docs (https://docs.reltio.com/addonutilities/aboutaddons.html)
We can run the ROCS utility with the desired configuration to delete a profile w.r.t Entity, Crosswalk, source system, filter

------------------------------
Chetan P
Freshworks

Original Message:
Sent: 09-27-2022 09:45
From: karthick s
Subject: Bulk Delete of Entities Without Executing LCA

HI Shivaputrappa Patil,
I have used API given below..

API is working fine but parameter executeLCA=false is not working...Since we need to delete some entities without executing the LCA

POST {TenantURL}/entities/_delete?executeLCA=false

with some filter condition  in body

{  "objects": {    "filter": "equals(type, 'configuration/entityTypes/Individual')"  }}

Also we have used the ROCS utility to perform bulk delete but there also in config file we have used the parameter
EXECUTE_LCA=false as well as
executeLCA=false

but it did not worked..

So just want to know is there any other way to bulk delete records without executing LCAs?

------------------------------
karthick s
Consultant
Capgemini
Chennai

Original Message:
Sent: 09-27-2022 09:17
From: Shivaputrappa Patil
Subject: Bulk Delete of Entities Without Executing LCA

Hi Karthick,

Thank you for posting the question,

However, I would like to know to more about the API you are using to delete the records and the API param you are using

Would you please add more details on that?

------------------------------
Shivaputrappa Patil

Reltio Connect