ACC V8 Sync External content to ACC

[jomyjose]

I've a requirement to sync values from JSON API into ACC. The Json contains key with value pairs. I want to sync this periodically. how do I go about it?

i'm thinking once i've the key value pair in ACC, i can use personlization blocks to pick up the key value pair into email at the time of delivery.

@johnwwilcoxmba 

[Manoj_Kumar_ · Accepted solution]

Hello @jomyjose 

You can do something like this

JSON Response from API

var apiResponse=[{
"key1":"value1"
},{
"key2":"value2"
}]

var parsedContent=JSON.parse(apiResponse);

foreach(var r in parsedContent){

// write in database with xtk.session.Write
}

[jomyjose]

thank you @Manoj_Kumar_ . 

can you give direction code snippet to use the keys in email so it can pull up the respective value in email while sending? 

[Manoj_Kumar_]

Hello @jomyjose 

You won't be able to do this on runtime on personalization block or in delivery content. 

You will have to prepare this in a WF before and then pass on this information to delivery.