Python Locations and Attributes example

import requests
import json
import csv

url = 'http://localhost:8080/FewsWebServices/rest/fewspiservice/v1/locations?showAttributes=true'
params = dict(
    documentVersion='1.25',
    documentFormat='PI_JSON'
)
response = requests.get(url=url, params=params)
data = response.json()  # alle data in JSON (dictionary) formaat
locations = data['locations'] # haalt alle parameters uit de dictionary

# collect all possibile location keys in a list
location_keys_list = []
for location in locations:
    keys = location.keys()
    for key in keys:
        if key not in location_keys_list:
            location_keys_list.append(key)
# remove 'attributes' element as these will be handled seperately
if 'attributes' in location_keys_list: location_keys_list.remove('attributes')

# collect all possibile attributes in a list
attribute_list = []
for location in locations:
    for attribute in location['attributes']:
        attr_id = str(attribute.get('id'))
        if attr_id not in attribute_list:
            attribute_list.append(attr_id)
# insert locationId as the first element in the attribute list
attribute_list.insert(0,'locationId')
            
with open('locations.csv', 'w', newline='', encoding='utf-8') as loc_csv:
    l = csv.writer(loc_csv, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)
    l.writerow(location_keys_list)

    for location in locations:
        temp_dict = {}
        for key in location_keys_list:
            if key in location:
                temp_dict[key] = str(location[key])
            else:
                temp_dict[key] = ''
        loc_writerow = [temp_dict[k] for k in location_keys_list]
        l.writerow(loc_writerow)

with open('attributes.csv', 'w', newline='', encoding='utf-8') as attr_csv:
    a = csv.writer(attr_csv, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)
    a.writerow(attribute_list)

    for location in locations:
        temp_dict = {}
        for attribute in location['attributes']:
            for attr in attribute_list:
                if str(attribute.get('id')) == attr:
                    if attribute.get('type') == 'text':
                        temp_dict[attr] = str(attribute.get('value'))
                    if attribute.get('type') == 'number':
                        temp_dict[attr] = float(attribute.get('value')) 
                    if attribute.get('type') == 'boolean':
                        temp_dict[attr] = bool(attribute.get('value')) 
        for attr in attribute_list:
            if not attr in temp_dict.keys():
                temp_dict[attr] = ''
        temp_dict['locationId'] = str(location['locationId'])
        attr_writerow = [temp_dict[a] for a in attribute_list]
        a.writerow(attr_writerow)
        
print('Finished!')

{
  "version": "1.25",
  "geoDatum": "WGS 1984",
  "locations": [{
    "locationId": "locX",
    "shortName": "Location X",
    "lat": "54.63",
    "lon": "-113.38",
    "x": "-113.38",
    "y": "54.63",
    "z": "0.0",
    "attributes": [{
      "name": "operating_agency",
      "type": "text",
      "id": "operating_agency",
      "value": "GovAA"
    }, {
      "name": "meteo_station",
      "type": "boolean",
      "id": "meteo_station",
      "value": "TRUE"
    }, {
      "name": "test_ext_id",
      "type": "text",
      "id": "test_ext_id",
      "value": "CPAF"
    }]
	...more locations...
  }]
}