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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...

Move CrowdStrike FDR ingestion to Data Inputs with a guided migration

CrowdStrike Falcon Data Replicator data is essential for security investigations, detections, and response. It ...

Make Your Machine Data AI-Ready in Splunk

Every team is getting ready for AI agents.    Watch On-Demand   In this Tech Talk, Splunk platform specialists ...