Getting Data In

How to connect to external lookup using Python script?

nnimbe1
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

jpass
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
Get Updates on the Splunk Community!

Enhance Your Splunk App Development: New Tools & Support

UCC FrameworkAdd-on Builder has been around for quite some time. It helps build Splunk apps faster, but it ...

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...