Re: json_table(httpgetclob, nested array

[Booth Martin <booth@xxxxxxxxxxxx>]

Yes.  I have done several projects with YAJL.  Scott has done amazing 
work at several levels and is a boon to the community, no doubts at all.

For providing a web service, IWS seems to me to be a whole lot easier, 
faster to develop with, and IWS reliably delivers  well formed json.  
Please understand, that is only an opinion.

When consuming json, it looks to me like using sql with httpgetclob 
might be fairly simple and reliable , too.  Here is a basic Hello World 
example:

                 wURL = cURL + 'f2c/' + %trim(S1TEMPIN);
                 exec sql select * into :wTempOut
                          from json_table(SYSTOOLS.HTTPGETCLOB(
                          :wURL,''), '$' columns("tempOut" VARCHAR(10)) );

It doesn't get much easier than that.  Handling .json arrays?  well...  
probably not a good idea to ask me today.


On 11/18/2019 10:38 AM, B Stone wrote:
> Booth,
>
> have you even tried YAJL, or are you just trying to learn something new
> with SQL here?