Loading…
POWERUp 2019 has ended
Experience the magic of education. 
Back To Schedule
Wednesday, May 22 • 10:30am - 11:30am
43BP Consuming JSON Documents and Web Services with SQL

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Feedback Survey
JSON becomes more and more important especially in RESTful web services. The use of XML declines in favor of JSON. With the JSON_TABLE table function JSON documents can be parsed, converted into a relational representation and data picked specifically out. Additional scalar functions allow SQL to directly access JSON documents located within the IFS (Integrated File System) or in source physical file members. Last but not least IBM provides SQL functions for getting access to web services. In composition with the JSON_TABLE function the JSON answers returned by web services can be consumed.

Learning Objectives:

Learn how JSON documents located in either the IFS or a column in a table or JSON answers from web services can be parsed with the JSON_TABLE table function, converted into a relational representation and data specifically selected. You’ll also get an overview over the new http-functions and how to use them for getting access to web services.
Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →

Wednesday May 22, 2019 10:30am - 11:30am PDT
Fantasy Tower Magic Kingdom 4
  Database
  • Focused Education Roadmap SQL Programming
  • Level Advanced
  • Operating System IBM i
  • Audience Developers and Users who are experienced in SQL Queries and need to process JSON documents located in either SQL tables or the IFS or JSON answers returned by web services or simply want to enhance their SQL know-how.