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 !
Solved! Go to Solution.
Views
Replies
Total Likes
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
Now all you have to do iterate your object and do a sqlExec for each item.
Thanks,
Manoj
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
Now all you have to do iterate your object and do a sqlExec for each item.
Thanks,
Manoj
Hello @_Manoj_Kumar_ ,
Thank you so much for your response it's very clear.
i still have one more question because in your response you assume that the list is already created ? there is any why to create the list (table) during the workflow execution i mean using my js code before start persisting the data?
Thanks in advance.
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes
Views
Replies
Total Likes