Re: json_table(httpgetclob, nested array

[Booth Martin <booth@xxxxxxxxxxxx>]

I need to be careful how I answer.  First, I appreciate the responses 
and the discussion; I really do.  I try the various suggestions and 
these lead to other questions;  all in all, a useful and interesting 
side trip.

But I want to come back to the thread's subject line " 
json_table(httpgetclob, nested array".   "_json_table(httpgetclob_ ...) 
is, if  I am reading things right, less than 20 lines of code for even 
complex requests compared with Tim's example of a simple request which 
is about 185 lines.  If  json_table(httpgetclob, nested array does in 
fact work, then teaching average RPG programmers to consume .json data 
becomes a useful goal for the platform.

In other words, IWS and httpgetclob lets us ordinary programmers quickly 
learn to publish and/or consume .json data.

ps: Birgitta has a very nice slideshow on the process.  It may be a bit 
dated by now though?

birgitta <https://docplayer.net/53054226-Consuming-json-data-with-sql.html>

On 11/18/2019 4:49 PM, Jon Paris wrote:
> As I and others have pointed out Booth you need to process the data with a cursor! It is returning a result set - not an array.
>
> Look at the earlier example that was posted - it included all the code you needed - custom and all.