Extracting multiple attributes from xml

[iilyak]

I am trying to extract all attributes of a node (I don't know attribute names upfront).

Here is the example of xml file.

<?xml version="1.0" encoding="UTF-8"?>
<mxfile host="Electron" modified="2022-12-27T16:51:00.393Z" agent="5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) draw.io/20.7.4 Chrome/106.0.5249.199 Electron/21.3.3 Safari/537.36" etag="Chvfh0pmRcsiRFeLGn84" version="20.7.4" type="device">
  <diagram id="DIBkk8TONfjRhfH_ZR78" name="Page-1">
    <mxGraphModel dx="1114" dy="878" grid="1" gridSize="10" guides="1" tooltips="1" connect="1" arrows="1" fold="1" page="1" pageScale="1" pageWidth="1100" pageHeight="850" math="0" shadow="0">
      <root>
        <mxCell id="0"/>
        <mxCell id="1" parent="0"/>
        <object label="" my_property="324" my_string="hello" id="vs0W597VZl1qWhmtER3h-1">
          <mxCell style="rounded=0;whiteSpace=wrap;html=1;" parent="1" vertex="1">
            <mxGeometry x="100" y="200" width="120" height="60" as="geometry"/>
          </mxCell>
        </object>
      </root>
    </mxGraphModel>
  </diagram>
</mxfile>

I can extract the object using:

❯ dasel -f test.drawio.xml 'mxfile.diagram.mxGraphModel.root.object'
<doc id="vs0W597VZl1qWhmtER3h-1" label="" my_property="324" my_string="hello">
  <mxCell parent="1" style="rounded=0;whiteSpace=wrap;html=1;" vertex="1">
    <mxGeometry as="geometry" height="60" width="120" x="100" y="200"/>
  </mxCell>
</doc>

But I cannot extract attributes even if I specify their name:

❯ dasel -f test.drawio.xml 'mxfile.diagram.mxGraphModel.root.object.property(my_property)'

❯ dasel --version
dasel version 2.0.2

Bonus question how do I use filter to extract attributes of all objects which contain attribute with given value?

❯ dasel -f test.drawio.xml 'mxfile.diagram.mxGraphModel.root.all().filter(equal(object.my_property,"hello"))'

[iilyak]

Also I need the result to be outputted as JSON, because extracting it again from <doc></doc> is hard in shell.

[{
    "id": "vs0W597VZl1qWhmtER3h-1",
    "label": "",
    "my_property": "324",
    "my_string": "hello"
}]

[TomWright]

XML attributes are named with a - prefix.

$ dasel -f test.drawio.xml 'mxfile.diagram.mxGraphModel.root.object.-my_property'
324

If you struggle with anything like this it can help to add -w - to output the result as "plain", allowing you to see exactly what dasel is looking at:

$ dasel -f test.drawio.xml -w - 'mxfile.diagram.mxGraphModel.root.all()'
map[-id:vs0W597VZl1qWhmtER3h-1 -label: -my_property:324 -my_string:hello mxCell:map[-parent:1 -style:rounded=0;whiteSpace=wrap;html=1; -vertex:1 mxGeometry:map[-as:geometry -height:60 -width:120 -x:100 -y:200]]]
[map[-id:0] map[-id:1 -parent:0]]

Does this satisfy your needs?

$ dasel -f test.drawio.xml -w json 'mxfile.diagram.mxGraphModel.root.all().filter(and(equal(type(),object),equal(-my_property,324)))'
{
  "-id": "vs0W597VZl1qWhmtER3h-1",
  "-label": "",
  "-my_property": "324",
  "-my_string": "hello",
  "mxCell": {
    "-parent": "1",
    "-style": "rounded=0;whiteSpace=wrap;html=1;",
    "-vertex": "1",
    "mxGeometry": {
      "-as": "geometry",
      "-height": "60",
      "-width": "120",
      "-x": "100",
      "-y": "200"
    }
  }
}