How to create an adobe campaign List using a json array of objects in a workflow

Avatar

Avatar

JamesAlio

Avatar

JamesAlio

JamesAlio

14-01-2021

Hello,

i have a workflow where i create a json array using javascript activity and i want to  create a new adobe campaign list (using js code) and add to it all the data in my json array  using "javascipt acitivity" or "update list" activity.

can you please show me how i can achieve this operation in my workflow. 

 

this is the code of my Js activity :

 

var arrayOfObjects = [{
  "id": 28,
  "Title": "Sweden"
}, {
  "id": 56,
  "Title": "USA"
}, {
  "id": 89,
  "Title": "England"
}];


vars.arrayOfObjects = JSON.stringify(arrayOfObjects); 

 Regards !

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

_Manoj_Kumar

MVP

Avatar

_Manoj_Kumar

MVP

_Manoj_Kumar
MVP

14-01-2021

Hello @JamesAlio 

 

All adobe lists create a table in the DB. You can directly update that table with a SQl statement and execute that SQL statement with sqlExec.

 

You can get the list table name from the schema table as shown in this screenshot

_Manoj_Kumar_0-1610640971639.png

 

 

Now all you have to do iterate your object and do a sqlExec for each item.

 

Thanks,

Manoj

 

Answers (0)