Re: Forbes currency converter

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 <[email protected]>
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 <
> [email protected]> 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] [email protected]<mailto:[email protected]>
> >
> > [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 <[email protected]> on behalf of
> Rob
> > Berendt <[email protected]>
> > Sent: Thursday, May 28, 2026 08:07
> > To: Midrange Systems Technical Discussion <[email protected]
> >
> > 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: [email protected]
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> > or email: [email protected]
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/midrange-l.
> >
> > Please contact [email protected] for any subscription related
> > questions.
> >
> >
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact [email protected] for any subscription related
> questions.
>
>
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact [email protected] for any subscription related questions.