Re: Forbes currency converter

Thanks for the suggestion for exchange-rate. Implemented. All is well.

On Thu, May 28, 2026 at 12:02 PM Charles Wilt <charles.wilt@xxxxxxxxx>
wrote:

I suspect there's a check to see if the request is being made by an actual
browser vs trying to use it as an API endpoint.

Not sure why you'd want to use the Forbes one in any event, you're going to
get a bunch of HTML back that may not even have the data...assuming some of
the javascript on the site it making calls to actually get the results and
updating the DOM.

Have you looked at https://www.exchangerate-api.com/ for instance?

Charles

On Thu, May 28, 2026 at 8:36 AM Rob Berendt <robertowenberendt@xxxxxxxxx>
wrote:

Jack,
I tried to make it match the example better by changing it to
select systools.httpgetclob(
URL *=>* *CAST*('

https://www.forbes.com/advisor/money-transfer/currency-converter/usd-mxn/?amount=

' *CONCAT*
SYSTOOLS.URLENCODE('1', '')
AS *VARCHAR*(*255*)),
HTTPHEADER *=>* *CAST*(NULL AS *CLOB*(*1*K)))
from sysibm.sysdummy1;

I'm getting the same error

On Thu, May 28, 2026 at 10:13 AM Jack Woehr via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

403 is Not Authorized ... you may be shaping your auth token wrong ...

do

you have to change character sets? base64 encode it? Etc.


Jack Woehr
Independent Consulting Programmer

[icon] 303-847-8442<tel:303-847-8442>

[icon] jack.woehr@xxxxxxxxxxx<mailto:jack.woehr@xxxxxxxxxxx>

[icon] www.procern.com<https://www.procern.com>

[icon] Stay Connected!<
https://www.linkedin.com/company/procern-technology-solutions/>

[photo]
Upgrade your IT state of mind!<
https://procern.com/24-7-monitoring-itil-management/>

NON-DISCLOSURE NOTICE: This communication including any and all
attachments is for the intended recipient(s) only and may contain
confidential and privileged information. If you are not the intended
recipient of this communication, any disclosure, copying further
distribution or use of this communication is prohibited. If you

received

this communication in error, please contact the sender and

delete/destroy

all copies of this communication immediately.


[__tpx__]

________________________________
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> on behalf of

Rob

Berendt <robertowenberendt@xxxxxxxxx>
Sent: Thursday, May 28, 2026 08:07
To: Midrange Systems Technical Discussion <

midrange-l@xxxxxxxxxxxxxxxxxx

Subject: Forbes currency converter

I am getting
SQL4302 Java stored procedure or user-defined function
SYSTOOLS.HTTPGETCLOB, specific name HTTPG00005 aborted with an

exception

"java.io.IOException:Server returned HTTP response code: 403 for URL:
--
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.