[SalesForce] Retrieving Shared Data Extension folders using the SOAP API

I'm using the SOAP envelope below to retrieve Data Extension folders and subfolders in a Business Unit, which works fine. However, it doesn't return any folders that exist in the Shared Data Extensions folder. Does anyone know if this is possible?

<?xml version="1.0" encoding="UTF-8"?>
<s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
   <s:Header>
      <a:Action s:mustUnderstand="1">Retrieve</a:Action>
      <a:MessageID>urn:uuid:7e0cca04-57bd-4481-864c-6ea8039d2ea0</a:MessageID>
      <a:ReplyTo>
         <a:Address>http://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous</a:Address>
      </a:ReplyTo>
      <a:To s:mustUnderstand="1">{{soapEndPoint}}/Service.asmx</a:To>
      <fueloauth xmlns="http://exacttarget.com">{{accessToken}}</fueloauth>
   </s:Header>
   <s:Body xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
      <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
         <RetrieveRequest>
                <ObjectType>DataFolder</ObjectType>
                <Properties>ID</Properties>
                <Properties>Name</Properties>
                <Properties>ContentType</Properties>
                <Properties>ParentFolder.Name</Properties>
                <Properties>ObjectID</Properties>
                <Properties>ParentFolder.ObjectID</Properties>
                <ns1:Filter
                     xmlns:ns1="http://exacttarget.com/wsdl/partnerAPI" xsi:type="ns1:SimpleFilterPart">
                     <ns1:Property>ContentType</ns1:Property>
                     <ns1:SimpleOperator>equals</ns1:SimpleOperator>
                     <ns1:Value>dataextension</ns1:Value>
                </ns1:Filter>
                <QueryAllAccounts>true</QueryAllAccounts>
            </RetrieveRequest>
      </RetrieveRequestMsg>
   </s:Body>
</s:Envelope>

Best Answer

In simple filter, replace dataextension with shared_dataextension

http://help.marketingcloud.com/en/technical_library/web_service_guide/objects/datafolder/

Related Solutions

[SalesForce] Retrieving folders and subfolders of an ExactTarget Data Extension with SOAP

you can request "ParentFolder.ID and "ParentFolder.Name" as properties in your DataFolder RetrieveRequest. With that information, you can use recursive logic to match up ParentFolder.ID to ID and rebuild your DataFolder paths.

[SalesForce] How to get list of data extension fields using SOAP API

It's a simple retrieve on the DataExtensionField object. You can filter on DataExtension.CustomerKey if you want to view the columns for a specific Data Extension.

Here's a example SOAP envelope: https://gist.github.com/wvpv/9001b002ebf7552f64db

<?xml version="1.0" encoding="UTF-8"?>
<s:Envelope xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://schemas.xmlsoap.org/ws/2004/08/addressing" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
   <s:Header>
      <a:Action s:mustUnderstand="1">Retrieve</a:Action>
      <a:MessageID>urn:uuid:e3f7fdfe-d225-47fb-a764-ad4f465fb724</a:MessageID>
      <a:ReplyTo>
         <a:Address>http://schemas.xmlsoap.org/ws/2004/08/addressing/role/anonymous</a:Address>
      </a:ReplyTo>
      <a:To s:mustUnderstand="1">https://webservice.exacttarget.com/Service.asmx</a:To>
      <o:Security xmlns:o="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd" s:mustUnderstand="1">
         <u:Timestamp u:Id="_0">
            <u:Created>2014-11-18T14:44:10.936Z</u:Created>
            <u:Expires>2014-11-18T14:49:10.936Z</u:Expires>
         </u:Timestamp>
         <o:UsernameToken u:Id="uuid-642de236-bbe2-41d9-b965-d107063c913c-3">
            <o:Username>
               <!-- Removed-->
            </o:Username>
            <o:Password>
               <!-- Removed-->
            </o:Password>
         </o:UsernameToken>
      </o:Security>
   </s:Header>
   <s:Body xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
      <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
         <RetrieveRequest>
            <ObjectType>DataExtensionField</ObjectType>
            <Properties>Client.ID</Properties>
            <Properties>CreatedDate</Properties>
            <Properties>CustomerKey</Properties>
            <Properties>DataExtension.CustomerKey</Properties>
            <Properties>DefaultValue</Properties>
            <Properties>FieldType</Properties>
            <Properties>IsPrimaryKey</Properties>
            <Properties>IsRequired</Properties>
            <Properties>MaxLength</Properties>
            <Properties>ModifiedDate</Properties>
            <Properties>Name</Properties>
            <Properties>ObjectID</Properties>
            <Properties>Ordinal</Properties>
            <Properties>Scale</Properties>
            <Filter xsi:type="SimpleFilterPart">
               <Property>DataExtension.CustomerKey</Property>
               <SimpleOperator>equals</SimpleOperator>
               <Value>DATA EXTENSION NAME</Value>
            </Filter>
            <QueryAllAccounts>true</QueryAllAccounts>
            <Retrieves />
            <Options>
               <SaveOptions />
               <IncludeObjects>true</IncludeObjects>
            </Options>
         </RetrieveRequest>
      </RetrieveRequestMsg>
   </s:Body>
</s:Envelope>

Related Topic