Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Consuming RESTful web service in Apex app

patfmndDec 6 2012 — edited Dec 13 2012
Hi,
I have created a RESTful Web service through an Apex application (4.0) and published as a public web service. Can someone point me to an example of how to then consume that service in another Apex app? The output is straightforward XML that I can retrieve just by pointing the browser to the URL of the service created, but when I go to create the REST Web Reference for the receiving application, I am not sure what to put for the Response Xpath or Response Namespace. The service is meant to just return report records that were created in the REStful Web service with no input required.

The service XML looks like this:
<ROWSET>
<ROW>
<PROJ_ID>132</PROJ_ID>
<PSL_NETID>xxxxxxxx</PSL_NETID>
<PROJECT_TITLE>11g- Oracle Upgrade to RAC 11g</PROJECT_TITLE>
<CUSTOMER>OIT</CUSTOMER>
<DIVISION>EIS</DIVISION>
.
.
.
</ROW>
<ROW>
<PROJ_ID>132</PROJ_ID>
<PSL_NETID>xxxxxx</PSL_NETID>
<PROJECT_TITLE>11g- Oracle Upgrade to RAC 11g</PROJECT_TITLE>
<CUSTOMER>OIT</CUSTOMER>
<DIVISION>CSS</DIVISION>

Any help would be appreciated.

Thanks,
Pat

Edited by: patfmnd on Dec 7, 2012 3:04 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 10 2013
Added on Dec 6 2012
5 comments
2,451 views