Baltimore City Employee Salaries FY2014

load_cloudant.py

#!/usr/bin/env python

import requests, json

CL_USERNAME = CHANGE_ME
CL_PASSWORD = CHANGE_ME

AUTH=(CL_USERNAME, CL_PASSWORD)
jsondata = requests.get('https://data.baltimorecity.gov/api/views/2j28-xzd7/rows.json?accessType=DOWNLOAD')

colnames = [colname['name'].strip() for colname in jsondata.json()['meta']['view']['columns']]

posturl='https://' + CL_USERNAME + '.cloudant.com/baltimorecity/_bulk_docs'
alldata = {'docs': [dict(zip(colnames, data)) for data in jsondata.json()['data']]}

resp = requests.post(posturl, auth=AUTH, data=json.dumps(alldata), headers=postheaders)
print resp.text