json-to-gsheet.py

import sys
import gspread
import requests

cases = requests.get("http://slides.pathology.umn.edu/ISP/cases.json").json()

# Login with your Google account
gc = gspread.login(sys.argv[1], sys.argv[2])

# Open a worksheet from spreadsheet with one shot
wks = gc.open("ISPCases").sheet1

case_fields = {
    "contact": "B",
    "clinicalPresentation": "E",
    "slides": "D",
    "images": "C"
}

for case in cases:
    print case
    case_row = str(int(case) + 1)
    wks.update_acell('A' + case_row, case)
    case_data = cases[case]

    for field in case_fields:
        if field in case_data:
            if field is "slides":
                cell_value = ""
                for slide in case_data[field]:
                    slide_page = ".".join([slide['slideUrl'], "html"])
                    cell_value = "\n".join([cell_value, slide_page])
            elif field is "images":
                cell_value = ""
                for image in case_data[field]:
                    base_url = "http://slides.pathology.umn.edu/ISP"
                    image_url = "/".join([base_url, image])
                    cell_value = "\n".join([cell_value, image_url])
            else:
                print case_fields[field], field, case_data[field]
                cell_value = case_data[field]
            wks.update_acell(case_fields[field] + case_row, cell_value)

# Fetch a cell range
#cell_list = wks.range('A1:B7')
#print cell_list