Data.Page API

Use the Data.Page API when a conversion needs to run from a script, scheduled job, internal tool, or website button. The API accepts JSON and returns CSV, or accepts CSV and returns JSON.

The free API allowance is 1 MB per day. Contact us if you need higher volume, private workflow support, or help choosing the right conversion settings.

After registration, use one of the examples below to post data to the API and save the result.

Python Sample Code



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

email = '[email protected]'
input_filename =  'c:\\temp\\input.json'
output_filename = 'c:\\temp\\output.csv'

#read json
with open(input_filename) as json_file:
    json = json_file.read()
    api_url = 'https://data.page/api/getcsv'
    post_fields = {'email': email, 'json': json}
    request = Request(api_url, urlencode(post_fields).encode(),    headers={
        'User-Agent': 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.47 Safari/537.36'
    })
    csv = urlopen(request).read().decode()

#write csv
with open(output_filename, "w") as f:
    f.write(csv)
    f.close()

PHP Sample Code


    $url = 'https://data.page/api/getcsv';
    $email = '[email protected]';
    $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 = '[email protected]';
    $json = '{"test":true,"test2":false}';

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

    $ch = curl_init('https://data.page/api/getcsv');

    curl_setopt($ch, CURLOPT_POSTFIELDS, $post);

    $response = curl_exec($ch);

    curl_close($ch);

    echo $response;

Google Apps Script

Generate a CSV file in your Google Drive account. Contact us for variations such as pulling data into Google Sheets.

function myFunction() {

  var email ="[email protected]";

  var url="https://api.fiscaldata.treasury.gov/services/api/fiscal_service/v2/accounting/od/avg_interest_rates";
  var json = UrlFetchApp.fetch(url).getContentText();

  var options = {
    'method' : 'post',
    'contentType': 'application/x-www-form-urlencoded',
    'payload' : {
      email:email,
      json:json
    }
  };
  var resp=UrlFetchApp.fetch('https://data.page/api/getcsv', options);

  // Creates a new CSV file in your Google Drive account
  var fid=DriveApp.createFile(resp.getBlob());
  fid.setName("DataPage-output.csv");

}

C# Sample Code

    
    
    string email = "[email protected]";
    string json = "{\"test\":true,\"test2\":false}";
    using (var client = new HttpClient())
    {
    string url = "https://data.page/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://data.page/api/getcsv -F [email protected] -F [email protected] -o output.csv

CSV to JSON

The API also has CSV to JSON functionality. This works the same way as JSON to CSV except:

The URL changes from https://data.page/api/getcsv to https://data.page/api/getjson.
Pass two parameters: email (your email address) and csv (the CSV string).

Here's a PHP sample for CSV to JSON:

    
    

     $email,
            'csv' => $csv
            )
        );

        $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;

Please contact us for further information.

}