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

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!