Building REST APIs using SQL Developer & ORDS

Building REST APIs using SQL Developer & ORDS. For all scripts details please refer below blogs.
****Enabling REST Services ****
Enabling Rest Services Schema: 3:25
Enabling Rest Services Schema - Objects (Database Tables): 4:48
Testing Rest Services : 5:35
****Building & Testing REST APIs using SQL Developer ****
Creating Rest Data Services - New Development Connection: 8:17
Building Rest API - GET Method - 10:54
Building Rest API - GET Method - Input Parameter as HTTP Header - 14:12
Building Rest API - GET Method - Multiple Input Parameter - 16:20
Building Rest API - POST Method - Multiple Input/Output Parameter - 20:27
Building Rest API - DEL Method - Input/Output Parameter - 23:43
*******************************

Oracle Apex 20.1 & ORDS Installation

[manivasagamkarunakaran]

This helps greatly! can you please also put the video on how to create the ORDS in SQL developer itself and do the remaining REST services?

[PankajKumar-sudq]

Great Video. Can you also cover the cases where we have to develop Rest services which will fetch details from multiple tables, like SQL Joins.

[srikanthgaddam]

PUT method is not there in video you can use below query that is PLSQL block
BEGIN
UPDATE table
SET STATUS = :STATUS WHERE
emp_id = :emp_id;
END;

[boobalakrishnan]

API can genrate with any custom query/ views ?

[SaisreeRam]

I am unable to connect to the sample schema even after creating it successfully.

Can anyone suggest me how to do it.

[mithileshinamdar]

How can i remove "items" tag from the header

[Anonymousvlogger]

Hi sir, I want to hit the API URL through table specific trigger.
Basically that trigger will be of type "after insert".
So whenever user inserts data into that particular table, trigger should get enabled and should hit that api URL.

Create trigger Mytrigger
After
Insert
On
Test_table
For each row
Declare
Body_url varchar2(100) := 'row inserted';

Begin

// Need to know what to write here to hit above mentioned URL with that body and without expecting any response

End;