可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效,请关闭广告屏蔽插件后再试):
问题:
I am working on transforming my payload. I have got the situation here.
Input payload looks like this below one:-
{
"address": {
"city": "bab",
"company_name": "asdast",
"country_code": "sam",
"location": {
"city": null,
"state": null
}
}}
I used %output application/json skipNullOn = "everywhere"
it returns me JSON like below
{
"address": {
"city": "bab",
"company_name": "asdast",
"country_code": "sam",
"location": { }
}}
But I don't want to have empty location object if all fields in location objects are empty.I am expecting something like this
{
"address": {
"city": "bab",
"company_name": "asdast",
"country_code": "sam"
}}
回答1:
This is a recursive solution I arrived at after the direct approach seemed hard to understand:
%dw 1.0
%output application/json
%function acceptable(value) (
(value default {}) != {}
)
%function filterKeyValue(key, value) (
((key): value) when acceptable(value)
)
%function removeFields(o) o
unless o is :object
otherwise o mapObject
(filterKeyValue($$, removeFields($)))
---
removeFields(payload)
Here's the direct approach I started with:
%dw 1.0
%output application/json
%function skipNulls(o) o
unless o is :object
otherwise o mapObject {
(($$): $) when ($ != null)
}
%function skipEmpty(o) o mapObject {
(($$): $) when ($ != {})
}
---
address: skipEmpty(payload.address
mapObject {
($$): skipNulls($)
}
)
Note that we dropped skipNullOn="everywhere"
on the %output
directive, and removed null fields in a function instead. This allows us to make sure the nulls get removed before we check if the containing object is empty.
The function (in both solutions) works because mapObject
allows us to loop over the object fields, and include them in the result object only if they meet a certain condition.
回答2:
This worked for me (N.B. Dataweave is from Mule version 3.8):
%function isEmpty(thing) thing match {
:null -> true,
arr is :array -> arr == [],
obj is :object -> obj == {},
'' -> true,
/\s+/ -> true,
default -> false
}
UPDATE:
So, to inject this in the solution by Ryan above:
%function acceptable(value) (
!isEmpty(value)
)
回答3:
Ryan, the function is producing errors in Studio 6.2.3. I had to include an otherwise condition. I had to surround the (key):value in object constructor curly braces, and I had to include an otherwise condition:
%function filterKeyValue(key, value)
(
//((key): value) when acceptable(value)
{(key) : value} when acceptable(value)
otherwise {}
)
回答4:
Unfortunately, none of the solutions worked for me , so I used a second 'transform message' component with below code and used skipNullOn="everywhere" in both the components. This code recursively searches for empty elements(null fields,empty strings,empty arrays and empty objects) and removes it.
%dw 1.0
%function removeEmptyInArray(arr) arr map (
(removeEmptyInArray($) when $ is :array
otherwise (removeEmptyInObject($) when $ is :object
otherwise $ when ($ != null and (sizeOf $) > 0) otherwise null))
) when arr != []
otherwise null
%function removeEmptyInObject(obj) obj mapObject (
'$$': (removeEmptyInArray($) when $ is :array
otherwise (removeEmptyInObject($) when $ is :object
otherwise $ when ($ != null and (sizeOf $) > 0) otherwise null))
)
%output application/json skipNullOn="everywhere"
---
removeEmptyInObject(payload)
Hope it helps.
回答5:
I have the simplest and the easiest solution.
%dw 1.0
%output application/json skipNullOn = "everywhere"
---
{
"address": {
"city": payload.address.city,
"company_name": payload.address.company_name,
"country_code": payload.address.country_code,
("location": {
"city": payload.address.location.city,
"state": payload.address.location.state
})
}
}
回答6:
There is no straight way to do this, You can do something like this
%dw 1.0
%output application/json
---
address: payload.address - "location" when (sizeOf (payload.address.location pluck $ filter $ != null)) == 0 otherwise payload
Hope this helps.
回答7:
Use this function
%function acceptable(value) (
!isEmpty(value)
)