Statement : POST/Upload a file from mid-server to ServiceNow Instance.
Use Case: Many time there are requirements to process files/data securely from mid-server into servicenow instance. E.g. encrypted user information from other platforms such as workday.
There are multiple options to process external files into ServiceNow but I found attachment API approach is more efficient in terms of processing & security.
Other option to python: PowerShell, ShellScript, cURL
import requests, sys, os
import pprint
import json, base64
try:
#If input data is encoded.
#input_data = json.loads(base64.b64decode(sys.argv[1]).decode('ascii'))
endpoint = "https://<host>.service-now.com/api/now/attachment/upload"
username = "username"
password = "password"
filename = 'ExampleFile.csv' // File Name with extension
filepath = 'ExampleDir/ExampleFile.csv'
//FilePath defaulted to midserver/agent as script run in current folder.
filetype = 'csv' // csv, xlxs, pdf, doc
tablename = "sys_data_source". // Target ServiceNow table name
tablesysid = 'sys_id' //Record SysId where attachment needs to be posted.
# Set the request parameters
url = endpoint
# Open & Read file from location
files = {"file": (filename, open(filepath, "rb"), filetype)}
# Set proper headers
headers = {"Accept":"*/*"}
# Request Payload
payload = {"table_name": tablename,"table_sys_id": tablesysid}
# Do the HTTP request
response = requests.post(url, auth=(username, password),data=payload, headers=headers, files=files)
#print(response.json())
# Check for HTTP codes other than 201
if response.status_code == 201:
#print('Status:', response.status_code, 'Headers:', response.headers, 'Error Response:',response.json())
output['status_code']=response.status_code
output['status']="success"
output['response']=response.json()
else:
#print('Status:', response.status_code, 'Headers:', response.headers, 'Error Response:',response.json())
output['status_code']=response.status_code
output['status']="failed"
output['response']=response.json()
// Error handler - can be modified as per need.
except ValueError:
#print("Error"+ValueError.with_traceback),
output['status_code']=401
output['status']="failed"
output['response']=ValueError.with_traceback
Simple way to call python script in IntegrationHub
- PowerShell Step -- If Windows hosted mid-server
- SSH -- if Linux hosted mid-server
Argument to python script is optional. It depends how you want to handle inputs to the flow action.
Soon will post another article on how to copy PGP encrypted files from SFTP to mid-server and decrypt those files using python.
