Re: json_table(httpgetclob, nested array

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

What does the JSON look like Booth?  Kinda hard to map without knowing what it looks like.



> On Nov 13, 2019, at 10:37 PM, Booth Martin <booth@xxxxxxxxxxxx> wrote:
>
> I am consuming json data with a numeric field and with a 100-element array. I get the numeric field OK but the array fails.  It looks like I need to use  "nested" but every way I have tried to use it fails.
>
>          exec sql select "SeasOceans" into :wSeas
>            from json_table(systools.httpgetclob(:wURL, ''), '$'
>              columns(
>                  nested '$.Oceans[*]'
>                    columns("SeasOceans" varchar(20) ) ) error on error );
>
>
> I am using an SQLRPGLE program for this and asked about this last week on the RPG list with no response.
>
> -- 
> This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing list
> To post a message email: WEB400@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/web400
> or email: WEB400-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/web400.