Re: Forbes currency converter

[Bryan Dietz <bdietz400@xxxxxxxxx>]

have you tried the QSYS2.HTTPxxx functions?



Rob Berendt wrote on 5/28/2026 9:07 AM:
> I'm trying to do the following in Run SQL Scripts
> values systools.httpgetclob('
> https://www.forbes.com/advisor/money-transfer/currency-converter/usd-mxn/?amount=1',
> '');
>
> 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:
> https://www.forbes.com/advisor/money-transfer/currency-converter/usd-mxn/?amount=1";.
> 2026-05-28 10:00:02.714956 30 DIAGNOSTIC
>   Cause . . . . . :   The Java stored procedure or user-defined function
> aborted with a Java exception. If SQJAVA component trace is on, then the
> component trace for the job contains a Java stack traceback for the aborted
> method.
>   Recovery  . . . :   Debug the Java method to eliminate the exception. ROB
> QSYS QSQROUTS QSQCLNUP SQROUTE_CLEANUP 8501 QSYS QSQROUTS QSQCLNUP
> SQROUTE_CLEANUP 8501
>
> https://www.ibm.com/docs/en/i/7.6.0?topic=overview-httpgetblob-httpgetclob-scalar-functions