ORDS, SODA & JSON in the Database

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!

ORDS in APEX displays null in an empty JSON field

JonathanLJul 29 2019 — edited Nov 14 2019

Hello

I have a question following a switch from APEX web services to ORDS, built within APEX v19.01.

The previous behaviour in APEX web services for a simple GET query returning JSON was for an item with a null value to be omitted from the returned JSON object.

However after the upgrade the same web service construct returns all fields and if the column value from the SQL is null then the word "null" is placed in the JSON field.

Is there a way to change this ?

I could obviously rebuild all the services using PL/SQL and JSON_OBJECT with the parameter ABSENT ON NULL, but prefer not to.

Any suggestions please ?

Thanks - Jonathan

Added on Jul 29 2019

4 comments

1,577 views