Possibilty to increase speed of the script ? about automation-scripts HOT 4 CLOSED

# Find all appliance networks (MX, Z1, Z3, vMX100)
session = requests.session()
headers = {'X-Cisco-Meraki-API-Key': API_KEY, 'Content-Type': 'application/json'}
try:
    name = json.loads(session.get('https://api.meraki.com/api/v0/organizations/' + ORG_ID, headers=headers).text)['name']
except:
    sys.exit('Incorrect API key or org ID, as no valid data returned')
networks = json.loads(session.get('https://api.meraki.com/api/v0/organizations/' + ORG_ID + '/networks', headers=headers).text)
inventory = json.loads(session.get('https://api.meraki.com/api/v0/organizations/' + ORG_ID + '/inventory', headers=headers).text)
appliances = [device for device in inventory if device['model'][:2] in ('MX', 'Z1', 'Z3', 'vM') and device['networkId'] is not None]
devices = [device for device in inventory if device not in appliances and device['networkId'] is not None]


# Output CSV of appliances' info
today = datetime.date.today()
csv_file1 = open(name + '_appliances'+'.csv', 'w', encoding='utf-8')
fieldnames = ['Reseau', 'Equipement', 'Modele', 'Statut Internet Pincipal (WAN 1)', 'Statut Internet Secondaire 4G/LTE (WAN 2)']
writer = csv.DictWriter(csv_file1, fieldnames=fieldnames, restval='')
writer.writeheader()

# Iterate through appliances
for appliance in appliances:
    network_name = get_network_name(appliance['networkId'], networks)
    print('Looking into network ' + network_name)
    device_name = json.loads(session.get('https://api.meraki.com/api/v0/networks/' + appliance['networkId'] + '/devices/' + appliance['serial'], headers=headers).text)['name']
    try:
        perfscore = json.loads(session.get('https://api.meraki.com/api/v0/networks/' + appliance['networkId'] + '/devices/' + appliance['serial'] + '/performance', headers=headers).text)['perfScore']
    except:
        perfscore = None
    try:
        print('Found appliance ' + device_name)
    except:
        print('Found appliance ' + appliance['serial'])
    uplinks_info = dict.fromkeys(['WAN1', 'WAN2', 'Cellular'])
    uplinks_info['WAN1'] = dict.fromkeys(['interface', 'status', 'ip', 'gateway', 'publicIp', 'dns', 'usingStaticIp'])
    uplinks_info['WAN2'] = dict.fromkeys(['interface', 'status', 'ip', 'gateway', 'publicIp', 'dns', 'usingStaticIp'])
    uplinks_info['Cellular'] = dict.fromkeys(['interface', 'status', 'ip', 'provider', 'publicIp', 'model', 'connectionType'])
    uplinks = json.loads(session.get('https://api.meraki.com/api/v0/networks/' + appliance['networkId'] + '/devices/' + appliance['serial'] + '/uplink', headers=headers).text)
    for uplink in uplinks:
        if uplink['interface'] == 'WAN 1':
            for key in uplink.keys():
                uplinks_info['WAN1'][key] = uplink[key]
        elif uplink['interface'] == 'WAN 2':
            for key in uplink.keys():
                uplinks_info['WAN2'][key] = uplink[key]
        elif uplink['interface'] == 'Cellular':
            for key in uplink.keys():
                uplinks_info['Cellular'][key] = uplink[key]
    if network_name != 'F.D.LABO.N002': #ajouter or pour ajouter des exception note il n'affichera jamais rien pour ce device
        if appliance['model'] == 'MX68' and uplinks_info['WAN2']['status'] == 'Not connected' or uplinks_info['WAN2']['status'] == 'Failed' or uplinks_info['WAN1']['status'] == 'Not connected' or uplinks_info['WAN1']['status'] == 'Failed':
            #Ecriture de ligne dans le csv uniquement si une des conditions si dessus est applicable
            writer.writerow({'Reseau': network_name, 'Equipement': device_name, 'Modele': appliance['model'], 'Status Internet Pincipal (WAN 1)': uplinks_info['WAN1']['status'], 'Status Internet Secondaire 4G/LTE (WAN 2)': uplinks_info['WAN2']['status']})

csv_file1.close()