Welcome back! OK, so now we have both the REST Data Sources and a REST API for currency conversion ready for use as a basis to creating our app pages. There are many components available in Oracle APEX, but we'll primarily use Interactive Reports and Forms.

Starting at the REST Work Diary app homepage, hit the 'Create page' button, and let the adventure unfold. An overlay page opens, where we select an 'Interactive Report' component and click 'Next'.

‍

‍

Let's set it up as seen below:

‍

Under Page Definition:

Name: Clients

Page Mode: leave to Normal

Include Form Page: yes (move the slider to the right)

Form Page Name: Edit Client

Form Page Mode: select Modal Dialog

‍

Under Data Source:

Data Source: REST Data Source

REST Data Source: select REST Client Source from the dropdown

You can leave all the other settings to default for now, and press 'Next' to create a new page.

‍

On the next page we just select the primary key of our table (client_id) and click 'Create Page'.

‍

A newly created page displays our existing clients and their data and includes a form that enables us to edit existing client, delete it or create a new one. Both of which we can edit to suit our needs. To give you and overview, here's a gallery of my app at this stage.

‍

‍

Feeling the APEX vibes? You can replicate the magic for more pages or explore other components.

Stay tuned for the next blog, where I'll unveil the enchantment of integrating the currency conversion API into a view, making your app truly extraordinary. Until then, take care, and feel free to drop any questions or thoughts on the contact page. Happy APEX crafting! 🚀🔮

‍

‍