I have no idea where to begin with this (have tried many things from this exchange but nothing works - probably because I am messing it up) but basically I have a JSON array being stored in a cell under one field called 'campaign' in our sendable data extension. This is coming via our REST API.
Is it possible then to take this array and parse it and loop it to display the information within to the customer? We basically want to show the customer which markets they signed up for and the budget for each market (the number of markets can change depending on customer)
This is so far the information in the field "campaign"
{
"url": "http://trivago.com/hotelmanager/",
"campaign_markets": [
{
"market_name": "Germany",
"budget": "500"
},
{
"market_name": "Austria",
"budget": "599"
},
{
"market_name": "United Kingdom",
"budget": "500"
}
]
}
We also have the fields SubscriberKey and Emailaddress.