4 Replies Latest reply on Nov 14, 2019 6:39 PM by Olafur T

    ORDS in APEX displays null in an empty JSON field

    JonathanL

      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