Re: systools.httpgetclob vs qsys2.http_post

[Jay Vaughn <jeffersonvaughn@xxxxxxxxx>]

Thx Neil but there is no cert involved.  Even with the systools method. 

Jay

> On May 3, 2023, at 5:30 PM, Niels Liisberg <nli@xxxxxxxxxxxxxxxxx> wrote:
>
> Have you set up your certificate? I can’t se the reference in your http
> request
>
> > ons. 3. maj 2023 kl. 21.36 skrev Jay Vaughn <jeffersonvaughn@xxxxxxxxx>:
> >
> > can someone tell me why when I use the qsys2.http_post below (uncomment out
> > the qsys2.http_post and header parm) it will not work... but works fine
> > with systools.httpgetclob?
> >
> >
> >
> > select *
> > from json_table(
> >               -- qsys2.http_post('
> > https://api.mapbox.com/geocoding/v5/mapbox.places/Mobile' concat
> >                systools.httpgetclob('
> > https://api.mapbox.com/geocoding/v5/mapbox.places/Mobile' concat
> >                                '.json?access_token='
> >               concat
> >                                'myKey' concat
> >                                '&limit=1'
> >
> >                               ,cast(null as clob(1k))
> >                     --
> >
> > ,'{"header":"content-type,application/x-www-form-urlencode","sslTolerate":"true"}'
> >                               )
> > ,'$' columns (
> >             Lat    float     path '$.features[0].center[1]'
> >            ,Lon    FLOAT     path '$.features[0].center[0]'
> >            ,PName  CHAR(100) path '$.features[0].place_name'
> >            ) error on error
> >                ) as x;
> > --
> > This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> > To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> > questions.
> -- 
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.