topic get data from sharepoint folder/link using python script in Developer

get data from sharepoint folder/link using python script

neldarov — Mon, 26 Aug 2019 04:53:30 GMT

I need to have a new script in Power BI and let it read all files that I have inside this folder. How can I do that? What is folder in sharepoint?

The most simple code to do this task:

import pandas as pd

# data loading and processing
path = "C:\\Users\\nelda\\Documents\\Projects\\project1\\dataset.csv"
dataset = pd.read_csv(path)

However I am not sure how to do that for sharepoint.

Re: get data from sharepoint folder/link using python script

Greg_Deckler — Fri, 23 Aug 2019 12:22:58 GMT

Potentially could just use the web url for the file in SharePoint. Otherwise, perhaps this will be of assistance:

https://stackoverflow.com/questions/20945822/how-to-access-a-sharepoint-site-via-the-rest-api-in-python

Re: get data from sharepoint folder/link using python script

neldarov — Mon, 26 Aug 2019 05:56:41 GMT

Thanks but that doesn't work, 403 error message. That actually does not work for many people.

Re: get data from sharepoint folder/link using python script

jonm818 — Wed, 05 May 2021 00:22:15 GMT

in the sharepoint folder there is an option to select "Sync". This creates a folder in your computer. You can use that folder to create a path like you would with any other folder located in your computer