Removing Null Values from JSON

[manchis]

Hi,

We have a requirement to remove the null values elements from the json. Below is the example JSON which is having null values at Root and child levels. We need a solution to remove nulls at all levels and if all elements in child are removed then the entire child should get remove.

Could you please provide the pipeline solution for it.

Example:
{
“Root”:{
“Element1”:“1”,
“Element2”:“A”,
“Element3”:null,

“Child1”:{
“Element4”:“1”,
“Element5”:null
}

“Child2”:{
“Element6”:“1”,
“Child3”:{
“Element7”:“1”,
“Element8”:null,
“Child4”:{
“Element9”: null
}
}
}
}
}

Expected Result:

{
“Root”:{
“Element1”:“1”,
“Element2”:“A”

“Child1”:{
“Element4”:“1”
}

“Child2”:{
“Element6”:“1”,
“Child3”:{
“Element7”:“1”
}
}
}
}

[SpiroTaleski]

@manchis

I think that the expression from the below post will help you to achieve the desired output:

Remove emply/null value fields from JSON Designing Pipelines

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. [image] The response is [image] Please find the attached pipeline. Remove_Empty_Null_Values_2020_12_03.slp (4.9 KB)

Regards,
Spiro Taleski

[manchis]

@Spiro_Taleski - Thank you! Yes I checked this article and it worked.