Get json data from url and output as a csv file

Question

How can you get JSON data dynamically, then output it as a CSV file? Is it possible to get it to output with a change in data?

I have the following code below, but it doesn't work.

var url = "https://reqres.in//api/users?page=2";

using (WebClient webClient = new System.Net.WebClient())
{
  WebClient n = new WebClient();
  var json = n.DownloadString(url);
  string valueOriginal = Convert.ToString(json);
}

I want to get the JSON data from whatever URL and output it as a CSV.

Are you passing `"apiURL"` as a parameter instead of the actual `url` property? — Ipsit Gaur, Jul 13 '18 at 06:04
*Is it possible to get it output with a change in data*, well, you will need to define the csv structure.. there is [no free lunch](https://en.wikipedia.org/wiki/No_free_lunch_theorem) for the conversion, [whoops](https://www.npmjs.com/package/json2csv). — Bagus Tesa, Jul 13 '18 at 06:10
Json is the serialisation of an object. Csv isn't. So you create the class for serialisation and voila — Drag and Drop, Jul 13 '18 at 06:18

score 0 · Answer 1 · answered Jul 13 '18 at 06:51

0

Can you just use CsvHelper? One example can be found from here.

Another option is to write your own implementation to achieve this goal (as shown in example1 or example2).

Good luck.

answered Jul 13 '18 at 06:51

Ping

124
3

Get json data from url and output as a csv file

1 Answers1