Ah OK.
I would say then look into one of the open source prettifiers we mentioned to generify it unless yajl or other has a pretty option for incoming JSON that will work.
However doesn't data-into give you a data structure that you could iterate output to a PF for display in a subfile or whatever ?
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------
message: 2
date: Wed, 28 Oct 2020 11:36:27 +0000
from: Jack Prucha <Jack.Prucha@xxxxxxx>
subject: RE: iSeries based JSON "Pretty" formatter?
5250. The JSON comes in a CLOB in a DB2 table and processed via Data-into. A utility process that processes any JSON is preferred as there will be more.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Richard Schoen
Sent: Tuesday, October 27, 2020 11:59 PM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: RE: iSeries based JSON "Pretty" formatter?
Out of curiosity why and how are you planning present JSON to an end users ?
Using a 5250 app, web app ?
There appear to be JSON prettifiers for Python and probably Node, PHP, etc.
You could probably download the JSON and run it through one of those processes if you really want your end users to view raw prettified JSON files.
Better yet, pull the JSON into a DB structure if you really want to show it from an app.
Hard to provide much guidance without knowing the full intent.
Regards,
Richard Schoen
Web:
http://www.richardschoen.net
Email: richard@xxxxxxxxxxxxxxxxx
------------------------------
message: 2
date: Tue, 27 Oct 2020 20:09:45 +0000
from: Jack Prucha <Jack.Prucha@xxxxxxx>
subject: iSeries based JSON "Pretty" formatter?
I want to present a JSON payload to the user in an easy-to-read format. Output like JSONFormatter.org. Linking to a web site is a non-starter so I'm searching for something iSeries based.
I have Scott's YAJL software installed and am using it with Data-Into. However, I don't see an example in his thorough documentation to take any JSON and pretty up the formatting for human viewing. There's a CLE pgm in his YAJLLIB72 called JSON_Refmt but I can't figure it out.
Most RPGLE JSON open source I see is designed to create or disassemble JSON - not display it.
Any suggestions?
TIA
Jack
midrange.com
