How to use REST API on IBM i: the Open Banking example

The IBM i system, being a robust and versatile business server, can easily connect to the world of REST APIs, enriching the applications it hosts with features taken from the cloud. In today’s example we will see how to read bank current account data, which the PDS2 European regulation has made usable also by third parties, management software included. To do this we will use the following tools. SQL functions HttpPostClob And HttpGetCLob , which allow you to make HTTP POST and GET calls using normal SQL statements. (Roberto De Pedrini spoke about it here ). The SQL function Json_Table which converts a JSON document into a DB2 for i table. …