Flatten json to csv

json2csv.py

#!/usr/bin/env python3

# usage:    json2csv url

# requirements: requests, flatten_json
# ie use pip or pip2 and install them:
#   sudo pip (or sudo pip2) install requests flatten_json

import sys

from flatten_json import flatten
import requests

if __name__ == '__main__':
    r = requests.get(sys.argv[1])
    d = r.json()
    f = flatten(d)
    # FIXME: escape quotes?
    # Headings
    print("{}".format(','.join(f.keys())))
    # Values
    print("{}".format(','.join(f.values())))