We keep our AOP report queries (returning JSON formatted data to feed to AOP’s api package) in ORDS RESTful Services. This method is fairly simple and keeps changes to individual reports isolated, without the need to compile a package. Each query is stored in a separate Resource Handler, and setting these up are a breeze and you can accomplish this one of two ways. Stay tuned for my blog about how to accomplish this using the Oracle APEX UI, but today I will show how this is accomplished using SQL developer. After setting up the data source(s), these JSON formatted data are accessible via a URI in your Web browser. The URI is in the following format: Example URI: https:// : /ords/gems/grants/org_pr_grant/grant_pk:{grant_pk} What the parts mean: gems /grants/org_pr_grant/grant_pk:{grant_pk} gems - workspace name gems/ grants /org_pr_grant/grant_pk:{grant_pk} grants - URI prefix gems/grants/ org_pr_grant /grant_...