Some of my clients every day or every week load Exchange Rates into ERP’s exchange tables: with a few lines of code we can get rates from ECB (BCE) through their Web API directly from our IBM i – RPG and SQL, take a look at this few lines of code in my Github GIST repository:
https://gist.github.com/Faq400Git/72431bdeb7998b081cce3b29cb0fe89a
As you can see in the source code we are using SYSTOOLS.HTTPGETBLOB to invoke ECB web server and XMLTABLE to parse the XML returned … it’s simple … what do you think about it?
Pay attention: this web service is an SSL HTTPS web service. There are some pre-requisites for your system … like a *SYSTEM certificate in your DCM repository (https://www.ibm.com/support/pages/how-create-system-store-dcm)
--- Roberto De Pedrini Faq400.comWith a little trick even a simple SELECT statement can execute any system command! Let's see how to do that...
A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer
A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer
A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer
A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer
A mini-serial guide to configuring, managing, using, and troubleshooting the IBM i NetServer