Generating and Consuming JSON Data

This course is designed for programmers that need to generate and consume JSON with SQL

It is assumed that participants have at least a basic knowledge of SQL. Participants should also be familiar with ACS-Run SQL Scripts.

JSON versus XML

JSON Basics

JSON Support in SQL

Generating JSON-Documents

• Generating (nested) Objects
• Generating Arrays
  • Listing Objects and Values
  • Based on a SELECT Statement
• Generating Arrays over multiple Rows

JSON-Predicates

• Check valid JSON Data

Consumging JSON Data with JSON_TABLE

• JSON Path Expression
• Converting JSON Data Types into SQL-Data Types
• Column Defintions
  • Regular Column Definition
  • Column Nested Path Definition
  • Ordinality Column Definition
  • Return JSON formatted Data
• JSON - More complex Examples

Retrieve JSON Data

• JSON_VALUE and JSON_QUERY

Reading and writing JSON Data into the IFS

Consuming JSON-Daten returned by Web-Services