Using SQL Code activity

Avatar

Avatar

marcinkacz

Avatar

marcinkacz

marcinkacz

17-07-2020

Hi,
How I can use the output of SQL Code activity in a following JS activity?

 

sqlCodeActivityWkf.PNG

I'm typing below code in SQL activity:
SELECT max(iId) FROM CusTestDataSchema

 

What should I type in JS to receive SQL's output? vars.output doesn't work here.

 

Thanks,

Marcin

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

_Manoj_Kumar

MVP

Avatar

_Manoj_Kumar

MVP

_Manoj_Kumar
MVP

21-07-2020

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,

Answers (1)

Answers (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

21-07-2020

Hi,

 

Use queryDef where possible, otherwise use a js activity with sqlGet* or the DBEngine class.

 

E.g.:

var cnx = application.getConnection();
try {
  var res = cnx.query('select sysdate from dual');
  for each (var row in res) logInfo(row[0]);
}
finally {
  cnx.dispose();
}

 

Thanks,

-Jon