Monday, August 06, 2012

RESTful Services now available on Oracle Application Express 4.2 Early Adopter



Last week, on August 3, 2012, the Oracle APEX Listener 2.0 Early Adopter was made available for download from OTN.  And also this past weekend, the Oracle Application Express 4.2 Early Adopter 2 site was switched from Oracle HTTP Server/mod_plsql to the Oracle APEX Listener 2.0 Early Adopter (thanks goes to Colm from the APEX Listener team, Hilary from the APEX team, and Wei from PDIT for making this happen).

One area of functionality which is now exposed and available for testing on the Oracle Application Express 4.2 Early Adopter 2 site is RESTful Services.  These can now be easily created and tested within the Oracle Application Express RESTful Services module.

A very rich example of a RESTful Service is created within each workspace.  To test this yourself:

  1. Login to your workspace (register for one, if you havent' done so already)
  2. Click "SQL Workshop"
  3. Click RESTful Services
  4. Click oracle.example.hr
  5. Click the "GET" resource handler under the "empinfo/" resource template, in the hierarchy on the left
  6. Scroll down and click the "Test" button

In my JOEL workspace on the Application Express 4.2 Early Adopter 2 site, with the JOEL path prefix for my workspace, this resulted in a URL like:

https://apexea.oracle.com/pls/apex/joel/hr/empinfo/

[Note - after APEX 4.2 is eventually released and the APEX 4.2 Early Adopter site is extinguished, the above URL will no longer function]


4 comments:

Alex Peta said...

Good news with the RESTful services, and I do have a question, Joel, slightly off topic here. Once with EA 2.0, is there any change in the routing system ? Can we see "friendly" URLs, MVC style, for APEX applications?

Joel R. Kallman said...

@Alex,

At this time, no - there are no plans for this out-of-the-box in APEX 4.2.

Joel

Dean Attewell said...

Hi Joel

Keen to see a Restful POST example...

Dean

Joel R. Kallman said...

Hi Dean,

Thanks for the suggestion. I just confirmed that this is forthcoming...hopefully in the next week or two.

Joel