× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I see. And I appreciate you sharing your experience Jon!!

Thx

Jay

On May 4, 2023, at 11:22 AM, Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

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.


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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.