Create RESTful APIs in Oracle APEX with ORDS and Postman | Full Tutorial
In this video, I demonstrate how to create *RESTful API web services in Oracle APEX* using *Oracle REST Data Services (ORDS)**. You’ll learn how to register your APEX workspace with ORDS, create REST modules and aliases, and set up REST templates with **GET**, **PUT**, and **POST* handlers to interact with data in an Oracle Database.
We’ll walk through how to build, debug, and test your REST endpoints using **Postman**, ensuring your APIs are secure, well-structured, and easy to maintain. This step-by-step tutorial is ideal for developers looking to expose Oracle database objects via RESTful web services and integrate APEX applications with external systems or mobile apps.
*What you’ll learn:*
How to enable and configure ORDS in Oracle APEX
Creating and managing REST modules and templates
Writing GET, PUT, and POST handlers for CRUD operations
Testing REST endpoints with Postman
Debugging and troubleshooting API responses
Best practices for secure REST API development in APEX
*Timestamps:*
00:00 – Introduction
03:51 - Registering schema with ORDS for building web services
06:17 - creating a module
08:15 - first webservice - select all for a callection
10:05 - testing our endpoint with Postman
11:28 - getting a single row with an ID as parameter
13:53 - Updating information using a PUT handler
20:21 - debugging and handling errors in PL/SQL web services
25:17 - Returning error messages to the response
27:00 - Using POST to add new rows
32:19 - Creating an endpoint that uses a query to retrieve data
*Keywords / SEO Tags:*
oracle apex, oracle rest data services, ords api, oracle apex rest api, apex rest tutorial, oracle database api, restful api oracle, ords tutorial, oracle apex web services, oracle api development, rest api tutorial, postman oracle apex, oracle ords get post put, build rest api oracle, apex ords configuration, oracle apex data integration, oracle web services, oracle apex beginner tutorial
*#OracleAPEX #ORDS #RESTAPI #Postman #OracleDatabase #APEXDevelopment #APEXTutorial #WebServices #OracleREST #DatabaseIntegration*