---
title: Tips for making the most out of APEX's REST Data Sources
description: Maximise your use of Oracle APEX's REST Data Sources with these expert tips on search implementation, data synchronisation, and Fusion API integration.
image: https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%20thumbnail.png
---

[![DSP From Ground to Cloud](https://content.dsp.co.uk/hubfs/Logos/DSP%20From%20Ground%20to%20Cloud/DSP-Logo-Colour-From-Ground-to-Cloud.svg "DSP From Ground to Cloud")](https://dsp.co.uk)

[![DSP From Ground to Cloud](https://content.dsp.co.uk/hs-fs/hubfs/2023/Logos/DSP/DSP-Logo-2019-White-600px.png?width=70&height=72&name=DSP-Logo-2019-White-600px.png "DSP From Ground to Cloud")](https://dsp.co.uk)

- Services 
    - Consulting Services 
          - [Oracle](https://www.dsp.co.uk/oracle-consultancy)
          - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy)
          - [Google](https://www.dsp.co.uk/google-cloud-consultancy)
          - [Architecture](https://www.dsp.co.uk/solution-design-and-architecture)
    - Managed Services 
          - [Oracle Managed Services](https://www.dsp.co.uk/oracle-managed-services)
          - [SQL Server Managed Services](https://www.dsp.co.uk/sql-server-managed-services)
          - [OCI Managed Services](https://www.dsp.co.uk/oracle-cloud-infrastructure-managed-services)
          - [Azure Managed Services](https://www.dsp.co.uk/azure-managed-services)
          - [On Premise Apps Managed Services](https://www.dsp.co.uk/application-managed-services)
          - [Cloud Apps Managed Services](https://www.dsp.co.uk/oracle-cloud-applications-services)
    - Licensing and SAM 
          - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing-services)
          - [Software Asset Management](https://www.dsp.co.uk/oracle-software-asset-management-sam)
    - Application Services 
          - [Application Development](https://www.dsp.co.uk/software-development)
          - [Application Modernisation](https://www.dsp.co.uk/legacy-software-modernisation)
          - [Oracle Forms to Oracle APEX](https://www.dsp.co.uk/oracle-forms-to-oracle-apex)
          - [Application Extensions](https://www.dsp.co.uk/software-customisation)
          - [Archiving Solutions](https://www.dsp.co.uk/application-archiving-solution)
          - [Application Hosting](https://www.dsp.co.uk/oracle-apex-hosting-services)
          - [Development Training](https://www.dsp.co.uk/oracle-apex-training)
    - Data Science 
          - [AI Strategy](https://www.dsp.co.uk/ai-strategy)
          - [Responsible AI and Governance](https://www.dsp.co.uk/responsible-ai)
          - [Agentic AI](https://www.dsp.co.uk/agentic-ai)
          - [Data Management for AI](https://www.dsp.co.uk/data-management)
          - [Power BI](https://www.dsp.co.uk/power-bi-services)
          - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services)
          - [Machine Learning](https://www.dsp.co.uk/oci-machine-learning)
    - Cloud Migration and Management 
          - [Cloud Readiness and Design](https://www.dsp.co.uk/oracle-cloud-readiness-assessment)
          - [Migration to Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-cloud-application-modernisation)
          - [Migration to Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-migration)
          - [Private Cloud](https://www.dsp.co.uk/oracle-private-cloud-services)
          - [Database@ Hyperscaler](https://www.dsp.co.uk/multicloud-management)
          - [FinOps and Optimisation](https://www.dsp.co.uk/optimise-oracle-cloud-infrastructure)
    - Integration and APIs 
          - [API Management](https://www.dsp.co.uk/api-development-services)
          - [GoldenGate](https://www.dsp.co.uk/oracle-goldengate-services)
    - Disaster Recovery and Security 
          - [Disaster Recovery](https://www.dsp.co.uk/oracle-database-disaster-recovery-solutions)
          - [Security Compliance](https://www.dsp.co.uk/data-security)
          - [Cloud Security](https://www.dsp.co.uk/cloud-security)
  
  
  
   
  
  ![Oracle Partner, Microsoft Partner and Google Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/multiple-vendor/rectangle-2022/Partner-logos-rectangle-Nov21.svg)
  
  
  
  
  
  
  
  #### Getting to know us
  
    - [About us](https://www.dsp.co.uk/about)
    - [What we do](https://www.dsp.co.uk/what-we-do)
    - [Leadership](https://www.dsp.co.uk/dsp-product-leads)
    - [Careers](https://www.dsp.co.uk/careers)
- Technologies 
    - Oracle Cloud Infrastructure 
          - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-infrastructure-services)
          - [IaaS](https://www.dsp.co.uk/iaas)
          - [PaaS](https://www.dsp.co.uk/paas-security)
    - Oracle Database 
          - [Oracle Database](https://www.dsp.co.uk/oracle-database-consulting)
          - [Autonomous Database](https://www.dsp.co.uk/oracle-autonomous-database-services)
          - [MySQL and Heatwave](https://www.dsp.co.uk/mysql-services)
          - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services)
    - Oracle Engineered Systems 
          - [Oracle Exadata](https://www.dsp.co.uk/exadata-database-service-consultancy)
          - [Oracle Database Appliance](https://www.dsp.co.uk/oracle-database-appliance)
    - Oracle Applications 
          - [Oracle Fusion and Cloud Applications](https://www.dsp.co.uk/oracle-fusion-services)
          - [Oracle E-Business Suite](https://www.dsp.co.uk/oracle-ebs-services)
          - [JD Edwards](https://www.dsp.co.uk/jd-edwards-services)
          - [Peoplesoft](https://www.dsp.co.uk/oracle-peoplesoft-services)
          - [Hyperion](https://www.dsp.co.uk/oracle-hyperion-services)
    - Microsoft 
          - [SQL Server](https://www.dsp.co.uk/sql-server-consultancy)
          - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services)
          - [Power BI](https://www.dsp.co.uk/power-bi-services)
          - [Microsoft Fabric](https://www.dsp.co.uk/microsoft-fabric-services)
    - Google 
          - [Google Cloud Platform (GCP)](https://www.dsp.co.uk/google-cloud-partner)
    - Multicloud and Database Hyperscaler 
          - [Oracle Database@Azure](https://www.dsp.co.uk/oracle-databaseazure-partner)
          - [Oracle Database@GCP](https://www.dsp.co.uk/google-cloud-machine-learning)
          - [Oracle Database@AWS](https://www.dsp.co.uk/amazon-web-services-aws)
          - [Oracle Azure Interconnect](https://www.dsp.co.uk/oracle-microsoft-multicloud)
    - Open Source Database 
          - [PostgreSQL](https://www.dsp.co.uk/postgresql-services)
          - [MySQL](https://www.dsp.co.uk/mysql-services)
          - [MariaDB](https://www.dsp.co.uk/migration-from-mariadb-to-mysql)
  
  
  
  #### Managed Services
  
    - [Oracle Database](https://www.dsp.co.uk/oracle-managed-services)
    - [SQL Server](https://www.dsp.co.uk/sql-server-managed-services)
    - [MySQL](https://www.dsp.co.uk/mysql-support)
  
  
  
  
  
  
  #### Application Services
  
    - [Oracle Applications](https://www.dsp.co.uk/oracle-application-cloud-migration)
    - [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services)
    - [Microsoft](https://www.dsp.co.uk/microsoft-partnership)
    - [ISV Services](https://www.dsp.co.uk/isv-support-and-services)
  
  
  
  
  
  
  
  
  #### Cloud Services
  
    - [Oracle Cloud Infrastructure](https://www.dsp.co.uk/oracle-cloud-services)
    - [Microsoft Azure](https://www.dsp.co.uk/microsoft-azure-services)
    - [Google Cloud Platform](https://www.dsp.co.uk/gcp-database)
    - [Multi-cloud](https://www.dsp.co.uk/oracle-microsoft-multicloud)
  
  
  
  
  
  
  #### Data Science
  
    - [Machine Learning](https://www.dsp.co.uk/machine-learning-consulting-services)
    - [Business Intelligence](https://www.dsp.co.uk/business-intelligence-services)
    - [Artificial Intelligence](https://www.dsp.co.uk/artificial-intelligence-consulting-services)
  
  
  
  
  
  
  
  
  #### Consulting Services
  
    - [Oracle](https://www.dsp.co.uk/oracle-consultancy)
    - [Microsoft](https://www.dsp.co.uk/sql-server-consultancy)
    - [Google](https://www.dsp.co.uk/google-cloud-consultancy)
    - [Cloud Migration](https://www.dsp.co.uk/cloud-migrations)
  
  
  
  
  
  
  #### Technology Solutions
  
    - [Engineered Systems](https://www.dsp.co.uk/oracle-engineered-systems-partner)
    - [Data Security](https://www.dsp.co.uk/data-security)
    - [Database Architecture](https://www.dsp.co.uk/solution-design-and-architecture)
    - [Disaster Recovery](https://www.dsp.co.uk/database-disaster-recovery)
- Industries 
    - [Finance](https://www.dsp.co.uk/finance)
    - [Healthcare](https://www.dsp.co.uk/healthcare-it-services)
    - [Travel and Transport](https://www.dsp.co.uk/database-solutions-for-travel-and-transport)
    - [Higher Education](https://www.dsp.co.uk/higher-education)
    - [Public Sector](https://www.dsp.co.uk/public-sector)
    - [Manufacturing](https://www.dsp.co.uk/manufacturing)
    - [Retail](https://www.dsp.co.uk/retail)
    - [Software Vendors](https://www.dsp.co.uk/isv-support-and-services)
  
  
  
  ### Recent case study:
  
  #### Oracle EBS Cloud Deployment
  
  Consolidating and Migrating assets into Oracle Cloud Infrastructure.
  
  [**![Oracle EBS Cloud Deployment](https://content.dsp.co.uk/hs-fs/hubfs/stonewater-logo%20(1).png?width=250&name=stonewater-logo%20(1).png)**](https://www.dsp.co.uk/stonewater)
  
   
  
  
  
  
  
  
  
  #### Most Visited Pages
  
    - [Oracle Licensing](https://www.dsp.co.uk/oracle-licensing)
    - [Oracle Cloud Calculator](https://www.oracle-cloud-calculator.com/)
    - [Oracle Cloud Migration](https://www.dsp.co.uk/oracle-cloud-migration)
    - [Oracle Exadata Services](https://www.dsp.co.uk/oracle-exadata-services)
    - [Artificial Intelligence Services](https://www.dsp.co.uk/artificial-intelligence-consulting-services)
  
  
  
  
  
  
  
  
  #### -
  
    - [SQL Server Support](https://www.dsp.co.uk/sql-server-support)
    - [Oracle Support](https://www.dsp.co.uk/oracle-support)
    - [Google Cloud Consultancy](https://www.dsp.co.uk/google-cloud-consultancy)
    - [New Application Development](https://www.dsp.co.uk/oracle-apex-services)
    - [Azure Virtual Desktop](https://www.dsp.co.uk/azure-virtual-desktop)
- Resources 
    - [Gartner ](https://www.dsp.co.uk/complimentary-gartner-download)
    - [ISG](https://www.dsp.co.uk/isg-oracle-report)
    - [Blogs](https://www.dsp.co.uk/blogs)
    - [Case Studies](https://www.dsp.co.uk/case-studies)
    - [Testimonials](https://www.dsp.co.uk/testimonials)
    - [Events](https://www.dsp.co.uk/events)
    - [Webinars](https://www.dsp.co.uk/webinars)
    - [Insights](https://www.dsp.co.uk/insights)
    - [Technical Resources](https://www.dsp.co.uk/technical-resources)
  
  
  
  ### DSP-Explorer acquires leading Oracle Applications Managed Services Provider, Claremont, to further extend its data management capabilities.
  
   
  
  [![Read More](https://no-cache.hubspot.com/cta/default/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305.png)](https://cta-redirect.hubspot.com/cta/redirect/3321273/c7e13c9c-65e1-46e7-8541-8da86a4fc305)
  
  
  
  
  
  
  
  #### Resources
  
    - [Blogs](https://www.dsp.co.uk/blogs)
    - [Webinars](https://www.dsp.co.uk/webinars)
    - [Case Studies](https://www.dsp.co.uk/case-studies)
    - [Testimonials](https://www.dsp.co.uk/testimonials)
- About 
    - [About DSP](https://www.dsp.co.uk/about)
    - [What We Do](https://www.dsp.co.uk/what-we-do)
    - [DSP Group Board ](https://www.dsp.co.uk/dsp-group-board)
    - [Careers](https://www.dsp.co.uk/careers)
    - [Project Harar](https://www.dsp.co.uk/project-harar)
- [Customer Area](https://www.dsp.co.uk/contact-us) 
    - [Customer Support Portal](https://dspgroup-ism.ivanticloud.com/)
    - [Customer Resources](https://www.dsp.co.uk/welcome)
- [Contact us](https://www.dsp.co.uk/contact-us)

# Tips for making the most out of APEX's REST Data Sources

[ Joe Marley ](https://content.dsp.co.uk/author/joe-marley) 12-Mar-2026 13:54:10

Tips for making the most out of APEX's REST Data Sources

5:17

### Contents

[04-Jun-2026 11:58:58

Oracle APEX Interactive Grid Validations

](https://content.dsp.co.uk/oracle-apex-interactive-grid-validations) [27-Mar-2025 11:10:02

Oracle APEX Support for Hierarchical REST Source Data Profiles

](https://content.dsp.co.uk/oracle-apex-support-for-hierarchical-rest-source-data-profiles) [31-Jul-2025 09:41:30

Quick SQL - Enhancements and Generative AI Modelling

](https://content.dsp.co.uk/quick-sql-enhancements-and-generative-ai-modelling)

The REST Data Source functionality in [Oracle APEX](https://www.dsp.co.uk/oracle-apex-services) has evolved significantly over the past few years and has become a great tool to allow for an easy way for developers to work with external data sources with minimal effort and little (if any) custom code. In this blog, I will go through some of the tips that will help you get the most out of REST Data Sources with APEX.

 

## Implementing Search for LOVs, Interactive Reports, and Interactive Grids Using REST Data Sources

If you are using a REST Data Source in a:

- List of Values (LOV)
- Interactive Report
- Interactive Grid

and your REST API supports query string parameters, for example:

`?query={query-term}`

Although this can be used for any query parameter, such as name if applicable, you can easily integrate it into your region/item. This can be done using the 'Use for Row Search' switch in the query parameters settings. It is worth noting that only one parameter can be set in this manner.

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources.png?width=1507&height=644&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources.png)

Once enabled:

- For LOVs: The parameter will be marked as *Use for Search*, and APEX will automatically pass the search term.

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%202.png?width=1525&height=127&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%202.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%202.png)

- For Interactive Reports and Grids: The parameter is automatically attached to the region, and when querying using the built-in search functionality, this will be added to the URL path, i.e. "prepared Query String: query=TEST&".

Also, if you're trying to find where REST Data sources like the above are used in your app, you can find information under the ‘Utilization tab’, which uses the wwv_flow_restds_usage_dev APEX view.

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%203.png?width=647&height=83&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%203.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%203.png)

 

## Columns missing from your discovery profile

When creating a new REST data source, there have been times I have configured things correctly on initial setup, but the data that is showing incorrectly is due to the format of the JSON payload, as APEX can default to using the first array as the row selector, in this case, vendor.

For example, this JSON

```
{
```

 

Row selector defaulted to vendor, which produced 3 columns:

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%204.png?width=436&height=219&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%204.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%204.png)

 

To resolve this, update the row selector to "." which should hopefully resolve this issue and select the correct number of columns.

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%205.png?width=438&height=495&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%205.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%205.png)

## Manual Data Synchronization

The APEX_REST_SOURCE_SYNC package allows for manually triggering a synchronization with the associated table of a REST data source. The interactive report page below can be easily set up using this package.

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%206.png?width=1881&height=232&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%206.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%206.png)

To get the last synchronisation time, we can use the code below to populate a data item:

```
SELECT
```

 

To synchronise the data manually using the Sync Data button, we can use the code below:

```
BEGIN
```

There is also the option to call the code from outside of your app and run the synchronisation process in the background with different procedure parameters.

 

## Data Profile - Custom Columns

As part of your synchronisation setup, you may want to have the data put into the table with modifications to the data before inserting. To do this, APEX provides the ability to create additional columns.

The first allows your REST source to access your own lookup tables and assign data based on matching IDs, for example.

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%207.png?width=1424&height=440&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%207.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%207.png)

The second, derived columns, allow you to have more control over what data you want for this new column, including the use of functions to generate custom data based on the REST data:

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%208.png?width=866&height=530&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%208.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%208.png)  
[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%209.png?width=712&height=75&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%209.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%209.png)

Having the columns here also helps if there are multiple references to this REST endpoint without the need for a view or custom code for each time the REST endpoint is referenced. If you are also making a lot of changes to your REST data sources here, another tip is to check this setting on the right-hand side of your screen:

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%2010.png?width=204&height=298&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%2010.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%2010.png)

## Fusion REST APIs

Further functionality for your current Fusion apps can be added very easily by creating a custom APEX application on the same database your Fusion is hosted on. This integration can be easily enabled using APEX's REST data sources communications with Fusion REST APIs, and as of APEX 24.2, adding this functionality has been made simpler with a new template app, which will set up a remote server, a web credential, an authentication scheme and a REST data source.

[![Tips for making the most out of APEXs REST Data Sources](https://content.dsp.co.uk/hs-fs/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%2011.png?width=918&height=535&name=Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%2011.png)](https://content.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%2011.png)

Because of Fusion's wealth of API endpoints and APEX's option to add in Oracle Cloud Applications (SaaS) REST Service data sources, the data can be easily ingested and used for custom reporting and data processing through your own custom app. With this integration, you can also make use of the business logic and querying on your Fusion instance, as well as easily update your data profile and reporting when needed on your APEX companion app with no code needed.

 

## Conclusion

As integration between systems becomes increasingly important, APEX continues to provide a secure, low-code solution for working with external data sources. Another way to greatly add to the functionality of your apps using external sources is to add generative AI, which can now be configured as easily within your APEX instance. My colleague goes into great detail on this in his blog [here](https://content.dsp.co.uk/integrating-oci-generative-ai-within-your-oracle-apex-reporting), and with APEX's REST data sources toolkit, you could also look at using your own custom AI integration. If you’re already working with REST in APEX, hopefully these tips help you refine and optimise your implementation even further.

For more information, check out our **[Oracle APEX Services](https://www.dsp.co.uk/oracle-apex-services)**, or **[contact us](https://www.dsp.co.uk/contact-us)** today, and one of our expert developers will be in touch.

[APEX](https://content.dsp.co.uk/topic/apex) [Oracle APEX](https://content.dsp.co.uk/topic/oracle-apex) [REST](https://content.dsp.co.uk/topic/rest) [Fusion](https://content.dsp.co.uk/topic/fusion)

[04-Jun-2026 11:58:58

Oracle APEX Interactive Grid Validations

](https://content.dsp.co.uk/oracle-apex-interactive-grid-validations) [27-Mar-2025 11:10:02

Oracle APEX Support for Hierarchical REST Source Data Profiles

](https://content.dsp.co.uk/oracle-apex-support-for-hierarchical-rest-source-data-profiles) [31-Jul-2025 09:41:30

Quick SQL - Enhancements and Generative AI Modelling

](https://content.dsp.co.uk/quick-sql-enhancements-and-generative-ai-modelling)

[Previous

Update to Oracle APEX, ORDS and Forms Support End Dates

](https://content.dsp.co.uk/update-to-oracle-apex-ords-and-forms-support-end-dates)

[Next

Modernising Enterprise Data: Moving Beyond SSIS to Microsoft Fabric

](https://content.dsp.co.uk/modernising-enterprise-data-moving-beyond-ssis-to-microsoft-fabric)

#### Contact

Sales Enquiries  
[+44 (0) 203 880 1686](tel:+4420%2038801686)

Technical Support  
+44 (0) 330 058 8367

[enquiries@dsp.co.uk](mailto:enquiries@dsp.co.uk)

#### Follow us

<https://www.linkedin.com/company/dsp-explorer> <https://twitter.com/dspexplorer> <https://www.facebook.com/DSPcloud>

#### Office Locations

[**London (Head Office)**](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,198m/data=!3m2!1e3!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MTAwOC4wIKXMDSoASAFQAw%3D%3D)  
[Chancery House](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D)  
[53-64 Chancery Lane](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D)  
[London](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D)  
[WC2A 1QS](https://www.google.com/maps/place/Fora+-+Chancery+House/@51.5174484,-0.1139686,19z/data=!3m1!5s0x48761adea956397d:0xb7585122cbe86fc0!4m6!3m5!1s0x48761b4b75bf77fb:0x97c4f0ad56af6d23!8m2!3d51.5174586!4d-0.1129066!16s%2Fg%2F11h_cy7xk5?entry=ttu&g_ep=EgoyMDI1MDkyOS4wIKXMDSoASAFQAw%3D%3D)

[**Leeds**  
Richmond House,  
Lawnswood Business Park,  
Leeds,  
LS16 6QY](https://www.google.com/maps/dir/53.8405223,-1.6062773/DSP-Explorer/@53.8404788,-1.6061783,17z/data=!4m9!4m8!1m1!4e1!1m5!1m1!1s0x4879591e5d204ac9:0x4e41b926d72adca!2m2!1d-1.6064847!2d53.8404842)

[**Derby**](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
[Cubo Pride Park,](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
[1 Pride Place](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
[Derby](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
[DE24 8QR](https://www.google.com/maps/place/Cubo+Pride+Park/@52.9142877,-1.4558952,331m/data=!3m2!1e3!5s0x4879f10728c1eea1:0x877f85530d38bf6!4m15!1m8!3m7!1s0x4879f1072b0e2ebb:0x7c717035ff049b12!2sPride+Pl,+Derby+DE24+8QR!3b1!8m2!3d52.913692!4d-1.4543743!16s%2Fg%2F1th7mf0r!3m5!1s0x4879f16809382b33:0x6fccc05b8500d970!8m2!3d52.914146!4d-1.4544105!16s%2Fg%2F11w4j8v8z2?entry=ttu&g_ep=EgoyMDI1MDYyMi4wIKXMDSoASAFQAw%3D%3D)  
**  
[Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)**  
[Inniscarra,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)  
[Main Street,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)  
[Rathcoole,](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)  
[Dublin](https://www.google.com/maps/search/Inniscarra,+Main+Street,+Rathcoole,+Dublin/@53.2810032,-6.4764674,17z/data=!3m1!4b1?entry=ttu)<https://www.google.com/maps/place/70+Gracechurch+St,+Langbourn,+London+EC3V+0XL/@51.512117,-0.0869173,17z/data=!3m1!4b1!4m5!3m4!1s0x4876035256ab55cb:0x1f93b337c0190cf0!8m2!3d51.512117!4d-0.0847286><https://www.google.com/maps/place/Devonshire+House/@51.2797714,-1.0679275,15z/data=!4m5!3m4!1s0x0:0x4f204507edd15263!8m2!3d51.2797718!4d-1.0679748>

#### About Us

DSP is a Data Management and Cloud Platform MSP that delivers enterprise grade support & consulting services for Oracle, Microsoft and Multi-Cloud technologies.

![Oracle Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/Oracle-logos/Colour/o-prtnr-cmyk-250.png)

![Microsoft Partner](https://content.dsp.co.uk/hubfs/Microsoft%20partner%20logos%20-%20July%202023/mic-sol-part-colour@200x.png)

![Google Cloud Partner](https://content.dsp.co.uk/hubfs/logo-2021/Partner-logos/GCP-Logos/Google-Cloud-Partner%20(1).svg)

Registered Office: 30 City Road, London, EC1Y 2AB.  
Company Registration Number: 03898451

<https://content.dsp.co.uk/tips-for-making-the-most-out-of-apexs-rest-data-sources#>

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "dateModified" : "2024-10-01",
  "datePublished" : "2024-10-01",
  "headline" : "Tips for making the most out of APEX's REST Data Sources",
  "image" : [ "https://www.dsp.co.uk/hubfs/Tips%20for%20making%20the%20most%20out%20of%20APEXs%20REST%20Data%20Sources%20thumbnail.png" ],
  "mainEntityOfPage" : {
    "@id" : "https://content.dsp.co.uk/tips-for-making-the-most-out-of-apexs-rest-data-sources",
    "@type" : "WebPage"
  }
}
```