Remove emply/null value fields from JSON
Can you help me to remove empty/null value fields from a JSON structure? Kindly suggest pipeline design suggestion or expression language for the below expected results. Thanks!
Input:
{
“INVOI...
Forum Discussion
Hi Rajesh,
Use JSONPath to remove any keys where the values are empty/null as follows: jsonPath($,“$…[?(value == null) || (value == “”)]”)
In a mapper, put this in the expression field and leave the target field blank. Click on Pass Through.
The response is
Please find the attached pipeline.
