Rest API calling from a button

Question

I am using Oracle Apex 24. I am trying to call a REST API in JavaScript when a button is clicked. The REST API was called, and the resulting JSON items populated successfully.

However, this is not the approach I want to use.

I have created a process in the Processing Execution Point whose type is INVOKE API, but I am unable to call the process created on the processing Execution Point (not PL/SQL ) when the button is clicked.

Firstly, I tried to create a Process at the Process Tab as shown in the figure below:

Secondly, the figure below shows the condition of the process:

Finally, the dynamic action has a TRUE condition on which the process will be called:

But still it is not firing, any help?

Koen Lostrie · Accepted Answer · 2025-06-27 06:57:54Z

0

To call a rest API in a page process use the process type of type "Execute code". As code you write an pl/sql block. For invoking the rest api, use the function APEX_WEB_SERVICE.MAKE_REST_REQUEST . The response will be in a CLOB that you can then parse using the native sql json_table functions.

answered Jun 27 at 6:57

Koen Lostrie

19.5k2 gold badges16 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

shady · Accepted Answer · 2025-06-28 06:45:44Z

0

The appropriated approach for your situation is Ajax Callback processes. It is the last execution point in the "processes tab". The processes in this point not executed until you call it using its name. After creating the process in this point you should call it using apex.server.process() function of Oracle Apex Javascript api.

answered Jun 28 at 6:45

shady

1341 silver badge12 bronze badges

1 Comment

Koen Lostrie Jun 29 at 10:16

In this case the json is called on the client (and readable with dev tools by the user). It depends on the business case if this is acceptable. If the rest call is done on the server none of the rest communciation is exposed in the client.

Collectives™ on Stack Overflow

Rest API calling from a button

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related