I am trying to expose a report in my application as a RESTful web service. I am following this guide here: http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/advnc_web_services.htm#CHDDBGAI
The instructions are:
On the Workspace home page, click Application Builder.
Select an application.
Application Builder appears.
Select the page that contains the report you want to enable.
The Page Definition appears.
Under Regions, click the name of the region that contains the report you want to enable.
Under Attributes, enter a value for Static ID field. This value is used to access the report RESTfully. From the Enable RESTful Access List, select Yes.
Click Apply Changes.
I am not sure where I can get this "Enable RESTful Access List", it is not in my region attributes or in my page attributes. Could someone kindly point out where I can get it?
I am using APEX 4.2
In the section of the documentation that you have referred to, specifically the section "Enabling RESTful Access to a Report Region" under the parent section "Implementing Web Services" in Chapter 17 of the Application Express User's Guide, you'll see the following note: Note: The Enable RESTful Access List option only displays if RESTful access to this Oracle Application Express instance has been enabled, see "Enabling RESTful Access" in the Oracle Application Express Administration Guide.
Can you please confirm whether you've enabled RESTful access for your instance? If not, you'll need to do so before attempting to update your report settings. I hope this helps.
Thanks Hilary, Got it working now.
I am quite new to web services, the URL you can access after completing those steps like: http://apex.oracle.com/apex/apex_rest.getServiceDescription?app=691
Is this the XML WSDL document which describes all available web services (exposed)? Thanks.
That's great you're up and running now. So now you've managed to expose your Report region as a RESTful Service. I think you might find it useful to read through the section Understanding Web Service References in the same chapter - http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/advnc_web_services.htm#BABDCIBH - as it explains the various references that can be created. In your case, your Web Service reference is based on the RESTful style, and not on a Web Services Description Language (WSDL) document. If you read through the section Accessing a RESTful Enabled Report Region from a Web Service Client - http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21674/advnc_web_services.htm#CHDEHFJI - the apex_rest service API can be used to discover available RESTful enabled reports for a given application. Its response is an XML document with a description of all reports that can be accessed by RESTful Web services.
I hope this helps.