Print single JSON Object as a CSV in C#

Question

I'm trying to print a single JObject as a CSV row

for example:

{"result": {
"id": "24095",
"hostid": "24094",
"name": "host1.fqdn.com",
"ipaddress" : "192.168.1.184"
}
}

as

id,hostid,name,ipaddress
24095,24094,host1.fqdn.com,192.168.1.184

I can easily iterate through the object with

foreach (var item in jobj) {
   Console.Write(item.Key + ",");
}

but I end up with a , at the end of the header

I tried

for (int i = 0; i < jobj.Count; i++)...

but I'm having trouble accessing i.Key. I'm doing something wrong here but i'm not sure what.

Any ideas on how i can print all the keys in an object as a CSV minus a , at the end?

Thank you.

Brian Rogers · Accepted Answer · 2014-10-09 15:05:52Z

1

Try the following code.

string result = string.Empty;

foreach (var item in jobj)
{
    if (!string.IsNullOrEmpty(result))
    {
        result += ",";
    }
    result += item.Key;
}
Console.WriteLine(result);

edited Oct 9, 2014 at 15:05

Brian Rogers

130k31 gold badges315 silver badges315 bronze badges

answered Oct 9, 2014 at 5:31

jadavparesh06

9467 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gerard Sexton · Accepted Answer · 2014-10-09 05:31:14Z

1

Iterate over all except the last one, then use the last one outside the block.

for (int i = 0; i < jobj.Count-1; i++) {
    Console.Write(jobj[i].Key + ", ");
}

Console.WriteLine(jobj[jobj.Count-1].Key);

answered Oct 9, 2014 at 5:31

Gerard Sexton

3,22030 silver badges37 bronze badges

2 Comments

anoopb Over a year ago

Hi. Thanks for answering. I have no trouble iterating over all the items but I'm trying to get just the keys. Not the values. So jobj[i].key is what i'm after but it's not available as a property.

Gerard Sexton Over a year ago

I dont recognise JObject, what is it apart of?

Collectives™ on Stack Overflow

Print single JSON Object as a CSV in C#

2 Answers 2

Comments

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Related