0

I am struggling with some UpsertData and i am running out of options. Hope you can see the problem. I have the following script on a CloudPage with a SmartCapture form:

%%[

SET @DE1 = "Martijn_content_nb_form_test"


SET @email = RequestParamater("email")
SET @urlArtikel3Consument = RequestParamater("urlArtikel3Consument")

IF NOT EMPTY("email") THEN
UpsertDE(@DE1, 1, "email",@email, 
"urlArtikel3Consument",@urlArtikel3Consument)

ENDIF
]%%

When I publish the page it remains polling and i could not publish the page. It happens on the RequestParameter because when i delete that part i can publish. Is there something i miss? Thanks a lot

1

I believe it is a typo: RequestParamater should be RequestParameter written with E.

https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/requestparameter.htm

| improve this answer | |
  • ahhhh thanks man! Didn't see that. One step further because it stil don't update an existing record. – Martijn e Feb 12 '19 at 13:53
0

Should be UpsertDATA. UpsertDE is for an email. UpsertDATA is for CloudPage.

| improve this answer | |
  • Thanks Tom. Unfortunately he only insert a new record and when i try a record allready exists he don't submit my form. – Martijn e Feb 12 '19 at 14:36
  • does your dataextension has a primary column, that won't allow multiple records with the same data? @TomCallahan shouldnt it be 8InsertData](developer.salesforce.com/docs/…) instead of UpsertData? – Johannes Schapdick Feb 12 '19 at 14:42
  • Yes the email field is the primary key but i thought that is the way to go? Strange thing is that when i change UpsertData to InsertData i can not publish my page. Does it has anything to do with the way i created the page? I mean with the new editor or the classic one? – Martijn e Feb 12 '19 at 14:52
  • I did some test with these results: 1. No primary keys. Now i can use the same emailaddress over and over again but it don't update the record. Instead it is every time a new record. 2. I use a combination of primary keys. I can use the same emailaddres but as soon the combination of the two primary keys are the same i can not submit my form. The other records are again new records. So no succes yet in how i can update a record instead of adding new records. – Martijn e Feb 12 '19 at 15:27
  • UpsertDATA adds or updates the Data Extension row referenced in the column and value arguments. Values updated are specified with column name and value pairs. If no record matches the values specified, a new row is added. This function does not return a value. InsertData inserts a row in a Data Extension with the specified column name and value pairs. Have you taken your cloudpage html/ampscript and dropped it into an email for debugging purposes yet? – Tom Callahan Feb 12 '19 at 16:18

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.