Calling a Page Process when button pressed without Submit Action

Question

i am using Oracle apex24.2

i have created a RestApi and linked it to a Rest Data source. i was able to define this rest data source on my screen using a page process.

i want to call this process when a button is pressed but the options on this button is limited.there is only submit page and defined by dynamic action and a couple of others options irrelevant to my application i suppose.

Process Definition in Page it is displayed in the processing tab Process shown in Processing tab

this is the behavior of the button names APIBtn Button Behavior i have a server side condition in the process created as shown below : Process server side

but this behavior is submitting my page. i want the button to call the process created without submitting the page. can someone help please?

Answer 1

You may consider using a "Execute Javascript code" in your dynamic action with type "Click - Button" and then do a Ajax callback.

https://apex.oracle.com/pls/apex/germancommunities/apexcommunity/tipp/3341/index-en.html

Answer 2

A page process can only be executed after a page is submitted. There is no other way of invoking it. Here is a small overview:

There are 3 ways of processing data after the page has been rendered:

• Page process. This is invoked after the page is submitted. It cannot be invoked any other way. This is the "normal" way of processing data on a page in the traditional APEX page lifecycle (pre-rendering processes before page is rendered, after-submit processes after the page has been processed).
• Dynamic actions, action of type "Process Server-sided code".
• AJAX Callback. This is a process that is declared in the page or application and that can be invoked from the client using apex.server.process.

Pick the one that is most appropriate for your use case. You could go with dynamic actions or an AJAX callback it seems. But none of those options will execute a page process, you'll have to write the code yourself to mimic that behaviour.

If you want to make optimal use of the available declarative features in the page processes then consider submitting the page (even if that is not the optimal flow)