The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.
Back To Schedule
Tuesday, April 25 • 4:00pm - 5:00pm
222: Using SQL to pull web service data into your IBM i applications

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Obtaining information from external systems or data servers has come a long way since the introduction of EDI in the 1980s! Today, publicly available web service APIs offer a much more flexible and easier-to-integrate method for pulling pertinent global data into your IBM i applications. Whether it be commodity prices, financial data, current weather information, demographic statistics or whatever else you can think of, there is no shortage of information available on the internet that could complement certain areas of your company's business, thus adding valuable real-time information to your various user applications.  

In this session we'll put this concept to work in a hands-on fashion. The presenter will use real-world API examples to demonstrate how IBM i developers, using SQL, can quickly access this valuable web service repositories and pull data into an RPG program or UI tool for their users. Attendees will see two simple 5250-based interactive examples in action, with source code they can try on their own systems.

Learning Objectives:
1. Basic definition of a REST API, and how it differs from SOAP
2. How to find a public web service API and understand its inputs and outputs
3. How to structure and execute an SQL statement to pull data from the web service

avatar for Robert Swanson

Robert Swanson

Senior Partner, CNX Corporation
Rob has worked as an in-the-trenches IBM i developer since 1992, with the past 15 years focused on developing modernization efforts for legacy systems written in RPG. Currently serving as Senior Partner for CNX Corporation in Chicago, Rob is a strong advocate of introducing highly... Read More →

Tuesday April 25, 2023 4:00pm - 5:00pm MDT
Governors Square 10
  Programming - General
  • Session Level Beginner
  • Audience Developers who could benefit from pulling external information (i.e., commodity prices) into their user applications on IBM i