Re: json_table(httpgetclob, nested array

[Peter Dow <petercdow@xxxxxxxxx>]

Hi Booth,

How about using httpgetclob to get the data into a variable, then pass 
that variable to the SQL statement?

At least then you can see the results of the httpgetclob separately to 
make sure it's getting what you expect it to get.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /

On 11/18/2019 1:46 PM, Booth Martin wrote:
> That may be, Jon.  Yes, the examples everyone provided work as 
> provided.  The issue is that I am not trying to read from a file; this 
> is a datastream.
>
> And yes, httgetclob does get the data but that is only half the task.  
> json_table(httpgetclob...) has to also deliver the data in RPG-usable 
> form.  Otherwise it isn't useful.  It does work just fine for 
> non-array json.
>
> It is the json array that is the issue. Any documentation I find is 
> pretty clear that I need to use both lax and nested. SQLRPGLE appears 
> to me to understand lax but not understand nested.
>
> As to using a loop... there is nothing I see to loop through.
>
>
> On 11/18/2019 2:35 PM, Jon Paris wrote:
> > Because while you are using it for the task you have set yourself it 
> > is irrelevant to the question at hand.
> >
> > httpgetclob was completely unrelated to the issues you had -