Using Salesforce Marketing Cloud I am trying to retrieve a list of records using SSJS like this:
<script runat=server>
Platform.Load("Core","1");
var dataRows = Platform.Function.LookupRows('Companies','name','Acme Ltd');
if(dataRows && dataRows.length > 0) {
for(var i=0; i<dataRows.length; i++) {
Platform.Response.Write(dataRows[i]["city"]);
}
}
</script>
I would like to use the returned dataRows
in my client side javascript so I can manipulate and print the data out as required.
However even doing something as simple as console.log(dataRows)
returns a 500 internal server error.
Can someone advise?
There is no direct solution but you can try a workaround. Wherein, you store the variable in ampscript using "Variable.SetValue("",);" And then get this value in js using Variable.GetValue("");