2

I have an email send definition that's configured to send to multiple data extensions. I've seen a few posts (here, here and here) that say retrieving the Names or CustomerKeys of these data extensions isn't possible using the SOAP API.

However, when I retrieve the ListSend object for a particular send, I (surprisingly) see a List object for each of the Data Extensions.

Is there any way to map these back to API retrievable objects?

List.ID:  429   List.ListName:  All Subscribers
List.ID:  5036  List.ListName:  VPL 5036 for List 429
List.ID:  5037  List.ListName:  VPL 5037 for List 429
List.ID:  5038  List.ListName:  VPL 5038 for List 429
List.ID:  5039  List.ListName:  VPL 5039 for List 429
2
  • I know you're definitely on the "power-user" end of the spectrum so I assume you know about send logging... can you comment on why that won't work for you?
    – Timothy
    Jan 6 '15 at 13:20
  • Technically it will work, but an API solution would be much less disruptive. First, you can't enforce sendlogging for every send (as far as I know). Also, it only covers sends from the point it's been enabled, so we can't pull historical data. Plus, you'd need to add scripting to every email, which can be problematic if the client is building their own emails. Jan 6 '15 at 14:16
0

Looks like your only option is to match by name here:

   <soapenv:Body>
      <RetrieveRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
         <RetrieveRequest>
            <Properties>CreatedDate</Properties>
            <Properties>CustomerKey</Properties>
            <Properties>Name</Properties>
            <ObjectType>DataExtension</ObjectType>
            <Properties>Description</Properties>
            <Properties>Status</Properties>
            <Filter xsi:type="SimpleFilterPart">
               <Property>Name</Property>
               <SimpleOperator>equals</SimpleOperator>
               <Value>TestSendRecipient</Value>
            </Filter>
         </RetrieveRequest>
      </RetrieveRequestMsg>
   </soapenv:Body>
3
  • The lists above appear to be temporary, since they mirror the DE's used in the send audience. I haven't been able to retrieve them by ID or by name. Jan 6 '15 at 14:38
  • Strange. Not sure there is any other way to get it back then without send logging... Jan 6 '15 at 14:54
  • For the historical data, you will need to enlist the help of a Data Architect by purchasing a services engagement.
    – Timothy
    Jan 6 '15 at 15:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.