CODEWITHSUNDEEP
xmldataweavemule4
user1905307
user1905307

Reputation: 47

Dataweave 2.0 - How to obtain an XML elements value, based on it's attribute name

I'm trying to work out how to extract an XML element value from a repeating list of elements with the same name, but different attribute names.

In this case, how would you extract the element value ('ABC') for the element with attribute name 'xxx.UDFCHAR10', in DataWeave 2.0?

<root>
   <UserArea>
      <PropertyList>
         <Property>
            <NameValue name="xxx.CreatedBy">Test 1</NameValue>
         </Property>
         <Property>
            <NameValue name="xxx.EnteredBy">Test 2</NameValue>
         </Property>
         <Property>
            <NameValue name="xxx.SafetyFlag">false</NameValue>
         </Property>
         <Property>
            <NameValue name="xxx.DependFlag">true</NameValue>
         </Property>
         <Property>
            <NameValue name="xxx.UDFCHAR10">ABC</NameValue>
         </Property>
      </PropertyList>
   </UserArea>
</root>

Thanks

Upvotes: 0

Views: 2231

Answers (3)

Vlad K
Vlad K

Reputation: 2851

This is the way that I would use:

%dw 2.0
output application/json
---
payload.root.UserArea.PropertyList.*Property.NameValue[?($.@name == "xxx.UDFCHAR10")][0]

Upvotes: 0

maddestroyer7
maddestroyer7

Reputation: 263

Use the multi selector to get all property objects, then create an ArrayList by selecting NameValue. Then use firstWith to grab the first string that fits the provided criteria

%dw 2.0
output application/json
import firstWith from dw::core::Arrays
var data = read("<root>
   <UserArea>
      <PropertyList>
         <Property>
            <NameValue name='xxx.CreatedBy'>Test 1</NameValue>
         </Property>
         <Property>
            <NameValue name='xxx.EnteredBy'>Test 2</NameValue>
         </Property>
         <Property>
            <NameValue name='xxx.SafetyFlag'>false</NameValue>
         </Property>
         <Property>
            <NameValue name='xxx.DependFlag'>true</NameValue>
         </Property>
         <Property>
            <NameValue name='xxx.UDFCHAR10'>ABC</NameValue>
         </Property>
      </PropertyList>
   </UserArea>
</root>","application/xml")
---
payload.root.UserArea.PropertyList.*Property.NameValue firstWith ((object) -> object.@name == "xxx.UDFCHAR10")

output:

"ABC"

Upvotes: 1

aled
aled

Reputation: 25872

Use the multi-valued selector to get all the repeated instances into an array, then you can filter by the value of the attribute using the attribute selector on the element that has it. This method will return an array of the extracted values, however if you know there is going to be only one element you can extract it by index [0].

Note that your description is not really accurate because the attribute is in a sub element of the repeating element.

%dw 2.0
output application/java
---
(payload.root.UserArea.PropertyList.*Property 
    filter ($.NameValue.@name == "xxx.UDFCHAR10")).NameValue

Output:

[
  "ABC"
]

Upvotes: 2

Related Questions