Re: RPG & webservice

[Pete Helgren <pete@xxxxxxxxxx>]

Booth,

Not sure if you are set on a DB2 file outputting JSON and then writing 
it out....I haven't played with JSON in that way.  But I am using 
CGIDEV2 in a SQLRPGLE program and it simply outputs JSON as part of an 
HTML template where I iterate through the DB records, and use updhtmlvar 
to update each json value in the template and just write it out.  You 
can see it in action here:

http://opensource4i.com/mobile/cgi_adhstm.pgm?action=getList

Again, it is using more RPG plumbing through the use of CGIDEV2 
templates but it works...only needs Apache (HTTP server on i) configured 
to invoke the CGI pgm and a way to get it routed from the Internet (all 
straightforward).  I'll post the code on Github if you are interested....

Pete Helgren
www.petesworkshop.com
GIAC Secure Software Programmer-Java
Twitter - Sys_i_Geek  IBM_i_Geek

On 8/27/2018 3:35 PM, Booth Martin wrote:
> You are correct, Scott.  I am confused. And still am confused.
>
> My goal is to provide a very simple web service.  The example I am 
> learning with is a DB2 file of 10 to 20 records, each with a state and 
> a city field.  A green screen program maintains the file.  The 
> additional, new piece that I am trying to make work is an Intranet web 
> service that offers that data, in a JSON format, to anyone who asks 
> for it.
>
> My presumption was that there would be an SQLRPGLE program, that when 
> asked, would read the DB2 file and provide a .json data stream that a 
> javascript file could GET and process as the web folks chose, for 
> their needs.
>
> This DB2-to-web page task already works if I write a .json file to the 
> IFS and deal with it as an IFS HTTP website.  So, I know the general 
> process works.  The hang-up for me is the web service piece.
>
> I shall read the slide show presentation one more time.
>
> Your initial premise really is correct; I am confused.  By the way, in 
> case I forget, I really appreciate all the stuff you have offered and 
> all that I have learned from you.  Thank you Scott.