---
title: Creating & Consuming Web Services in APEX
description: 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.
---

[DSP Blog ](https://content.dsp.co.uk)

# [Creating & Consuming Web Services in APEX](https://content.dsp.co.uk/creating-consuming-web-services-in-apex)

 Written by [Colin Archer](https://content.dsp.co.uk/author/colin-archer) | 15-Jul-2019 13:36:19

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](https://www.dsp.co.uk/oracle-apex-services).

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](https://www.dsp.co.uk/oracle-apex-services), and if you liked this blog, check out our other [APEX blogs here](https://content.dsp.co.uk/apex).

[Contact us](https://www.dsp.co.uk/contact-us) today, and one of our expert developers will be in touch.

 

**Author**: [Colin Archer ](https://content.dsp.co.uk/apex/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.

 

 

[View full post](https://content.dsp.co.uk/creating-consuming-web-services-in-apex)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Colin Archer"
  },
  "dateModified" : "2025-09-18T09:08:23.876Z",
  "datePublished" : "2019-07-15T13:36:19Z",
  "headline" : "Creating & Consuming Web Services in APEX",
  "image" : {
    "@type" : "ImageObject",
    "height" : 668,
    "url" : "https://www.dsp.co.uk/hubfs/Stock%20images/Proficient%20young%20male%20employee%20with%20eyeglasses%20and%20checkered%20shirt%2c%20explaining%20a%20business%20analysis%20displayed%20on%20the%20monitor%20of%20a%20desktop%20PC%20to%20his%20female%20colleague%2c%20in%20the%20interior%20of%20a%20modern%20office.jpeg",
    "width" : 1000
  },
  "mainEntityOfPage" : "https://content.dsp.co.uk/creating-consuming-web-services-in-apex",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60.0,
      "url" : "https://content.dsp.co.uk/hubfs/Logos/DSP/DSP-logo-2019-150px.png",
      "width" : 58.44156
    },
    "name" : "DSP Blog"
  }
}
```