After discussion with Salesforce team, WSProxy do not provide same capabilities like Platform api to delete/update data of Data Extensions having no primary key.
Hence both WSProxy and Platform API have their own limitations as follows:-
- WSProxy can impersonate to other BU, hence can retrieve, maninpulate data extensions of different BUs, just setting client ID of that BU while initializing WSProxy client. But it cannot manipulate records of Data Extensions which do not have any primary key.
Hence the only way is to copy-paste deletion/updation scipt into every Business Unit. However we can trigger these automation from one BU using WS Proxy.
- Platform.Function api have capabilities to delete/update records of Data Extensions which do not have primary key, but it cannot impersionate different BU. Hence it can't access Data Extensions of other BU, except the current one.