Parsing JSON in email using SSJS and Ampscript

Question

This is my JSON request :

{
  "definitionKey": "SSJSTEST19",
  "recipient":
  {
   "contactKey": "007",
    "to": "sourabxxxxx",
    "attributes": {
     "EmailAddress": "sourabxxxxx",
    "SubscriberKey": "Sourab",
    "CUSTOMERNR": "123678",
    "FirstName": "Sourab",
    "Packages": [
         { "Name" : "Entertainment",
           "Price" : "15 €",
           "PaymentDate" : "01.07.2020"
},
{ "Name" : "Cinema",
           "Price" : "15 €",
           "PaymentDate" : "01.07.2020"
}
]     
      }

  }
}

Here is my Code :

<table cellpadding="0" cellspacing="0" width="100%">

  <tr>
   <td align="center">
    <table cellpadding="0" cellspacing="0" class="container" width="550">

      <tr>
       <td align="left" style="font-family: Helvetica,Arial,sans-serif; font-size: 16px; color: #4a4a4a; padding:px; line-height:24px; background:#F9F9F9;">
%%[
var @MyArray,@Array,@AllPackages,@email,@contactkey ,@First_Name,@CustomerNumber 
set @email= emailaddr 
set @contactkey = AttributeValue("Contact_Key") 
set @CustomerNumber = AttributeValue("CUSTOMERNR") 
set @First_Name = AttributeValue("FirstName") 
set @AllPackages = AttributeValue("Packages") 
]%%

<div style="text-align: right;">Kundennummer: %%=V(@CustomerNumber)=%%</div>
<br>
<b>Hallo %%=V(@First_Name)=%%</b>,<br>
<script runat="server">
Platform.Load("Core","1");
 var arr = [];
 var jsonString1 = Variable.GetValue("@AllPackages");
 arr.push(Platform.Function.ParseJSON(jsonString1).message.views[0].content);
 Write(Stringify(arr));
 Variable.SetValue("@Array",arr);
</script> 

%%[
SET @MyArray = @Array 
]%%
<br>
%%=v(@MyArray)=%%
<br>

       </td></tr></table></td></tr></table>

Result - After triggering the email, the array yields [null] result.

Answer 1

The below should work for your needs to output the stringified packages:

<script runat=server>
Platform.Load("Core","1");

 //set your attributes to variables
 var email = Attribute.GetValue('emailaddr');
 var contactkey = Attribute.GetValue('Contact_Key');
 var customerNumber = Attribute.GetValue('CUSTOMERNR');
 var first_Name = Attribute.GetValue('FirstName');
 var allPackages = Platform.Function.ParseJSON(Attribute.GetValue("Packages")).recipient.attributes.Packages;
 var packagesStr = Stringify(allPackages);

</script>

<table cellpadding="0" cellspacing="0" width="100%">

  <tr>
   <td align="center">
    <table cellpadding="0" cellspacing="0" class="container" width="550">

      <tr>
       <td align="left" style="font-family: Helvetica,Arial,sans-serif; font-size: 16px; color: #4a4a4a; padding:px; line-height:24px; background:#F9F9F9;">
            <br>
            <ctrl:var name=packagesStr />
            <br>
       </td>
      </tr>
     </table>
    </td>
   </tr>
</table>

Which outputs:

[{"Name":"Entertainment","Price":"15 €","PaymentDate":"01.07.2020"}, {"Name":"Cinema","Price":"15 €","PaymentDate":"01.07.2020"}]

You can then iterate through the JSON as you would normally:

var Name = allPackages[0].Name        //outputs Entertainment
var Price = allPackages[0].Price      //outputs 15 €
var obj2_Name = allPackages[1].Name   //outputs Cinema
var obj2_Price = allPackages[1].Price //outputs 15 €

When outputting SSJS variables inline, you need to use the ctrl tag. Like so:

<ctrl:var name=Name />   //outputs like AMPscript %%=v(@Name)=%%
<ctrl:var name=Price />  //outputs like AMPscript %%=v(@Price)=%%

When I ran the above, it ran in less than a second, so I do not foresee processing being an issue.