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!

APEX 5.1 RESTful services: Creating a GET request with multiple parameters

Richard LeggeFeb 15 2021 — edited Feb 15 2021

Hi All,
APEX 5.1
SE 12.1
Im using RESTful services directly in APEX 5.1, and I'm trying to create a GET request and pass in multiple parameters to an SQL statement i.e
hr/employees?empno=7839&deptno=10
The example GET request in APEX indicates adding the parameter as a suffix to the url i.e.
hr/employees/{id}
then calling it via using
hr/employees/7839
This works fine, but this doesn't allow for naming the parameter, or having more than one parameter. I've research plenty, and tried a bunch of things, but cannot configure it so I can pass in multiple named parameters. Does anyone know how I would set it up to send multiple parameters.
(I realise I could send a colon delimiter parameter and split it up on the server, but this seems somewhat messy..). I've created and tested a working Web Service directly in PL/SQL, but wanted to use APEX to do so..
Thanks
Richard

Comments
Post Details
Added on Feb 15 2021
0 comments
943 views