Creating & Consuming Web Services in APEX

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

Contents

What is the Oracle Forms Standalone Launcher?

How Do I Access My Free Oracle Cloud Database

Making an APEX Wizard Clickable

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.

 

For more information, check out our Oracle APEX Services, and if you liked this blog, check out our other APEX blogs here.

Contact us today, and one of our expert developers will be in touch.

 

Author: Colin Archer 

Job Title: Senior Oracle APEX Development Consultant

Bio: Colin is a Senior Development Consultant at DSP 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

What is the Oracle Forms Standalone Launcher?

How Do I Access My Free Oracle Cloud Database

Making an APEX Wizard Clickable
Previous

Build a Chatbot on Your Lunch Break
Next

Enhancing the APEX Debugger