How to convert xml to json in Groovy?

Question

In groovy I have the below xml

<data>
   <row>
      <id>USA</id>
      <value>United States of America</value>
   </row>
   <row>
      <id>CAN</id>
      <value>Canada</value>
   </row>
</data>

I need to transform the above xml in groovy to the below json format

{
   "data": [
      {
         "KEY": "USA",
         "VALUE": "United States of America"
      },
      {
         "KEY": "CAN",
         "VALUE": "Canada"
      }
   ]
}

Any help would be greatly appreciated.

Thanks

Hari

https://stackoverflow.com/questions/41073630/xml-to-json-conversion-in-groovy — OTUser, Jul 05 '17 at 19:26

score 1 · Accepted Answer · answered Jul 05 '17 at 23:12

1

Here you go:

//Pass xml as string to below parseText method
def parsed = new XmlSlurper().parseText(xml)
//Create the map as needed out of parsed xml
def map = [(parsed[0].name): parsed.'**'
  .findAll{it.name() == 'row'}
  .collect{ row ->
     row.collectEntries{[KEY: row.id.text(), VALUE:row.value.text()]}
   }
]
println new groovy.json.JsonBuilder(map).toPrettyString()

You can quickly try it online Demo

answered Jul 05 '17 at 23:12

Rao

20,781
11
57
77

Just nitpicking: you don't need the `row.collectEntries{ ... }` there - the `...` is enough – cfrick Jul 06 '17 at 06:22

How to convert xml to json in Groovy?

1 Answers1