05 - Web Services (EN)05a - IBM i Web Services miscellanea

Get Euro Exchange Rates from ECB/BCE WebService

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)

Related Posts
Sending Slack messages with NodeJs from IBM i

Premise Slack is software that falls into the category of corporate collaboration tools used to send messages instantly to team Read more

HAVE YOU READ THE MANUAL?

It is the question I always ask my fellow programmers when they ask me something: "Have you read the manual?". Read more

SQL and DB2 for i – FAQ & Howtos – (Part 4 EN)

Here is the fourth part of this "FAQ & Howtos" for SQL and DB2 for i ... the previous 3 Read more

IBM i System Management: FAQ & Howto (Part 4) IT

This is the third part of the IBM i system management FAQ & Howto collection: you can see the other Read more

--- Roberto De Pedrini Faq400.com
About author

Founder of Faq400 Srl, IBM Champion, creator of Faq400.com and blog.faq400.com web sites. RPG developer since I was wearing shorts, strong IBM i supporter, I have always tried to share my knowledge with others through forums, events and courses. Now, with my company Faq400 Srl, I help companies to make the most of this great platform IBM i.

Leave a Reply

%d bloggers like this: