snow_login.py

SNOW_BASE_URL = 'https://xxxx.service-now.com/api/'
def snow_login(states):
    user = 'XXXX'
    pwd = 'XXXX'
    headers = {"Content-Type":"application/json","Accept":"application/json"}
    snow_data=[]
    
    for state in states:  
        url = SNOW_BASE_URL + 'now/table/incident?sysparm_display_value=all&sysparm_fields=number%2Cassigned_to%2Csys_id%2Cstate%2Ccomments%2Cwork_notes%2Ccmdb_ci&cmdb_ci=xxxx&state='+state
    
        response = requests.get(url, auth=(user, pwd), headers=headers )
        if response.status_code != 200: 
            print('Status:', response.status_code, 'Headers:', response.headers, 'Error Response:',response.json())
            exit()
        data = response.json()
        snow_data = snow_data + data['result']
    return snow_data

# call this using 
snow_data = snow_login(['New', 'Active'])