CSV to JSON in Groovy

csv-to-json

import groovy.json.*

if (args.size() == 0) {
  println("missing argument")
  System.exit(1)
}

def f = new File(args[0])
if (!f.exists()) {
  println("file doesn't exist")
  System.exit(1)
}

def lines = f.readLines()
def keys = lines[0].split(',')
def rows = lines[1..-1].collect { line ->
  def i = 0, vals = line.split(',')
  keys.inject([:]) { map, key -> map << ["$key": vals[i++]] }
}

println(JsonOutput.toJson(rows))

Hello,

I tried this code in groovy & it is converting to JSON but everytime it is printing header portion. I don't want to print header, it will print only for 1st time

My sample CSV file is :

firstName,lastName,email,phoneNumber
John,Doe,[email protected],0123456789
Jane,Doe,[email protected],9876543210
James,Bond,[email protected],0612345678

When i am executing this code the output is :

[{"firstName":"John","lastName":"Doe","email":"[email protected]","phoneNumber":"0123456789"},{"firstName":"Jane","lastName":"Doe","email":"[email protected]","phoneNumber":"9876543210"},{"firstName":"James","lastName":"Bond","email":"[email protected]","phoneNumber":"0612345678"}]

But I want the output should be:

[{"firstName":"lastName":"email":"phoneNumber"},
{"John":"Doe":"[email protected]":"0123456789"},
{"Jane":"Doe":"[email protected]":"9876543210"}]

Any help on this? regarding changes of code.