Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html

Exhibitor Hall Map Here 
Tuesday, May 21 • 5:50pm - 6:10pm
213: Web Services: The Basics of Pulling External 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 developers, using Native IBM i DB2 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> Understand the basic structure of a REST API, and how it differs from SOAP.
2> See how to find a public web service API and understand its inputs and outputs.
3> Learn how to structure and execute an SQL statement to pull data from the web service.

Speakers
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 May 21, 2024 5:50pm - 6:10pm CDT
Room 202 A-B 1508 Houston St, Fort Worth, TX 76102
  Programming - UI
  • Session Level Beginner
  • Audience Developers who could benefit from pulling external information (i.e., commodity prices) into their user applications on IBM i