How to configure Webhook Response Template to return a data table
Options
Jeff_146001
Posts: 296 admin
I'm trying to return a data table as JSON in a Webhook Trigger.
I believe this is close, but there's some bad syntax in the response.
Webhook Response Template:
{ "mystring": "{{mystring}}", "mytable": {{mytable}}, "runID": "" }
JavaScript formula to convert CSV text field to JSON array:
var lines=fields["csvtext"].split("\r\n"); var output = []; var headers=lines[0].split(","); for(var i=1;i<lines.length;i++){ var obj = {}; var currentline=lines[i].split(","); for(var j=0;j<headers.length;j++){ obj[headers[j]] = currentline[j]; } output.push(obj); } result = JSON.stringify(output); //JSON
Current response
The current response is replacing "
with "
in some places that it shouldn't, causing the response to be malformed.
{ "mystring": "Hello World", "mytable": [{"Number":"1"},{"Number":"2"},{"Number":"3"},{"Number":"4"},{"Number":"5"},{"Number":"6"},{"Number":"7"},{"Number":"8"},{"Number":"9"},{"Number":"10"},{"Number":"11"},{"Number":"12"},{"Number":"13"},{"Number":"14"},{"Number":"15"},{"Number":"16"},{"Number":"17"},{"Number":"18"},{"Number":"19"},{"Number":"20"},{"Number":"21"},{"Number":"22"},{"Number":"23"},{"Number":"24"},{"Number":"25"},{"Number":"26"},{"Number":"27"},{"Number":"28"},{"Number":"29"},{"Number":"30"},{"Number":"31"},{"Number":"32"},{"Number":"33"},{"Number":"34"},{"Number":"35"},{"Number":"36"},{"Number":"37"},{"Number":"38"},{"Number":"39"},{"Number":"40"},{"Number":"41"},{"Number":"42"},{"Number":"43"},{"Number":"44"},{"Number":"45"},{"Number":"46"},{"Number":"47"},{"Number":"48"},{"Number":"49"},{"Number":"50"},{"Number":"51"},{"Number":"52"},{"Number":"53"},{"Number":"54"},{"Number":"55"},{"Number":"56"},{"Number":"57"},{"Number":"58"},{"Number":"59"},{"Number":"60"},{"Number":"61"},{"Number":"62"},{"Number":"63"},{"Number":"64"},{"Number":"65"},{"Number":"66"},{"Number":"67"},{"Number":"68"},{"Number":"69"},{"Number":"70"},{"Number":"71"},{"Number":"72"},{"Number":"73"},{"Number":"74"},{"Number":"75"},{"Number":"76"},{"Number":"77"},{"Number":"78"},{"Number":"79"},{"Number":"80"},{"Number":"81"},{"Number":"82"},{"Number":"83"},{"Number":"84"},{"Number":"85"},{"Number":"86"},{"Number":"87"},{"Number":"88"},{"Number":"89"},{"Number":"90"},{"Number":"91"},{"Number":"92"},{"Number":"93"},{"Number":"94"},{"Number":"95"},{"Number":"96"},{"Number":"97"},{"Number":"98"},{"Number":"99"},{"Number":"100"}], "runID": "" }
0
Best Answer
-
@Jeff_146001 have you tried using three handlebars around the table reference like:
{{{my-table}}}
? If I remember correctly, that will prevent replacing special characters like"
.1