Hi,
I'm calling a service from plsql (oracle 19c) with APEX_WEB_SERVICE.make_rest_request
I generate the payload with a somehow complex select json_object query
Some fields are null, this is normal, so I can get in the payload something like this:
"plan": null,
Now the publisher says they cannot deal with this null string literals, and I should either remove the objects or send empty string.
How can I do this? Should I create a function to parse the clob and remove each and every null object? Or there is something already outofthebox?
Thanks