Re: Forbes currency converter

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

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.