how to get the owner of a data extension in marketing cloud [closed]

Question

Is there any way to get the owner of a DE through API or Query?, Currently we have have a SOAP API but this is not bringing us the Owner, this would be the only attribute that does not call

Answer 1

It seems that it is impossible to retrieve it with currently available endpoints and methods. All in all, Owner field is found but non-retrievable. Here is what I have tried:

1. REST API:

GET https://[domain].rest.marketingcloudapis.com/data/v1/customobjectdata/key/[External Key]/rowset - Retrieves Data Extension data from Custom Object looked up by External Key. Not documented endpoint.

Result: does not mention Owner field at all

2. SSJS Data Extension Retrieve:

<script language="javascript" runat="server">
Platform.Load("Core", "1")
var Retrieve = DataExtension.Retrieve({Property: "Name", SimpleOperator: "equals", Value: "xxx"});
var Owner = Retrieve[0].Owner;
Write(Stringify(Owner));
</script>

Result: variable Owner returns NULL value

3. SSJS WSProxy Data Extension Retrieve:

<script language="javascript" runat="server">
Platform.Load("Core", "1")
var prox = new Script.Util.WSProxy();
var cols = ["CustomerKey", "Name", "Owner"];
var filter = {Property: "Name", SimpleOperator: "equals", Value: "xxx"};
var data = prox.retrieve("DataExtension", cols, filter);
Write(Stringify(data));
</script>

Result: returns "Error: The Request Property(s) Owner do not match with the fields of DataExtension retrieve"

4. SSJS WSProxy Data Extension object Describe:

<script language="javascript" runat="server">
Platform.Load("Core", "1")
var prox = new Script.Util.WSProxy();
var data = prox.describe("DataExtension");
Write(Stringify(data));
</script>

Result: Owner property is not retrievable, thus nothing you can do.