1

Background
Subscribers perform on action on a website. The subscriber record is then added into a Triggered Data Extension and an email is sent out as part of the API call / Triggered Email Interaction. Tried, true, tested.

Scenario
I am wondering if when the API call is made inserting the subscriber into the Triggered Send Data Extension, if it could update that subscribe's record if it found a matching Primary Key? So for example, we add an additional attribute into the Data Extension and make it the Primary Key, and when that API call runs it either adds a new record or updates the existing one based on the Primary Key passed through the API call.

I've tested it out and all email sends are stuck in queueing for the triggered email interaction, leading me to believe it wasn't happy with the Primary Key.

Before sinking in more hours on what may be a lost cause I thought to check if anyone has ever attempted this before, and if so what results they found.

1

The above scenario is not possible with Trigger send Data extension template. Trigger send DE is used for the purpose of tracking the email sends, so every time you do a trigger send it will insert a new record in the Trigger send DE. Instead, you create another dataextension an upsert the values in that DE.

|improve this answer|||||
  • Bit of a shame for one of my use cases, but not the end of the world. Thanks for confirming. – AnonWonderer Jun 2 '17 at 16:35

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.