Json Question posted in
Our archive of expertly curated questions and answers provides insights and solutions to common problems related to this popular data interchange format. From parsing and manipulating JSON data to integrating it with various programming languages and web services, our archive has got you covered. Start exploring today and take your JSON skills to the next level

Groovy utf-8 encoding JSON or CSV file

I’m beginner in Groovy, I do JSON parsing and export data to a csv file, but it turns out like in the screenshot. How can I better write it in the code so that the data is correct when exporting to a file, or do I need to convert the csv file itself to UTF-8?

import groovy.json.JsonSlurper 
def conn = "http://jira.server.net:8080/rest/api/2/project/".toURL().openConnection()
conn.setRequestProperty('Authorization', 'Basic ' + 'login:password'.bytes.encodeBase64().toString())
 if(conn.responseCode == 200) {
     def jsonSlurper = new JsonSlurper()
     def data = jsonSlurper.parseText(conn.content.text)

     def file = new File("C:/Temp/data.csv")

     def stringBuilder = new StringBuilder()
     data.each { row ->
         stringBuilder.append(row.join(';')).append(System.lineSeparator())
               }

     file.text = stringBuilder.toString()
 } else {
     println "Something bad happened."
     println "${conn.responseCode}: ${conn.responseMessage}"
 }

Result:

Разработка СПО ПТСПК версии

Tags:

2

Answers


  1. 0

    Setting up encoding should fix it.

    file.withWriter('UTF-8'){ it << stringBuilder }
    Login or Signup to reply.
  2. 0

    conn.content returns InputStream

    (something like sun.net.www.protocol.http.HttpURLConnection$HttpInputStream)

    when you transform it to text with conn.content.text – you actually calling InputStream.getText()

    you can convert input stream to text with InputStream.getText("UTF-8")

    or you can parse the input stream into json without text:

    def data = jsonSlurper.parse(conn.content, "UTF-8")

    https://docs.groovy-lang.org/latest/html/gapi/groovy/json/JsonSlurper.html#parse(java.io.InputStream,%20java.lang.String)

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search