I am trying to generate a report link in a Message, from a JSON that contains an array . The JSON is generated by a REST API from a Service node. The JSON is of the form:
“body”: {
“results”:[
{
“columns”: [ “A”,“B”],
“data”: [
{
“row”: [“X”,"Y],
My questions are:
-
How do I specify the array elements for each column? Do I need to write a loop for each column and unroll the data? I tried to display only 1 row but it didn’t work.
-
How to I specify the link in the Message Bot response? No clear instruction is available anywhere in the documents.
Any help is appreciated.
Thanks