Re: Forbes currency converter

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

-- 

-- .
Bryan

-- 
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: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.