Hello All,
I have created a REST Data source for accessing a REST service (ORDS AutoREST enabled table).
My scenario is if the table doesn't have data for a specific user, I want to show a Information alert on the page.
The way I am doing it right now is using an Invoke API process which invokes the API defined in the REST Data Source and storing the response of the API to a page item (I have parameters defined on the REST Data Source which I have mapped to a page item in the Invoke API process).
Then I have another PLSQL process which parses this response and pulls out the count from the “items” array in the response and saves to another item which then controls the display of the alert.
This seems to be a very long way of accomplishing something that should be easy.
Is there a way to easily parse the response of a Invoke API process? Or better yet, is there a way to check how many rows were returned when a REST Data Source is invoked as part of the Invoke API process?
APEX already has the data profile defined for a REST Data Source so it should already be able to parse out and figure out the rows returned right?
Any thoughts?