title: Get SharePoint List with Python
body: <p>I am trying to find any way possible to get a SharePoint list in Python. I was able to connect to SharePoint and get the XML data using Rest API via this video: <a href="https://www.youtube.com/watch?v=dvFbVPDQYyk" rel="noreferrer">https://www.youtube.com/watch?v=dvFbVPDQYyk</a>... but not sure how to get the list data into python. The ultimate goal will be to get the SharePoint data and import into SSMS daily. </p>
  
  <p>Here is what I have so far..</p>
  
  <pre><code>import requests
  from requests_ntlm import HttpNtlmAuth
  url='URL would go here'
  username='username would go here'
  password='password would go here'
  r=requests.get(url, auth=HttpNtlmAuth(username,password),verify=False)
  </code></pre>
  
  <p>I believe these would be the next steps. I really only need help getting the data from SharePoint in Excel/CSV format preferably and should be fine from there. But any recommendations would be helpful..</p>
  
  <pre><code>#PARSE XML VIA REST API
  #PRINT INTO DATAFRAME AND CONVERT INTO CSV
  #IMPORT INTO SQL SERVER
  #EMAIL RESULTS
  </code></pre>