Elastic Mapping with a simple Script Snap
An Elastic Mapper which outputs JSON that only contains keys that have non-null values
Background: The use case came while trying to map fields from a Salesforce Outbound Message. This message woul...
Forum Discussion
Is there a way to get tims method to work on the entire reference?
We start with:
, {
“value”: {
“AddressType”: {
“value”: null
},
“AddressLine1”: {
“value”: null
},
“City”: {
“value”: null
},
“StateProvince”: {
“value”: null
},
“Zip”: {
“value”: null
},
“Country”: {
“value”: null
}
}
And want nothing to appear.
Tim’s method gives us:
, {
“value”: {
“AddressType”: {},
“AddressLine1”: {},
“City”: {},
“StateProvince”: {},
“Zip”: {},
“Country”: {}
}
If you wanted to delete objects where the ‘value’ field is null, you can use this path:
$..[?(value instanceof Object && value.value == null)]The .. part of the path means that the entire hierarchy should be traversed. The [?(...)] portion is a filter that is applied to each object in the hierarchy. If the result of the expression in the filter is true, the object will be deleted, otherwise it is left alone. In this case, we check to see if the object we’re visiting (referenced with the value variable) is an object and if it’s value field is null.
If you wanted to delete fields with empty objects instead, you can tweak the expression to call the isEmpty() method, like so:
$..[?(value instanceof Object && value.isEmpty())]
