Python Bite - upload file to Sharepoint Online with Python

[@TheNishi42]

Hi Can you tell how to download the file from sharepoint.

[@lsteveol]

I rarely comment on YT vids, but this one deserves it. Worked well, thanks for sharing.

[@radoslawszwarc]

Thanks mate!

[@krishna-rk1nh]

Hi , how to download a file from a share point.

[@joshi24036]

Could you also tell us how to download a file from share point. Please make a video or share the code. Thanks in advance.

[@blizzbitz]

The files does not appering in the folder

[@ramonabreu4266]

Thanks for this video, it is of tremendous help. I have a quick question; what is the difference between the "sp_site_name" and the "sp_doc_library"? what goes in each one in your example? it seems the doc_library is the actually folder you want your document to be uploaded to, but the site_name I am not sure what goes here. Thanks in advance for your response

[@sandrakusnir]

also need help with this

[@SJ-qq2dq]

My code executes fine but the file does not appear in the folder. Possibly a checkin issue? How con we enforce a check-in after the upload?

[@blizzbitz]

Same here

[@ryanroline7181]

Hello! I followed this tutorial exactly and when I run the script it succeeds without an error like you showed in the video; however, the file does not appear within the document library. Without an error it is really hard to troubleshoot. I have already rechecked the site URL and folder destination along with user permissions to that folder. Any ideas?

[@JHJ5288]

Thank you so much for this video! True life-saver :)

[@priyashegokar5017]

I want to upload excel file and follow your code I don't get any error but in share point folder there is no file please sir can you help me

[@jakeg9711]

Thanks for the video, would we also be able to see how to download files from a Sharepoint list? Thanks :)

[@homanjj3]

Thank you Python Bites. How would I upload to a sub directory of the document library?

[@radoslawszwarc]

You would have cycle through files in folders, and upload one by one using nested loop. You can have a look at os.walk('path_to_folder')

[@boomikauba5232]

Could you please give us the link to how to upload files to document library using client id client secret ??

[@pythonbites2244]

Hi Guys, documentation on "uploading" files can be found here: learn.microsoft.com/en-us/graph/api/driveitem-put-content?view=graph-rest-1.0&tabs=http

[@acomathes]

Your patreon page seems empty... I'd really love to have access to your code.

[@pythonbites2244]

Hi Ahmet, yeah, I was looking if people are going to the patreon page to get code, but there were no entries, so I didn't post much there. Maybe I will post some interesting stuff there if it will get some traction.

[@pythonbites2244]

I just noticed, that Patreon "unlaunched" my site, so it was not even accessible. Would be good if they would notify me about that. If you want code for this video, it should be now available for download

[@mysteryhogs2028]

How about if you are using Single Sign On instead of Username/Password ? any advise? this is so helpful. Answer please

[@radoslawszwarc]

I would have to look into it. I cannot promise I will do it.

[@mysteryhogs2028]

@@radoslawszwarc 😂 python using username and password is easy no coding required using Curl command but doesnt work with SSO 😂 In PowerShell this is easy too... but what i wanted to do is from linux using python to SP site to upload files

[@AmadoRodrigoRodriguezHeras]

Has the class changed or something like that? When executing the code, it shows the error: KeyError: 'x-requestdigest'

[@poloperson4072]

How would you upload associated meta data along with the file?

[@Fireheadman]

used your code.... however I believe this will not work for a federated sharepoint site? would you happen to have any experience with that?

[@praveenmeruga1220]

@Python Bites, I don't have access to domain, but I have access to sub folders. From code I'm getting authentication error, can you please tell me however shall I proceed now.

[@SatyamKumar-pi6pj]

What is the maximum file size that can be uploaded?

[@jeanrodriguez1186]

Hi, Is it possible to reference a different file path for the file_name ie. C:\user\documents\myfile.txt ? Every time i try to enter a full file path in the file name the fails. Thank you

[@Nico-hf6hw]

But this is only for sharepoint 365 right? and not for Sharepoint online/on-premise?

[@itamarmenezesdasilva6779]

Thanks for helping us

[@joshi24036]

Hi, I am getting below error, can anyone help? session.headers.update({'X-RequestDigest': response.headers['X-RequestDigest']}) return self._store[key.lower()][1] KeyError: 'x-requestdigest'

[@sandrakusnir]

I need help with this too

[@RaviYadav-bu2pg]

Hi, Nice video, I am facing one issue, trying to download files from sharepoint through REST API but token gets expire in 1 hour, do you know any way to get refresh token for a long time like years, I am using Microsft graph.

[@vaibhavagrawal9059]

Hi Ravi, I am also looking for the code to download the files from SharePoint, if you can mail me that code .. it will be helpful.. Mail id: [e-mail] Please respond here as well Thanks

[@1lazyworld]

you failed to censor the video ar 4:55, when you tried so hard at every other time you showed the webpage. Why?

[@radoslawszwarc]

my mistake, I have to cover it as well. Thanks for pointing it out, I must have missed it.

[@暐陳-b2m]

I want to update to specific Sharepoint file but don't want to overwrite the excel file, what I want is update the sheet1 in excel file. Ex, upload file test.xlsx to Sharepoint and won't replace the test.xslx but update the data in sheet1 of test.xslx. How to do it? Thx for your help!

[@samson_afolabi]

I have exactly this same problem, could you share with me how you were able to solve this.

[@yipengtang957]

Looks like you hard coded your username and password in the config file. How can we use default windows login information for auth so that username and password will not be needed?

[@radoslawszwarc]

This is more "universal way' it works on both Linux and Windows. On Windows I'm sure you can get "username" via os.getuid() or os.getlogin(), however I'm sure password cannot be obtained. You would have to get a token from "Office365" single sign on (or something like that).

[@nelsonai5481]

can you send me the code? the links you provided are not working and there are parts in the video where you did not scroll to the right to see the entire code.

[@pythonbites2244]

True, I have turned off this web site. I will be using something "free" to post code. I will upload it to "Patreon" and will share you a link soon.

[@pythonbites2244]

You can find this code here: www.patreon.com/posts/39879423

[@weirdweirdman6155]

what is in the config file though

[@Coolmadi]

This code will not work if my company account has MFA enabled right?

[@YogBar]

It won

[@暐陳-b2m]

If your company account has MFA enabled, you have to build the App_password to replace your account's pwd. My code work nice and tight.

[@rajgrg01]

​@@暐陳-b2m​ App password - you mean normal app password, or we need to register app & get secret?

[@暐陳-b2m]

raj grg For example like this one dms-shuttle.com/documentation/connect-sharepoint-office-365-multi-factor-authentication-mfa/

[@omoladeariyo3295]

The config.py file you referenced is not included. Thank you for the information.

[@rajd26]

I wan to read excel file(with 3 sheets) present in Sharepoint path, also wan tto read only 3rd tab in pandas dataframe and then post those records in snowflake

[@pythonbites2244]

Well, here you have to do couple of different things... 1) log into sharepoint 2) download file 3) open with pandas -> df = pandas.read_excel( file, sheet_number=2) 4) prepare df (dataframe) to be loaded into DB 5) insert or update in snowflake.

[@rajd26]

@@pythonbites2244 Thanks.. Below is link looks like for sharepoint file, what should be there in config file for config['sp_base_path'] , config['sp_site_name'] and config['sp_doc_library'] companyname.sharepoint.com/sites/IT/EIA/ENTINT/information_movement/System%20Documentation/Support/COGNOS/Cognos%20Support/Team_oncall_log.xlsx

[@vr-oo7uv]

Hi I am getting error raise Exception('Check username/password and rootsite') Exception: Check username/password and rootsite. But i have given everything correct path and username and password but it throws error at first level of checking the cookies. It think it is autentican issues and please can you clearly explain what is sp_base_path, sp_site_name, sp_doc_library in sharepoint link, which one i need to segregate it.

[@vasavigoudbojja]

Even am facing the same 'check username/password and rootsite' exception. can some one help with this . thanks in advance

[@radoslawszwarc]

on this site: pythonbite.tech/11-blog/python-advanced/4-uploading-files-to-sharepoint you have: config = dict() config['sp_user'] = '[e-mail]' config['sp_password'] = 'Passw0rd' config['sp_base_path'] = 'example.sharepoint.com' config['sp_site_name'] = 'my_site_name' config['sp_doc_library'] = 'PythonUploader' This is very clear and precise, where to use slashes etc. Will be hard to help you without knowing what you have put in the config.py file.

[@krishna-rk1nh]

@@radoslawszwarc Can i get your mail id please

[@angeleong23]

@@radoslawszwarc may I know how to get 'sp_site_name'?

[@islauddinmohammed8220]

I am trying to download files from Sharepoint. But getting the below error message... Exception: ('Error authenticating against Office 365. Error from Office 365:', 'AADSTS53003: Access has been blocked by Conditional Access policies. The access policy does not allow token issuance.') Any suggest what might be missing or how to bypass this?

[@franmer7]

Thats a security policy set up on infrastructure level in your company. Contact your infra team because maybe they can remove that restriction for your specific use case.

[@93RCOral]

Hey thanks so much !!!

[@ravivenkatatejamucharla1802]

Hi, can u pls let us know how to do this with client id and secret key

[@pythonbites2244]

I have recorded another video how to connect to Microsoft Graph using python msal library. You can try it from there, but the API calls will be different.

[@rafael-ksouza]

Thanks a lot! God bless u

[@marcozacaria3371]

Hi Sir , thank you for the great video. I am getting this error: raise Exception('Error authenticating against Office 365. Error from Office 365:', message[0].text) Exception: ('Error authenticating against Office 365. Error from Office 365:', 'AADSTS50056: Invalid or missing password: password does not exist in the directory for this user.') i would really appreciate your help

[@odiionhongo7885]

anyone knows how to put a comment when i upload a file?

[@pythonbites2244]

I haven't tried that unfortunately :/

[@RavianXReaver]

Sharepoint has the worst api ever build

[@krishna-rk1nh]

can anybody Please respond it. About the error I am getting.

[@radoslawszwarc]

on this site: pythonbite.tech/11-blog/python-advanced/4-uploading-files-to-sharepoint you have: config = dict() config['sp_user'] = '[e-mail]' config['sp_password'] = 'Passw0rd' config['sp_base_path'] = 'example.sharepoint.com' config['sp_site_name'] = 'my_site_name' config['sp_doc_library'] = 'PythonUploader' This is very clear and precise, where to use slashes etc. Will be hard to help you without knowing what you have put in the config.py file.

[@krishna-rk1nh]

@@radoslawszwarc what should i need to place in this line---> config['sp_site_name'] = 'my_site_name'

[@pythonbites2244]

@@krishna-rk1nh Let's say that this is a full address of a site: some_site.sharepoint.com/sites/p2p/SitePages/Home.aspx. In this case, you would have to put 'p2p' under this variable name. So config['sp_site_name'] = 'p2p' in this case.

[@krishna-rk1nh]

@@pythonbites2244 Thank you so much

[@vaibhavagrawal9059]

hello thanks for this, what if I want to download multiple folders and files from sharepoint to local fileshare? If anyone can help me for the same that would be very helpful. Please help me

[@xali2008]

is there a reason to use this instead of Microsoft Graph?

[@pythonbites2244]

Would you be so kind to point to the Microsoft Graph API that is capable to upload a file to a SharePoint Document Libraty?

[@manavsingh1160]

No you can't it's wrong code

[@ArunKonkati]

ImportError: cannot import name 'config' from 'config' (/usr/local/lib/python3.8/dist-packages/config/__init__.py) - can you please help me why Im i getting this?