14.2 Reviewing REST API Basics

Review the HTTP, JSON, SQL, and PL/SQL basics behind REST APIs.

Before learning how to expose a REST API for your application, it's good to review the basic "ingredients" involved in the recipe:

• Key HTTP methods that REST APIs use,
• The basic syntax of JSON documents,
• SQL features to construct JSON from relational data, and
• PL/SQL's native JSON types, and
• Simplifications JSON Relational Duality Views enable in Oracle 26ai.

• Reviewing HTTP Methods for REST APIs
  Review how HTTP methods map to REST operations on business entities.
• Inspecting JSON Syntax
  Review JSON objects, arrays, and value types used in REST API payloads.
• Constructing JSON in SQL
  Use JSON_OBJECT and JSON_ARRAYAGG SQL functions to construct JSON from relational data.
• Working with JSON in PL/SQL
  Use PL/SQL JSON types to parse, build, and serialize JSON data.