I just thought that I will put complete HTML in resource element and somehow I will send the json which is returned by API. vRO should process that HTML give us final output then I can send an email notification with the same output.
As of now, I have resolved this way:
var headers = [];
var jsonAsInput =
[
{
"Book ID": "1",
"Book Name": "Computer Architecture",
"Category": "Computers",
"Price": "125.60"
},
{
"Book ID": "2",
"Book Name": "Asp.Net 4 Blue Book",
"Category": "Programming",
"Price": "56.00"
},
{
"Book ID": "3",
"Book Name": "Popular Science",
"Category": "Science",
"Price": "210.40"
}
]
var data = JSON.parse(jsonAsInput)
for (var key in data[0]) {
headers.push(key);
}
var doctype = "<!DOCTYPE html>"
var style = "<style>#reports { font-family: \"Trebuchet MS\", Arial, Helvetica, sans-serif; border-collapse: collapse; width: 100%;}#reports td, #reports th { border: 1px solid #ddd; padding: 8px;}#reports tr:nth-child(even){background-color: #f2f2f2;}#reports tr:hover {background-color: #ddd;}#reports th { padding-top: 12px; padding-bottom: 12px; text-align: left; background-color: #4CAF50; color: white;}</style>";
var body = "<html><head><title>Report Data</title>" + style + "</head><body><p><br/> Report details:<br/></p>"
var table = "<table id=\"reports\"><tr>"
for each(var header in headers) {
table = table + "<th>" + header + "</th>"
}
for each(var item in data) {
table = table + "</tr><tr>"
for (var td in item) {
table = table + "<td>" + item[td] + "</td>"
}
table = table + "</tr>"
}
var html = doctype + body + table + "</tr></table></body></html><br/><br/><br/>"
System.log("Final Html Str: " + html);
Thank you Ilian Iliev for your support.
