Re: Displaying JSON data on iSeries Apache web server

Turns out that was the answer. Thank you Kevin. User QTMHHTTP had to be given permission to the JSON file. Then all worked as desired, with both Firefox and IE11.

So, as it turns out, providing an organization's casual users with their reports and data needs in modern and attractive ways is surprisingly easy, even for old-timey RPGers like me. I used Eclipse Neon and its editors to write the HTML, CSS, JavaScript files. I used FileZilla to FTP the files to the iSeries. I set up a simple HTTP server using the iSeries IP address plus :2001/HTTPAdmin. I used port 7878 for the new Apache server. Then, with my browser I could reach xx.xxx.xxx.xx:7878 and see the data

Anyone cares to see the code, please view Page Source on ventures.martinvt.com . Building the .json file is pretty straight forward RPG coding. My program is less than 100 lines, although it does have a line "/copy MARTIN/QDEV,IFSIO_H" to include Scott Klement's 1200+ line set of includes that makes dealing with the IFS manageable by programmers like me. Anyone wants to see my RPGLESQL program to see how I did it, just let me know. Happy to share.

There is more to be done of course, but for the moment I am reflecting upon how much easier it was to do than I expected. I made way too much work of it.


On 11/24/2016 6:13 PM, Kevin Turner wrote:

Qtmhttp1 is not authorised