Getting Data In

How to connect to external lookup using Python script?

Path Finder

We were using below script to connect and download csv and store it in folder. But now website has changed and it asks for the username and password. Can somebody suggests any required changes where we can connect to URL, Authenticate with username and password, and download the file?

import os

import urllib2

response = urllib2.urlopen('URL')

data = response.read()

filename = os.path.join(os.environ['SPLUNK_HOME'], 'etc', 'apps', 'SPLAPP', 'lookups', "Splunk_Monitored_Hosts.csv")

file_ = open(filename, 'w')

file_.write(data)
#file_.close()
0 Karma

Contributor

I know this is a bit old but here's how I authenticate with Basic HTTP Auth:

import requests
from requests.auth import HTTPBasicAuth

username = "<user>"
apikey = "<pass>"
apiurl = "<theurlyouconnectto>"

with requests.Session() as s:
    s.auth = (username,apikey)
    r = s.get(apiurl)    
0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!