Generating and Consuming JSON Data

Code: GCJSON

Description

-

Audience

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

Prerequisites

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

Objectives

-

Topics

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

Price (ex. VAT)

€ 1.640,00 per person

Duration

2 days

Schedule

Please send us a message with the form below

Delivery methods

  • Classroom
  • On-site (at your location)
  • Virtual (instructor online)

Questions?

Write us and we will contact you to discuss your requirements
contact us