1 Reply Latest reply: Mar 15, 2014 10:12 AM by Denny Wong-Oracle RSS

    RESTful Web Services not working with input parameters

    Denny Wong-Oracle

      I want to create a RESTful Web Services in APEX 4.2, which returns customer info given some conditions.

       

      SELECT NAME, AGE, ADDRESS

      FROM ACCOUNT

      WHERE FUND > :FUNDS AND CHECKING > :CHECKING

       

      I defined the variables this way.  I tried both URI and HTTPHeader Source Type, but nothing work.

       

      NameBind Variable NameAccess MethodSource TypeParameter Type
      CHECKINGCHECKINGINURIDouble
      FUNDSFUNDSINURIDouble

       

      I would like to invoke the Web Services from a custom page in a web browser, something like this:

       

      http://localhost/user/customer?FUNDS=1000&CHECKING=200

       

      I couldn't make passing input parameter values in URI to the Web Services to work (got an error).  Did I do anything wrong here?  Is this supported?

       

      Thanks.