Code@ Questions have Moved!

In an effort to streamline our efforts, Code@ has moved the Questions and Answers section to the Salesforce StackExchange site, which you can find at the following url: http://salesforce.stackexchange.com/questions/tagged/exacttarget. Please be sure to TAG YOUR QUESTIONS with exacttarget, so our partners know specifically what application your question is pertaining to, and our experts can provide you with a more timely response.

We will discontinue support for this section, and will only be monitoring questions at that location. If your question is currently unanswered, feel free to post that same question on StackExchange to the broader community.

Thank you for your understanding!

Home / question / Upserting a Triggered Send Data Extension?
Ask A Question

Upserting a Triggered Send Data Extension?

15 points
ian91's picture

Do we have any SOAP and/or .Net samples of upserting a Triggered Send Data extension?

Product Group: 

Comments

3720 points
jmeketa's picture

If you have already setup the triggered send definition using the data extension template through UI or built definition using API then you simply call the TriggeredSend object the same way you do for any triggered send. That is why there is not a specific code sample for triggering a data extension based triggered send.

The subscriber object that you pass is the data extension row. You will create subscriber attributes for the subscribers in the the array with names that match the data extension fields to pass the information. If you pass the appropriate information for the data extension row in the subscriber object the row will be added to the data extension and the email will be triggered.

http://docs.code.exacttarget.com/020_Web_Service_Guide/Technical_Articles/Send_TriggeredSend_Email

http://docs.code.exacttarget.com/020_Web_Service_Guide/Triggered_Email_Scenario_Guide_For_Developers

Thanks,

Jason

15 points
ian91's picture

Jason,

 

Sorry for the lack of detail in the question :) BUT let's say the Triggered Send Send Definition is working properly (subscribers are added to the TS DE) and the Triggered Send Data Extension is being used as a profile/preference repository and the user wants to  update a field (i.e. FirstName)...can an Update/Upsert be called to make these updates? Will it consider the EmailAddress/SubscriberKey combo as the primary keys?

 

Thx,

Ian

8232 points
Michael Clark's picture

Hello Ian, 

TriggeredSend Data Extensions are intended to be a log of every email sent using the TriggeredSend definition that it is tied to.  The TriggeredSend Data extension should never have primary key field on it since it could prevent new rows from being added in order to do a send. 

There is no way to make it perform an upsert to the TriggeredSend Data Extension. I would recommend creating a separate data extension for the purpose of keeping a master record of all of the subscribers for the account. 

Regards,

Michael