Support Article
Clipboard to JSON does not handle null values
SA-31384
Summary
When converting clipboard to JSON, instead of "CALCULATED_PITIWithoutSpreadPaymentAmount": null, the scalar null values are coming out like this: "CALCULATED_PITIWithoutSpreadPaymentAmount"
Error Messages
Receiving web service can't parse the JSON since it's invalid.
Steps to Reproduce
Send a JSON request with null scalar values.
Root Cause
A defect or configuration issue in the operating environment: Currently, REST service or connect outbound JSON mapping is faulty for a scalar property (of type other than Text) that exists in Clipboard with null or empty value.
In such case, JSON key is added without it's corresponding value and hence leading to an invalid JSON.
Resolution
Apply HFix-30845.
Description of changes available in the provided hotfix:
Modify REST service or connect outbound JSON mapping to stream into "null" value (without quotes) when a non-string scalar property exists in clipboard with an empty or null value.
Published December 19, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.