Creating & Consuming Web Services in APEX

Colin Archer Jul 15, 2019 2:36:19 PM

Contents

APEX: Meet the rest of the web

Making an APEX Wizard Clickable

Querying an Oracle Database Using Amazon Alexa

Last December at Tech 18 and then again at this year’s UKOUG Midlands Tech Event, I gave a presentation (including live demos) on how to create and consume Web Services in APEX.

I have been asked on several occasions if I could publish a recording of the presentation, so here it is. The video includes the full presentation and the live demonstrations I gave.

It briefly covers the following areas.

  • The structure of Oracle Web Services and how to access them.
  • Creating Web Services with the ORDS API and protecting with the OAUTH API.
  • The updated APEX RESTful Services Interface and how to use it to create / protect Web Services.
  • Using Postman to test.
  • How to create reports and charts over Web Services using Web Source Modules.
  • How to use REST enabled SQL to run SQL queries on a remote database as the source for reports and charts.

 

 

Author: Colin Archer 

Job Title: Senior Oracle APEX Development Consultant

Bio: Colin is a Senior Development Consultant at DSP-Explorer with 20 years’ experience of analysis, design, and development of bespoke Oracle applications for a wide variety of business functions. Building on his previous experience of Forms and PL/SQL he is now focusing on developing high quality fit for purpose solutions using APEX.

 

 
How to RESTful APEX

APEX: Meet the rest of the web

Making an APEX Wizard Clickable

Querying an Oracle Database Using Amazon Alexa
Previous

Build a Chatbot on Your Lunch Break
Next

Enhancing the APEX Debugger