Fieldbook API example using Python: read a dictionary of values from fieldbook sheet

fieldbook.py

POST_URL='https://api.fieldbook.com/v1/<USER_ID>/<SHEET_ID>'
KEY='...'
SECRET='...'

def get_fieldbook_json():
    try:
        response = requests.get(POST_URL, auth=(KEY, SECRET))
        if response.status_code != 200:
            return None
        return response.json()
    except requests.exceptions.ConnectionError as e:
        print(e)

def parse_response(response_json):
    result  = {}
    for record in response_json:
        result[record['<FIRST_COLUMN_ID>']] = record['<SECOND_COLUMN_ID>']
    return result