# How to format JSON output in table to send in the body of the email
**URL:** https://discourse.nodered.org/t/how-to-format-json-output-in-table-to-send-in-the-body-of-the-email/96661
**Category:** General
**Created:** [20 April 2025 21:27 UTC](https://discourse.nodered.org/t/how-to-format-json-output-in-table-to-send-in-the-body-of-the-email/96661 "2025-04-20T21:27:00Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@VaraVerde-hub](https://discourse.nodered.org/u/VaraVerde-hub)
#### Post date: [20 April 2025 21:27 UTC](https://discourse.nodered.org/t/how-to-format-json-output-in-table-to-send-in-the-body-of-the-email/96661/1 "2025-04-20T21:27:00Z")
Hi guys.
I need help to form a JSON output, I need to format it in a table for the body of the email that will be sent. Can anyone help me with any tips?
Thank you for your attention.
this is my test flow:
How is the body of the email:
---
### Author:  [@UnborN](https://discourse.nodered.org/u/UnborN)
#### Post date: [20 April 2025 22:44 UTC](https://discourse.nodered.org/t/how-to-format-json-output-in-table-to-send-in-the-body-of-the-email/96661/2 "2025-04-20T22:44:11Z")
You can use a template node and use mustache syntax to generate the html
or javascript in a Function node to loop through the data array with the same result.
Here is small example flow with JS
```auto
[{"id":"0d20057e4d5ebf5d","type":"inject","z":"54efb553244c241f","name":"data","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"sales_month\":\"1992-01-01T00:00:00.000Z\",\"naics_code\":\"441\",\"kind_of_business\":\"Motor vehicle and parts dealers\",\"reason_for_null\":\"\",\"sales\":29811},{\"sales_month\":\"1992-01-01T00:00:00.000Z\",\"naics_code\":\"4411\",\"kind_of_business\":\"Automobile dealers\",\"reason_for_null\":\"\",\"sales\":25800}]","payloadType":"json","x":250,"y":3820,"wires":[["209cb742129d44fb"]]},{"id":"209cb742129d44fb","type":"function","z":"54efb553244c241f","name":"table","func":"// \"sales_month\": \"1992-01-01T00:00:00.000Z\",\n// \"naics_code\": \"4411\",\n// \"kind_of_business\": \"Automobile dealers\",\n// \"reason_for_null\": \"\",\n// \"sales\": 25800\n\nlet tableHtml = `\n \n | Sales Month | \n Naics Code | \n Kind of business | \n Reason for null | \n Sales | \n
\n ` \nmsg.payload.forEach(el => {\n tableHtml += `\n | ${el.sales_month} | \n ${el.naics_code} | \n ${el.kind_of_business} | \n ${el.reason_for_null} | \n ${el.sales} | \n
`\n })\n\ntableHtml += `
`\n\nmsg.payload = tableHtml\n\nreturn msg;","outputs":1,"timeout":0,"noerr":0,"initialize":"","finalize":"","libs":[],"x":410,"y":3820,"wires":[["608246100beee2a2"]]},{"id":"608246100beee2a2","type":"debug","z":"54efb553244c241f","name":"debug 23","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":610,"y":3820,"wires":[]}]
```
You will need some styling and alignment to make it more presentable.
---
### Author:  [@VaraVerde-hub](https://discourse.nodered.org/u/VaraVerde-hub)
#### Post date: [20 April 2025 23:04 UTC](https://discourse.nodered.org/t/how-to-format-json-output-in-table-to-send-in-the-body-of-the-email/96661/3 "2025-04-20T23:04:57Z")
Thanks so much for the example, it was super helpful! 👏
---
### Author:  [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)
#### Post date: [21 April 2025 01:16 UTC](https://discourse.nodered.org/t/how-to-format-json-output-in-table-to-send-in-the-body-of-the-email/96661/4 "2025-04-21T01:16:30Z")
You could also use uibuilde's uib-element and uib-html to generate an html table from source data.
---
### Author:  [@system](https://discourse.nodered.org/u/system)
#### Post date: [5 May 2025 01:17 UTC](https://discourse.nodered.org/t/how-to-format-json-output-in-table-to-send-in-the-body-of-the-email/96661/5 "2025-05-05T01:17:00Z")
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.