Hard Delete a Leaf member using the API ?

Question

Hey Does Anyone know how to hard delete a leaf member using the API ? and not by using the staging process, ETL etc.....

---

The Webel

Answer 1

Okay 

how about this then, Bad practice i know, but since i cant wait for the staging processing cycle  nor do i want to inundate the server by reducing the processing frequency I've opted for a custom stored proc

it should be self explanatory.

here is a stored proc that I whacked together which i am calling in my code.

create proc usr.HardDeleteMemberByCode
@ModelName varchar(100),
@VersionName varchar(100),
@EntityName varchar(100),
@MemberCode varchar(100)
as

declare @SQL varchar(max), @entitytable varchar(60)

select  @entitytable  = EntityTable 
from mdm.tblEntity E
Inner join mdm.tblModelVersion mv
on mv.Model_ID = e.Model_ID
inner join mdm.tblModel m
on m.ID = mv.ID
where m.Name = @ModelName and 
 mv.Name = @VersionName and
 E.Name = @EntityName 

set @SQL = 'delete from mdm.' + @entitytable   + ' where code = ''' + @MemberCode + ''''
--print @sql

exec (@sql)

go

P.S if anyone knows the API method call please let me know

thanks

!

---

The Webel