7 Replies Latest reply on May 24, 2017 12:47 PM by Franco Soldera

Are query string parameters working in ORDS?

3055110 May 19, 2017 10:00 AM

My team is just learning to use ORDS and we want to use it to create RESTFul APIs. So far, the tests are succesful, but one crucial question is:

e.g. Would the following query work and if yes, can you please provide us with an example for implementing it?

http:/xxxxxxxx:8080/ords/xxxxx/yyy/demo/{visible}?cat=4

The following query has been set up:

select * from xxxx where visible= NVL(:visible,visible) and tttt=nvl(:cat,rrrrr)

value 1 is working fine as a parameter in the URI like this: http:/xxxxxxxx:8080/ords/xxxxx/yyy/demo/1

But if I add ?cat=1 after the parameter, I get 500 error, as it assumes that the value of the parameter is now "1 ?cat=1"...

Error during evaluation of resource template: GET api/demo/{visible}, SQL Error Code: 1,722, SQL Error Message: ORA-01722: invalid number

Can you please help?

Thanks

1. Re: Are query string parameters working in ORDS?

Franco Soldera May 22, 2017 8:27 AM (in response to 3055110)

tttt is a number, so you need to cast your parameter: NVL(TO_NUMBER(:cat), rrrrr).
Like Show 0 Likes(0)

Actions
2. Re: Are query string parameters working in ORDS?

3055110 May 23, 2017 11:45 AM (in response to Franco Soldera)

Hi Franco, thanks for answering, but it did not work. My question is if ORDS recognises query string variables like ?cat=3 because for now it seems that whatever is after 1 in this URL http:/xxxxxxxx:8080/ords/xxxxx/yyy/demo/1 , is considered part of the value of the variable.
What I would like is ORDS to understand that 1 is a value of visible and 3 is the value of cat. Anybody made ORDS work with query strings?

Thanks
Alexandra
Like Show 0 Likes(0)

Actions
3. Re: Are query string parameters working in ORDS?

Franco Soldera May 23, 2017 12:59 PM (in response to 3055110)

Something like this?

https://apex.oracle.com/pls/apex/frasit1/hr/test_parameters/10/?employee_id=7839 (10 is the department ID)
Like Show 0 Likes(0)

Actions
4. Re: Are query string parameters working in ORDS?

3055110 May 23, 2017 1:42 PM (in response to Franco Soldera)

Yes Franco, exactly. Is this working with ORDS? If yes, what am I missing?
Like Show 0 Likes(0)

Actions
5. Re: Are query string parameters working in ORDS?

Franco Soldera May 23, 2017 1:50 PM (in response to 3055110)

3055110 This is my setup:

Let me know if it works for you.
Like Show 1 Likes(1)

Actions
6. Re: Are query string parameters working in ORDS?

3055110 May 23, 2017 2:17 PM (in response to Franco Soldera)

Franco you are super. It works as expected! Many thanks!!!
Like Show 1 Likes(1)

Actions
7. Re: Are query string parameters working in ORDS?

Franco Soldera May 24, 2017 12:47 PM (in response to 3055110)

You're welcome :-)

Actually in my example is missing the TO_NUMBER(:DEPT_ID) and TO_NUMBER(:EMP_ID), is always better to cast explicitly to the right type ;-)
Like Show 0 Likes(0)

Actions

Go to original post