OHS, EPG, and APEX Listener Compared - Expert Oracle Application Express - page 69

Figure 1-42. Available Resource Templates
If you now call this URI directly in the browser you will see that behind the scenes the APEX Listener
executes the SQL Query and returns the output to the browser as a JSON (JavaScript Object Notation)
string, as shown in Figure 1-43.
Figure 1-43. Calling the REST URI and getting JSON response back
The JSON output is shown below:
{
"items":
[
{
"greeting":"Hello john from APEX"
}
]
}
Notice how the alias from our query is used.
You can actually choose to return CSV format rather than JSON format, or define that the result will
be generated via block of PL/SQL code or Media Resource rather than a SQL query, as shown in Figure
1-44.