Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Passing parameter value conditionally — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Passing parameter value conditionally

Question
6
Views
0
Comments
edited Apr 16, 2022 7:22AM in Autonomous Database

Summary

Passing parameter value conditionally in ORDS REST

Content

Hi,

I have a simple requirement where in I want to pass a variable value in query parameter to ORDS REST.

ex.

{"Po_number":"1000010","CHANGE_ORDER_NUMBER": $****}

Query parameter works fine if there is a value in $**** but if the value is blank i.e.

{"Po_number":"1000010","CHANGE_ORDER_NUMBER": ""}

REST response is blank, I have to remove change_order_number element itself to get a response

Is there a way to get around ? i.e. pass value when there is a value and pass blank if there isn't .

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!