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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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 [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.