I'm usingOracle APEX Release 24.2.0 and Oracle ORDS Release 25.1 on Oracle Database Express Edition 21.1.
I tried to generate a RESTFul API for a couple of tables : tcustomer, tcity and tsalesperson, the code was generated but when tried to access them, I got 404 errors and I also could not understand the http verbs created for the endpoints.
I followed the below steps :
1o) Open SQL Workshopand acess Utilities ==> Method on tables
2o) Put package name : PKG_Customer
3o) Select the three tables to crete the package : customer, city, salesperson
4o) Created the package PKG_Customer
5o) Go to SQL Workshop ==> RESTFul Services == Create AutoREST objects
It generated the endpoints on Full URL : http://localhost:8080/ords/wsgcash/RESTpkg_customer/
6o) Open SQL Developer Web to check the REST Objects ==> REST ==> AutoREST
7o) Check the PKG_Customer API code PKG_Customer ==> View OpenAPI
8o) I don't understand why it generates the urls /GET_TCITY/1 and /GET_TCITY/2 as POST method, which requires the body :
{
"p_cit_id": 0
}
9o) When I run Try it button, passing an existing tcity_id value, I got the following error :
see the cURL code calling a POST ! Shouldn't it be a Get verb for a Get procedure?
10o) I tired also call the URL in Postman as GET and as POST with the same parameters on Try it now, same error occured : 404 Not Found
Did I miss some step in generating this REST API based on a package OR is there any additional configuration to be made on APEX in order to get the right urls for the endpoints and verbs?
Thanks for your support!