Convert json file to CSV file in C#

Question

0.00/5 (No votes)

See more:

Hi,
Am trying to convert json to csv. the json that i use is a complex json with deep nested arrays and child objects. Converting json -> xml -> dtatable ->csv is not working as am missing some of the hierarchies in this approach.

Could any one suggest some approach for the conversion?

thisis the part of the sample json that i use:

{
    "ParentRoot": {
        "Root1": [
            {
                "Value1": {
                    "innervalue1": "value",
                    "innervalue2": "value",
                    "innervalue3": "value",
                    "innervalue4": "value",
                    "innervalue5": "value",
                    "innervalue6": "value",
                    "innervalue7": "value"
                }
            }
        ],
        "Root2": {
            "Value2": {
                "innervalue1": "value",
                "innerArray1": {
                    "innerarrayvalue1": "value",
                    "innerarrayvalue2": "value",
                    "innerarrayvalue3": "value"
                },
                "innerArray2": {
                    "innerarrayvalue1":"value",
                    "innerarrayvalue2": "value",
                    "innerarrayvalue3": "value",
                    "innerarrayvalue4": "value",
                    "innerarrayvalue5": [
                        {
                            "childarrayValue": "value",
                            "childarrayValue2": "value"
                        },
                        {
                            "childarrayValue": "value",
                            "childarrayValue2": "value"
                        } ],

                    "other value": null
                }
            },
            "Root2child": [
                {
                    "innerValue": "value",
                    "innervalue2": "value",
                    "root2child": {
                        "innerValue": "value",
                        "innerValue1": "value",
                        "innerValue2": "value",
                        "innerValue3": "value"
                    },
                    "innerValue2": [
                        {
                            "inervalue3": "value",
                            "inervalue4": "value",
                            "inervalue5": "value",
                            "inervalue6": "value",
                            "inervalue7": "value",
                            "inervalue8": "value",
                            "inervalue9": "value",
                            "inervalue10": "value",
                            "inervalue11": "value",
                            "inervalue12": "value",
                            "inervalue13": "value",
                            "inervalue14": "value",
                            "inervalue15": "value",
                            "inervalue16": "value",
                            "inervalue17": "value",
                            "inervalue18": "value",
                            "inervalue19": "value",
                            "inervalue20": "value",
                            "inervalue21": "value",
                            "inervalue22": "",
                            "inerArray": {
                                "inerArrayValue": "value",
                                "inerArray": {
                                    "innerArrayElement": "value",
                                    "innerArrayElement1": "value"
                                },
                                "innerArrayValue2": [
                                    {
                                        "element": "value"
                                    }
                                ]
                            }
                        }
                    ]
                }
            ]
        }

        }

    }

What I have tried:

Tried differret logics but nothing helped

Posted 4-Apr-17 23:55pm

Divya RS

Updated 30-Jun-17 11:21am

Add a Solution

Comments

F-ES Sitecore 5-Apr-17 7:10am

What is the CSV file going to look like?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Afzaal Ahmad Zeeshan · Answer 1 · 2017-04-05T00:46:00

There is no need for this much type conversion,

Quote:
Converting json -> xml -> dtatable ->csv is not working

You can simply convert the JSON document to a CSV document. For that, you need 2 libraries, 1 that would convert from JSON to runtime objects, then another that maps those runtime objects to CSV document.

We are aware of the Json.NET library, then there is another library written to convert the objects to CSV; Simple and fast CSV library in C#[^], have a look at the coding examples then write them in your own application.

And as for your type conversion, why doesn't that work? I think that does, here is a proof for that, the same conversion was marked as answer on this thread, JSON string to CSV and CSV to JSON conversion in c# - Stack Overflow[^]