Back ArrowExplore all topics

Convert json array to CSV using Apache common-io in Java

share link

by loke dot icon Updated: Dec 28, 2022

technology logo
technology logo

Solution Kit Solution Kit  

The technique for converting a JSON array to a CSV file using Apache Commons IO in Java can be helpful in several situations where you want to export data stored in a JSON array to a CSV file. This may be helpful in the following cases, for instance:  

  • converting data saved in a database or other storage system that is represented as a JSON array;  
  • exporting data from a web application or API that returns data in JSON format;  
  • Transforming data from one format to another is part of the ETL (extract, transform, load) process. 

 

It offers a large selection of classes and methods that can be utilized to carry out different I/O-related operations, including reading and writing files, navigating directories and files, reading and writing to input and output streams, and more. When working with I/O operations in Java, Apache Commons IO is a valuable tool in your toolbox because it is a widely used library.  

Here is an example of how you can convert JSON array to CSV using Apache common-io in Java for your application: 


Fig 1: Preview of the output that you will get on running this code from your IDE

Code

Json Array List to CSV format

JavadotLines of Code : 18dotLicense : Strong Copyleft (CC BY-SA 4.0)

Dependent Libraries : 
public static void main(String[] args) throws IOException {
    String inputJson = "{Results: [\n" +
            " {\"Item\":1,\"Status\":\"Approved\",\"Name\":\"Brownie\",\"SubmitDate\":\"2016-04-05T14:06:16Z\",\"ReceivedState\":1},\n" +
            " {\"Item\":3,\"Status\":\"Approved\",\"Name\":\"Oats\",\"SubmitDate\":\"2016-04-19T19:39:25Z\",\"ReceivedState\":1},\n" +
            " {\"Item\":2,\"Status\":\"Submitted\",\"Name\":\"Choclate\",\"SubmitDate\":\"2016-06-01T12:40:19Z\",\"ReceivedState\":1},\n" +
            " ]}";
    JSONObject jsonObj = new JSONObject(inputJson);
    JSONArray objJsonArray = jsonObj.getJSONArray("Results");
    String csv = CDL.toString(objJsonArray);
    System.out.println(csv);
    FileUtils.writeStringToFile(new File(System.getenv("HOME")+ "/temp.csv"), csv);
}

Status,Item,SubmitDate,ReceivedState,Name
Approved,1,2016-04-05T14:06:16Z,1,Brownie
Approved,3,2016-04-19T19:39:25Z,1,Oats
Submitted,2,2016-06-01T12:40:19Z,1,Choclate
  1. Copy the code using the "Copy" button above, and paste it in a Java file in your IDE.
  2. Add dependent library and import in java file.
  3. Run the file to generate csv file.

I hope you found this useful. I have added the link to dependent libraries, version information in the following sections.


I found this code snippet by searching for "json array to csv in java" in kandi. You can try any such use case!

Development Libraries

commons-ioby apache

Java doticonstar image 913 doticonVersion:Currentdoticon
License: Permissive (Apache-2.0)

Apache Commons IO

Support
    Quality
      Security
        License
          Reuse

            commons-ioby apache

            Java doticon star image 913 doticonVersion:Currentdoticon License: Permissive (Apache-2.0)

            Apache Commons IO
            Support
              Quality
                Security
                  License
                    Reuse

                      JSON-javaby stleary

                      Java doticonstar image 4285 doticonVersion:20230227doticon
                      License: Others (Non-SPDX)

                      A reference implementation of a JSON package in Java.

                      Support
                        Quality
                          Security
                            License
                              Reuse

                                JSON-javaby stleary

                                Java doticon star image 4285 doticonVersion:20230227doticon License: Others (Non-SPDX)

                                A reference implementation of a JSON package in Java.
                                Support
                                  Quality
                                    Security
                                      License
                                        Reuse

                                          You can add the dependent library in your gradle or maven files. you can get the dependancy xml in above link

                                          You can search for any dependent library on kandi like apache commons io and json java

                                          Support

                                          1. For any support on kandi solution kits, please use the chat
                                          2. For further learning resources, visit the Open Weaver Community learning page.


                                          See similar Kits and Libraries

                                          Open Weaver – Develop Applications Faster with Open Source

                                          kandi

                                          Community and Support

                                          Company

                                          Follow

                                          • © 2023 Open Weaver Inc.