since ‎26-02-2020
‎12-03-2020
kattyice
Level 1
Re: How to access external database data from script acti...
Avatar

Farah-Mohammed

Employee

Farah-Mohammed
- Adobe Campaign Classic
Hi @kattyice ,Can you try using SQL code like the below in JS of the WebApp?sqlExecOnDataSource (query, dataSource [, value1, ... ])The authorized values for the data source can be:"" or "default" points to the Neolane database"nms:extAccount:InternalName" points to a datasource defined in the Neolane external accounts (FDA)"name" (name of the datasource) points to a data source defined in the instance configuration file (config-instance.xml) in the following form:· · · · Example:sqlExecOnDataS...

Views

1.5K

Likes

0

Replies

0
Re: How to use Joins in queries in js files
Avatar

kattyice

kattyice
- Adobe Campaign Classic
Thanks jonasn, thats a great help

Views

4.1K

Likes

0

Replies

0
Re: Importing javascript into personalization block
Avatar

kattyice

kattyice
- Adobe Campaign Classic
Hmm, so do you mean the Xpath of a js file in the schema? (Since the js files are stored in a table). Lets assume we have a js file which is called "test" in the xtk:javascript table, what the Xpath would be and be called from eval(js.data) ?

Views

2.8K

Likes

0

Replies

0
Likes given to