UpsertDE not working in cloud page using ssjs

Question

I have this code and I want to store the data of auth API into a data extension. I am able to successfully generate the result of API but not able to store that data in a data extension.

You can see my code below:

<script runat="server">
Platform.Load("Core", "1")
    var str = Variable.GetValue("@JSON");
    var obj = Platform.Function.ParseJSON(str);
    var token = obj.access_token;
    var auth = 'Bearer ' + token;
    var req = new Script.Util.HttpRequest("https://api.socialstudio.radian6.com/v3/users/me");
        req.emptyContentHandling = 0;
        req.retries = 2;
        req.continueOnError = true;
        req.contentType = "application/json"
        req.setHeader("Authorization", auth);
        req.method = "GET";
    var resp = req.send();
    var resultJSON = Platform.Function.ParseJSON(String(resp.content));
    var item = resultJSON.data[0];
    Write(item['id']);
    var row = Platform.Function.UpsertDE("Auth_API", ["id"], [item['id']], ["username"], [item['username']]);
</script>

The UpsertDE function is not working and is showing this error while loading the cloud page: 500 - Internal server error.

I have checked the Attributes and the Data Extension name and they are the same.

Answer 1

The UpsertDE method can be used in sendable contexts, such as email messages.

UpsertData should be used in non-sendable contexts, such as landing pages.

---

UpsertData:

"Updates or inserts information into a data extension as indicated by the array containing the listed column name and value pairs. This method adds the information if the data extension does not contain an applicable value or updates the existing applicable value to the new value. You can include multiple column name and value parts in a single call. You can use this method in non-sendable contexts, such as landing pages. This call returns the number of rows modified."

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

---

UpsertDE:

Updates or inserts information into a data extension as indicated by the array containing the listed column name and value pairs. This method adds the information if the data extension does not contain an applicable value or updates the existing applicable value to the new value. You can include multiple column name and value parts in a single call. You can use this method in sendable contexts, such as email messages. https://developer.salesforce.com/docs/atlas.en-us.noversion.mc-programmatic-content.meta/mc-programmatic-content/ssjs_platformDataExtensionUpsertDE.htm