Dears, I'm appending a Json records sequence in a text file using the 'File Node', and the last line is a newline character. After, I read this file with 'File In Node' and 'Json Node' to convert in Json. It works, but always return the error message 'Unexpected end of JSON input in Json Node' when…

Thank you very much Unborn, It works. I follows your recommenadtion, and added the 'node-red-contrib-filter' to my pallet. Then, before the Json Node, I filter the content file to records != (string with no filling). Best Regards, Roberto

I think that if you feed it through a function node containing this (which trims white space characters off the ends of the string) then it should be ok. Newlines count as white space characters. Feed it into the JSON node after the function node. msg.payload = msg.payload.trim() return msg

I wouldn't expect the json node to trip over white-space. as far as I know, white-space is valid in json.

Is the file-in node set to read a single utf8 string or a msg per line? Since each line of the file contains a JSON string, it would seem to me you should send each one separately thru the JSON node.

Hi Colin, I did your recommendation, but doesn't work. The error was returned again. Thanks

[image] zenofmud: it would seem to me you should send each one separately thru the JSON node i agree .. msg per line .. and maybe a function node .. after the File in node that filters any \n or \r or "" empty lines before sending it to the Json node. @bobfield Would it possible to post the…

Hi zenofmud, The node is set do read a msg per line. Thanks

add this in a function node just before the json node. if(msg.payload.trim()===""){ return; } return msg; Or return the complete file trim it and then split it with split node.

... or some additional checks if(msg.payload == "\n" || msg.payload == "\r" || msg.payload == "" ){ return null; } else { return msg; }

you didnt have to install a node for that i meant the code in the Function node would act as a "filter" :wink:

Node-RED

Node-RED Forum

Unexpected end of JSON input in Json Node

General

bobfield 11 January 2021 12:55 8

Hi UnborN, I tried to send the file, but received a message said me that new users can't to do upload files. Sorry,.

Topic		Replies	Views
Unexpected end of json input General	1	455	1 June 2021
Newbee question extending JSON File Bestpractice? General	4	212	23 March 2023
JSON on exec nodes General	3	529	11 August 2021
Read File node returns one line too many? General	14	345	10 October 2022
Help trimming garbage from end of buffer General	2	903	24 February 2020

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.

Unexpected end of JSON input in Json Node

Related topics