Synametrics Technologies

Good day

Attempting to run a query against an Informix Database.

I've been able to do so and output the records to a file using '-o' on the command linebut need to import and process in 'Node Red'.  The file is a traditional line by line record with a header and thus I'm struggling to process.

Are there any options / ways to output the records returned from a query in either JSON format or as a stream to screen in other formats.  Was thinking of using the export template and HTML.  Any ideas / examples from others?

Thanks

Nige