TUG Buzz! for Monday August 21st, 2023

⌚ Last chance to register! Next MoM is:

Wednesday, August 23rd, 2023
ZOOM ONLY TUG MoM
12:00 PM (noon) Eastern Time

* Note: An MP4 recording of this meeting will be available to download for TUG members in good standing, by email request to admin@tug.ca.

SPEAKERS:

robert.swanson@cnxcorp.com

Robert Swanson Senior Partner for CNX Corporation in Chicago 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. Rob is a strong advocate of introducing highly user-friendly web and mobile applications to conventional RPG shops and boosting the image of IBM i as a truly World Class application server.

ABSTRACT:

Using SQL to pull web service data into your IBM i applications

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 these 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

Back To Top

Future TUG MoM Calendar:

(See the AGENDA page for details on the next scheduled meeting.)

Back To Top