Skip to main content
7 events
when toggle format what by license comment
Jun 2, 2023 at 15:37 comment added Eddie Belhay Thank you again, I tried it again with the parameters in 1 array and using UpsertDE and it worked!! (I wasn't publishing the cloud page thinking it would still run in just the preview) :)
Jun 2, 2023 at 15:34 vote accept Eddie Belhay
Jun 2, 2023 at 14:58 comment added Rachid Mamai No worries. As explained in my answer, you need to use either UpsertDE or UpsertData depending on the execution context. I've already tested the code in a cloudpage and it's inserting records into the DE without any problem.
Jun 2, 2023 at 14:24 comment added Eddie Belhay Description: "ExactTarget.OMM.FunctionExecutionException: An error occurred when attempting to execute an UpsertData function call. Error Code: OMM_FUNC_EXEC_ERROR - from OMMCommon --> --- inner exception 1--- ExactTarget.OMM.FunctionExecutionException: UpsertData Function is not valid in content. This function is only allowed in a non batch context. Function: UpsertData(\"EB_TEST_P\",2,\"local_date_time_full\",\"20230603000000\",\"history_product\",\"IDQ60901\",\"name\",\"Brisbane\",\"air_temp\",15.9,\"rel_hum\",91) Error Code: OMM_FUNC_CONTEXT_ERR - from OMMCommon "
Jun 2, 2023 at 14:23 comment added Eddie Belhay Thank you for taking the time to look through this!! I have tried using UpsertData and added the last 3 parameters into 1 array (the first array is supposed to be 'primary keys' but it's now throwing a different error. I am testing the script in CloudPages to see if it will populate then i plan to use the script in an automation so it automatically refreshes.
Jun 2, 2023 at 13:13 history edited Rachid Mamai CC BY-SA 4.0
added 232 characters in body
Jun 2, 2023 at 13:06 history answered Rachid Mamai CC BY-SA 4.0