2

How to retrieve DataExtension object associated with TriggeredSendDefinition ? I have been using the following code but its saying "Error: The Request Property(s) SendSourceDataExtension.Name do not match with the fields of TriggeredSendDefinition retrieve"

        RetrieveRequest rr = new RetrieveRequest
        {
            ObjectType = "TriggeredSendDefinition",
            Properties = new string[] { "CustomerKey", "Name", "SendSourceDataExtension.Name"},
            ClientIDs = new[] { clientId }
        };
        SimpleFilterPart sfp = new SimpleFilterPart
        {
            Property = "CustomerKey",
            SimpleOperator = SimpleOperators.equals,
            Value = new string[] { "expiry_notice" }
        };

        rr.Filter = sfp;

        status = soapClient.Retrieve(rr, out requestID, out results);

        foreach (TriggeredSendDefinition tsd in results)
        {
            Console.WriteLine(tsd.CustomerKey + " " + tsd.SendSourceDataExtension.Name);
        }

I have also tried to remove the Properties line from RetrieveRequest (hoping it will retrieve everything for the TriggeredSend) but it does not seem to work.

Is there a workaround to retrieve which data extension is associated with the TriggeredSendDefinition ?

  • Were you able to get the SendSourceDataExtension to display at all? – Kelly J Andrews Feb 21 '14 at 11:49
  • No. Even if I just put SendSourceDataExtension in Properties, it is not working. – user6872 Feb 21 '14 at 19:33
  • Let me know if this answers the question for you. – Kelly J Andrews Feb 22 '14 at 21:36
2

After running a describe method on the TriggeredSendDefinition object it returned with this:

<Properties>
  <PartnerKey xsi:nil="true"/>
  <ObjectID xsi:nil="true"/>
  <Name>SendSourceDataExtension</Name>
  <DataType>DataExtension</DataType>
  <IsUpdatable>true</IsUpdatable>
  <IsRetrievable>false</IsRetrievable>
</Properties>

Looks like that it is not retrievable.

Sample Describe Call

<Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
   <Header>  
      <fueloauth xmlns="http://exacttarget.com">AUTH TOKEN</fueloauth>
   </Header> 
   <Body>
      <DefinitionRequestMsg xmlns="http://exacttarget.com/wsdl/partnerAPI">
         <DescribeRequests>
            <ObjectDefinitionRequest>
               <ObjectType>TriggeredSendDefinition</ObjectType>
            </ObjectDefinitionRequest>
         </DescribeRequests>
      </DefinitionRequestMsg>
   </Body>
</Envelope>
| improve this answer | |

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.