DataWeave! DataWeave! DataWeave! It's fun to do dataweaving....
How to create a lookup function in DataWeave?
%var gendertable = { "Male": "M", "Female": "F", "Unknown": "U"}
- - -
...
genderCode: gendertable[payload.inputGender]
...
How to display a data with a valid xml descriptor?
Input:
<root>
<Address>
<country>USA</country>
<type>
<reference descriptor="Home">nvm</reference>
</type>
</Address>
<Address>
<country>PH</country>
<type>
<reference descriptor="Work">nvm</reference>
</type>
</Address>
</root>
Transform:
Option 1 =
%dw 1.0
%output application/json
---
payload.root.*Address map (
{ homeCountry: $.country } when $.type.reference.@descriptor == "Home" otherwise { homeCountry: "" }
)
Option 2 =
(
payload.root.*Address
filter $.type.reference.@descriptor == 'Home'
map {
homeCountry: $.country
}
)[0]
Output:
{
"homeCountry" : "USA"
}
How to use the value to be the key?
Input:
<ns6:ProductListResponse xmlns:ns5="http://www.twcable.com/common/types/v1x0"
xmlns:ns6="http://www.twcable.com/soa/types/csg/v2x21">
<ns6:Business>
<ns6:BusinessUnit>815020000070</ns6:BusinessUnit>
</ns6:Business>
<ns6:ProductList>
<ns6:Count>2</ns6:Count>
<ns6:Product>
<ns6:Code>$F</ns6:Code>
<ns6:AvailableCatalogIdentifier>60060840415</ns6:AvailableCatalogIdentifier>
<ns6:CatalogIdentifier>600606044</ns6:CatalogIdentifier>
<ns6:ChildCount>2</ns6:ChildCount>
<ns6:ParameterCount>1</ns6:ParameterCount>
<ns6:Parameter>
<ns6:Identifier>6006060093417</ns6:Identifier>
<ns6:Name>FROM_REFERENCE_NAME</ns6:Name>
<ns6:DomainDefinition>N</ns6:DomainDefinition>
</ns6:Parameter>
</ns6:Product>
<ns6:Product>
<ns6:Code>$H</ns6:Code>
<ns6:AvailableCatalogIdentifier>60060840416</ns6:AvailableCatalogIdentifier>
<ns6:CatalogIdentifier>600606045</ns6:CatalogIdentifier>
<ns6:ParameterCount>2</ns6:ParameterCount>
<ns6:Parameter>
<ns6:Identifier>6006060093453</ns6:Identifier>
<ns6:Name>RSTRCT CALLER ID</ns6:Name>
</ns6:Parameter>
<ns6:Parameter>
<ns6:Identifier>6006060093446</ns6:Identifier>
<ns6:Name>BLOCK 900/976</ns6:Name>
</ns6:Parameter>
</ns6:Product>
</ns6:ProductList>
</ns6:ProductListResponse>
Transform:
%dw 1.0
%output application/java
%var products = payload.ProductListResponse.ProductList.*Product
---
{
Status:"Success",
Response: {(
products map {
($.CatalogIdentifier): {($.*Parameter map {
($.Name): $.Identifier
}
)}
}
)}
}
Output:
Status:"Success",
Response:{
600606044 : {
"FROM_REFERENCE_NAME","6006060093417"
},
600606045 : {
"RSTRCT CALLER ID":"6006060093453",
"BLOCK 900/976":"6006060093446"
}
}
How can I filter the objects where "UniqueId": "0"
{
Header: {
MsgId: flowVars.msgCId,
Key: flowVars.key
},
Data: {
Addresses:
payload.ns0#GetCustomerDataResponse.ns0#OCust.*ns0#OCadRecord[?($.ns0#OCAddrId != "0")]
map ((oCadRecord , indexOfOCadRecord) -> {
Type: oCadRecord.ns0#OCAddrUsageCd,
DescriptionOfOther: oCadRecord.ns0#OCAddrDesc,
CountryCd: oCadRecord.ns0#OCCntryCd,
Line1: oCadRecord.ns0#OCStAddrTx,
Line2: oCadRecord.ns0#OCStAddr2Tx,
Line3: oCadRecord.ns0#OCStAddr3Tx,
City: oCadRecord.ns0#OCAddrCityNm,
State: oCadRecord.ns0#OCAddrStateCd,
Zip: oCadRecord.ns0#OCPostalCd,
Zip4: oCadRecord.ns0#OCUsZipSuffCd,
UniqueId: oCadRecord.ns0#OCAddrId
})
}
}
