Re: systools.httpgetclob vs qsys2.http_post

I'm just relaying my own experience of working with Watson and switching from using the old tools to the new.

Your mileage may vary.


Jon P.

On May 4, 2023, at 10:45 AM, Jay Vaughn <jeffersonvaughn@xxxxxxxxx> wrote:

but not really... I have done this also with twillio, usps, and other 3rd
parties that use https...
ssltolerate=true is necessary... but certificates are optional. I didn't
have to mess with certs when calling those guys.

so if the systools.httpgetclob works on the https (without certs in play),
then that tells me that the cert is optional.
why doesn't the qsys2.http_post work?

Jay

On Thu, May 4, 2023 at 10:23 AM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

You are using "https://api.mapbox <https://api.mapbox/>..." - note httpS
- there's always certificates involved when you do that.

I seem to recall that when switching from the old Java-based methods to
the new C-based ones we did have to import the certs that were part of the
underlying Java package but not included with the C stuff. Tried to find
the message thread where I got help but can't track it right now.


Jon P.

On May 3, 2023, at 8:40 PM, Jay Vaughn <jeffersonvaughn@xxxxxxxxx>

wrote:

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.

--
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.

--
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.