How can I count the number of objects in my JSON

Question

In the Marketing Cloud I have an attribute field. In this field a JSON is stored. Like so:

[{
    "Example1": "XXXXX",
    "Example2": "XXXXXX",
    "Example3": "XXXXX"
}, {
    "Example1": "XXXXX",
    "Example2": "XXXXXX",
    "Example3": "XXXXX"
}]

How can I count the number of objects so I can put that information in my email? So based on the example above you will get something like this in the email:

You have 2 orders.

Answer 1

This is actually super simple, if you use SSJS and the ParseJSON function. The function returns a JS object, and you can easily check it's length property using .length as illustrated below:

%%[
VAR @jsonattribute
SET @jsonattribute = '[{"Example1": "XXXXX",    "Example2": "XXXXXX",    "Example3": "XXXXX"}, {    "Example1": "XXXXX",    "Example2": "XXXXXX",    "Example3": "XXXXX"}]'
]%%
<script runat="server" language="javascript">
Platform.Load("Core","1");
var jsonresponse = Variable.GetValue("@jsonattribute");;
var json = Platform.Function.ParseJSON(jsonresponse);
Write("You have purchased " + json.length + " products.");
</script>

Output: You have purchased 2 products.