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
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?
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.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.