I want to publish a record deletion throw Data Notification, and want to perform delete operation through sql and rest API.
Best Answer
B
Bharat Joshi
said
over 1 year ago
Data deletion can be done through Sql and through Rest Api
Golden record deletion applies to all entities and is similar to deleting a golden record from an application.
To publish a golden record deletion, you must load the following columns into the SA table (even for ID and fuzzy matched entities):
B_LOADID: Load this column with the Load ID provided by the GET_NEW_LOADID function call, or with the ID of the Continuous Load. Use the GET_CONTINUOUS_LOADID function to retrieve a continuous load ID from the continuous load name.
B_DELETETYPE: Load this column with the SOFT_DELETE or HARD_DELETE value depending on the type of delete that you want to trigger.
B_DELETEOPERATION: Delete operation ID. This ID must be a unique value for each deleted record. For example, use a UUID that you convert to a string (e.g.: Using the functions RAWTOHEX(SYS_GUID())).
4.B_CLASSNAME: Load this column with the name of the entity of the records to delete.
Below is the code used for deletion
do
$$
declare
v_load_id int;
begin
v_load_id := semarchy_repository.get_new_loadid (
'test' /* Data Location name. case sensitive. Found in Application Builder. */
,'manual_etl_script' /* Informational program name. Identifies the middleware. */
,'load_data_update' /* Informational. Describes the load. */
,'manual_etl_user' /* User initializing the load. (Not found in Application Builder.) */
);
raise notice '%', v_load_id;
end;
$$;
insert into SEM_5_3_7_DATA.SA_PRODUCT (
B_LOADID,
ID,
B_CLASSNAME,
B_DELETETYPE,
B_DELETEOPERATION
)
select
12112,
112222111,
'Product',
'HARD_DELETE',
RAWTOHEX(SYS_GUID())
from SEM_5_3_7_DATA.GD_PRODUCT where ID = '112222111';
do
$$
declare
v_batch_id int;
begin
v_batch_id := semarchy_repository.submit_load (
65 /* Load ID returned by get_new_loadid from Step 1 */
,'DDJ_sample' /* Must exactly match a defined integration job. Found in Application Builder. */
,'manual_etl_user' /* Must exactly match the value used in get_new_loadid in Step 1. */
);
raise notice '%', v_batch_id;
end;
$$;
For deletion through rest api You can use the endpoint to load data, with the DELETE_DATA action, in order to publish record deletions.
1 Comment
B
Bharat Joshi
said
over 1 year ago
Answer
Data deletion can be done through Sql and through Rest Api
Golden record deletion applies to all entities and is similar to deleting a golden record from an application.
To publish a golden record deletion, you must load the following columns into the SA table (even for ID and fuzzy matched entities):
B_LOADID: Load this column with the Load ID provided by the GET_NEW_LOADID function call, or with the ID of the Continuous Load. Use the GET_CONTINUOUS_LOADID function to retrieve a continuous load ID from the continuous load name.
B_DELETETYPE: Load this column with the SOFT_DELETE or HARD_DELETE value depending on the type of delete that you want to trigger.
B_DELETEOPERATION: Delete operation ID. This ID must be a unique value for each deleted record. For example, use a UUID that you convert to a string (e.g.: Using the functions RAWTOHEX(SYS_GUID())).
4.B_CLASSNAME: Load this column with the name of the entity of the records to delete.
Below is the code used for deletion
do
$$
declare
v_load_id int;
begin
v_load_id := semarchy_repository.get_new_loadid (
'test' /* Data Location name. case sensitive. Found in Application Builder. */
,'manual_etl_script' /* Informational program name. Identifies the middleware. */
,'load_data_update' /* Informational. Describes the load. */
,'manual_etl_user' /* User initializing the load. (Not found in Application Builder.) */
);
raise notice '%', v_load_id;
end;
$$;
insert into SEM_5_3_7_DATA.SA_PRODUCT (
B_LOADID,
ID,
B_CLASSNAME,
B_DELETETYPE,
B_DELETEOPERATION
)
select
12112,
112222111,
'Product',
'HARD_DELETE',
RAWTOHEX(SYS_GUID())
from SEM_5_3_7_DATA.GD_PRODUCT where ID = '112222111';
do
$$
declare
v_batch_id int;
begin
v_batch_id := semarchy_repository.submit_load (
65 /* Load ID returned by get_new_loadid from Step 1 */
,'DDJ_sample' /* Must exactly match a defined integration job. Found in Application Builder. */
,'manual_etl_user' /* Must exactly match the value used in get_new_loadid in Step 1. */
);
raise notice '%', v_batch_id;
end;
$$;
For deletion through rest api You can use the endpoint to load data, with the DELETE_DATA action, in order to publish record deletions.
Bharat Joshi
Data deletion can be done through Sql and through Rest Api
Golden record deletion applies to all entities and is similar to deleting a golden record from an application.
To publish a golden record deletion, you must load the following columns into the SA table (even for ID and fuzzy matched entities):
B_LOADID: Load this column with the Load ID provided by the GET_NEW_LOADID function call, or with the ID of the Continuous Load. Use the GET_CONTINUOUS_LOADID function to retrieve a continuous load ID from the continuous load name.
B_DELETETYPE: Load this column with the SOFT_DELETE or HARD_DELETE value depending on the type of delete that you want to trigger.
B_DELETEOPERATION: Delete operation ID. This ID must be a unique value for each deleted record. For example, use a UUID that you convert to a string (e.g.: Using the functions RAWTOHEX(SYS_GUID())).
4.B_CLASSNAME: Load this column with the name of the entity of the records to delete.
Below is the code used for deletion
For deletion through rest api You can use the endpoint to load data, with the DELETE_DATA action, in order to publish record deletions.
Bharat Joshi
Data deletion can be done through Sql and through Rest Api
Golden record deletion applies to all entities and is similar to deleting a golden record from an application.
To publish a golden record deletion, you must load the following columns into the SA table (even for ID and fuzzy matched entities):
B_LOADID: Load this column with the Load ID provided by the GET_NEW_LOADID function call, or with the ID of the Continuous Load. Use the GET_CONTINUOUS_LOADID function to retrieve a continuous load ID from the continuous load name.
B_DELETETYPE: Load this column with the SOFT_DELETE or HARD_DELETE value depending on the type of delete that you want to trigger.
B_DELETEOPERATION: Delete operation ID. This ID must be a unique value for each deleted record. For example, use a UUID that you convert to a string (e.g.: Using the functions RAWTOHEX(SYS_GUID())).
4.B_CLASSNAME: Load this column with the name of the entity of the records to delete.
Below is the code used for deletion
For deletion through rest api You can use the endpoint to load data, with the DELETE_DATA action, in order to publish record deletions.
-
Import Data Into Entities via Azure Data Lake
-
Recover Deleted(soft Delete) Record and Configure in Application
-
Data Quality in batch mode and real-time integration
-
Integration with analytics tools
-
Query/Load/Delete data with the REST API
-
Does the Done Tab in Inbox have a limit?
-
How Can I Trigger Enricher or Sql Procedure when deleting?
-
Matching Rules But Only The Latest Record Creates a Golden Record
-
Unstructured and Semi Structured Data in Semarchy?
-
Read CSV files from AWS S3
See all 71 topics