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 <[email protected]>
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 <[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.
>
>
-- 
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.