logo

JSON to CSV Api

We also offer an API service. Automate your JSON to CSV conversions simply and on demand. You can also create a JSON to CSV export button very easily.

We allow 1 MB per day to be converted via the API for free (contact us if you need more than this). We would also appreciate it if you would mention us on your website if that is possible.

Register here to access the API:

required

After you have registered, the following illustrates how you would process an automatic conversion using PHP or C#:

Python Sample Code


    email = 'youremail@here.com'
    json = '{"test":true,"test2":false}'
    filename = 'output.csv'

    from urllib.parse import urlencode
    from urllib.request import Request, urlopen
    import sys

    sys.stdout.write('Status: 200 OK\n')
    sys.stdout.write('Content-Type: text/csv; charset=utf-8\n')
    sys.stdout.write('Content-Disposition: attachment; filename=' + filename + '\n\n')

    url = 'https://json-csv.com/api/getcsv'
    post_fields = {'email': email, 'json': json}
    request = Request(url, urlencode(post_fields).encode())
    csv = urlopen(request).read().decode()

    for l in csv.split('\r\n'):
        print (l)



PHP Sample Code


    $url = 'https://json-csv.com/api/getcsv';
    $email = 'youremail@here.com';
    $json = '{"test":true,"test2":false}';

    $postdata = http_build_query(
      array(
        'email' => $email,
        'json' => $json
      )
    );

    $opts = array(
      'http' => array(
        'method'  => 'POST',
        'header'  => 'Content-type: application/x-www-form-urlencoded',
        'content' => $postdata
      )
    );
    $context  = stream_context_create($opts);
    $result = file_get_contents($url, false, $context);

    print $result;



PHP Sample Code - Alternative (using cURL)


    $email = 'youremail@here.com';
    $json = '{"test":true,"test2":false}';

    $post = 'email=' . $email . '&json=' . $json;

    $ch = curl_init('https://json-csv.com/api/getcsv');

    curl_setopt($ch, CURLOPT_POSTFIELDS, $post);

    $response = curl_exec($ch);

    curl_close($ch);

    echo $response;



C# Sample Code

    
    
    string email = "youremail@here.com";
    string json = "{\"test\":true,\"test2\":false}";
    using (var client = new HttpClient())
    {
    string url = "https://json-csv.com/api/getcsv";
    var content = new FormUrlEncodedContent(new[]
    {
        new KeyValuePair<string, string>("email", email),
        new KeyValuePair<string, string>("json", json)
    });
    var result = client.PostAsync(url, content).Result;
    string csvContent = result.Content.ReadAsStringAsync().Result;
    Response.Write(csvContent);
    }
    


Raw cURL Sample Code (from a Linux Shell for example)

To convert an input.json file to output.csv

    
    curl -X POST https://json-csv.com/api/getcsv -F email=youremail@here.com -F json=@input.json -o output.csv
    

Please contact us for further information