0

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.

2

There are quite a lot of answers related to this, that should help you solve what you are trying to do:

But i think the best walkthrough is found on Adam Spriggs github site: https://gist.github.com/wvpv/aa9580f976c85c425761385d088d024f

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.