Avatar

Correct answer by
Community Advisor

Hello @marcinkacz ,

 

Instead of writing a SQL code and then use the output in javascript code, The right approach would be to use queryDef javascript function in javascript code activity and pull the data.

 

Here are the links for some documentations on how to use the queryDef function in javascript:

https://docs.adobe.com/content/help/en/campaign-classic/using/configuring-campaign-classic/api/data-...

https://blog.floriancourgey.com/2018/08/use-querydef-the-database-toolkit-in-adobe-campaign

 

Thanks,

View solution in original post