Script to get and update records in ServiceNow

patch_snow.py

# Need to install requests package for python
# easy_install requests
import requests

sn_username = ''
sn_password = ''

# this is the beginning of your URL e.g. company.service-now.com would be "company"
instance_name = ''

# The table to pull data and update records
table_name = ''

# the sysparam Query to select the records you wish to updated
query_url = ''

# A list of attributes for your table can be found in the API Explorer
# These  values will differ depending on  the table
payload = {
            'install_status': 'Retired'
        }

################################
#### DO NOT EDIT BELOW HERE ####
################################

get_url = f"https://{instance_name}.service-now.com/api/now/table/{table_name}{query_url}"

# Set proper headers
headers = {"Content-Type":"application/json","Accept":"application/json"}

# Do the HTTP request
response = requests.get(get_url, auth=(sn_username, sn_password), headers=headers )

# Check for HTTP codes other than 200
if response.status_code != 200:
    print('Status:', response.status_code, 'Headers:', response.headers, 'Error Response:',response.json())
    exit()

# Decode the JSON response into a dictionary and use the data
data = response.json()

# Loop through returned results and update with payload
for device in data['result']:
    device_id = device['sys_id']
    patch_url = f"https://{instance_name}.service-now.com/api/now/table/{table_name}/{device_id}"

    # Save the result of the request in a variable
    result = requests.patch(patch_url,
                        json=payload,
                        headers=headers,
                        auth=(sn_username, sn_password))

    # print the sys_id and result
    print(f"sys_id: {device['sys_id']}, Result: {result},")