Hi Community, i am stuck on this. i have a payload in a form of an array of objects i want to feed that into a template node to get a JSON formatted output i am using the {{#paylaod}} & {{/payload}} inside the template node to iterate through all my array input objects. all works well exce…

[image] hope this makes it bit more readable, it's that last "," highlighted in the picture that is causing me the trouble... just a note in put case, my array is having almost a thousand objects... so simplicities sake, i am showing here only 2 objects,

Thanks for reaching out. attached is an example flow showing the problem. JSON formatting in a Template Node.json (1.5 KB) I appreciate your help :slight_smile:

The template node/mustache can only iterate over the elements, but cannot perform any logic/manipulation (or at least very limited) Try a function node instead: Input: [{"firstName":"one","lastName":"one","email":"one@mail.com"},{"firstName":"two","lastName":"two","email":"two@mail.com"},{"firstN…

First you have more than just a comma issue in your template. Missing quotes and object brackets. I have assumed content is an array due to these errors in template layout. Second when posting flows it is best to use the </> icon and post between triple backticks as this adds a simple copy button ,…

Node-RED

Node-RED Forum

Using Array input to a Template node to generate a JSON formatted message

General

E1cid 6 October 2023 15:28 3

Please supply a example flow with sample input data in an inject node and i will give you an example to omit last comma.

Topic		Replies	Views
Creating comma separated string from JSON data with template node General	6	2140	25 June 2018
Creating JSON with the template node General	9	3899	14 August 2020
Template Node (array integration) General	4	1856	21 August 2019
Mustache Template to create array of objects General	7	262	20 April 2023
Generate JSON format based on payload array General	8	158	17 March 2025

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Using Array input to a Template node to generate a JSON formatted message

Related topics