Is there a way to use ExactTarget DEManager to update a data extension record instead of only add? I have a data extension that adds subscribers to specified lists (each list is its own boolean column). If a user goes to my DEManager form and the subscriber already exists, the form will return the error url ("subscriber already exists" or something similar). Is there any way instead for the form to update the existing subscriber record instead of it returning an error? If so, is there a way to use DEManager to first check if a record exists, and if it doesn't then add, otherwise update?

Reference: the DEManager section at http://help.exacttarget.com/en-US/documentation/exacttarget/subscribers/web_collect/

<form action="http://cl.exct.net/DEManager.aspx" name="subscribeForm" method="post">
        <input type="hidden" name="_clientID" value="12345" />
        <input type="hidden" name="_deExternalKey" value="WebCollectSubs" />
        <input type="hidden" name="_action" value="add" />
        <input type="hidden" name="_returnXML" value="0" />
        <input type="hidden" name="_successURL" value="http://example.com/Success" />
        <input type="hidden" name="_errorURL" value="http://example.com/Failed" />
        Email: <input type="text" name="Email"><br />
        First Name: <input type="text" name="FirstName"><br />
        Last Name: <input type="text" name="LastName"><br />
        <input type="submit" value="Submit">

DEManger does support update.

<input type="hidden" name="_action" value="update" />

For an add/update or upsert action, it is recommended to use the SOAP API data extension functionality for forms that are hosted outside of the Salesforce Marketing Cloud, or Smart Capture for forms in Marketing Cloud landing pages.

  • I have tried name="_action" value="update" in the form and I believe updating only happens if it finds a record, otherwise we will receive an error An error occurred updating the data extensionIs there actually any way to upsert with WEB COLLECT? – tkhuynh Oct 2 '17 at 17:11
  • @tkhuynh There is a "sub_add_update" SubAction value that can be used for lists. However, for data extensions, it's best to use the API for upserts. – Steve J Oct 6 '17 at 20:03

You have to use below code it will work fine for me.

<input type="hidden" name="_action" value="add/update" />;
  • excellent work it's working perfect thank you very much for this code. – UserSFMC Mar 1 '18 at 12:56
  • Anyone knows how to update shared DE with this method? Any help will be highly appreciated. – R Suri May 10 '18 at 11:16

i am using the same method but in my case it is Shared Data Extension. Anyone knows how to update shared DE with this method? Any help will be highly appreciated.

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.