Uploading a file to onedrive for business with Python

For a Raspberry Pi project that’ll take a number of pictures of my house for an as of yet unknown period of time I’m sharing my very first Python script with you.

All it has to do is upload all files from a given folder to a given Onedrive for Business path, as obviously the Pi can’t store much data on its tiny SD card. You’ll need to register an azure ad app and give it the appropriate permissions. You’ll have to consent to the application once (url format = https://login.microsoftonline.com/common/adminconsent?client_id={client-id}).

Then schedule below Python script on your Pi, it will retrieve an Azure token without the need for external libraries, parse the directory and upload everything in it to the given onedrive for business URL, simple as that! It can also be used for Sharepoint or Teams by adjusting the path.

import requests 
import json
directory = r"c:\temp\uploads"
data = {'grant_type':"client_credentials", 
URL = "https://login.windows.net/YOURTENANTDOMAINNAME/oauth2/token?api-version=1.0"
r = requests.post(url = URL, data = data) 
j = json.loads(r.text)
TOKEN = j["access_token"]
URL = "https://graph.microsoft.com/v1.0/users/YOURONEDRIVEUSERNAME/drive/root:/fotos/HouseHistory"
headers={'Authorization': "Bearer " + TOKEN}
r = requests.get(URL, headers=headers)
j = json.loads(r.text)
print("Uploading file(s) to "+URL)
for root, dirs, files in os.walk(directory):
    for filename in files:
        filepath = os.path.join(root,filename)
        print("Uploading "+filename+"....")
        fileHandle = open(filepath, 'rb')
        r = requests.put(URL+"/"+filename+":/content", data=fileHandle, headers=headers)
        if r.status_code == 200 or r.status_code == 201:
            #remove folder contents
            print("succeeded, removing original file...")
            os.remove(os.path.join(root, filename)) 
print("Script completed")
raise SystemExit
Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Most Voted
Newest Oldest
Inline Feedbacks
View all comments
5 months ago

Hi Jos

You can ingore my last comment 🙂
It works now, in see I don’t need a redirect URI, I also had a mistake in the URL.

Thanks again for your super script

5 months ago

Hi, thanks for sharing your script. I’m a beginner and I am not sure if I register my app correctly in Azure.

Could you please help me with this questions:

  • What Redirect_Uri do I need for this?
  • App Registration as “Desktop” and not as “Web” correct?
  • Is there an easy way to test only my app, if I set it correctly?

I really tried to find it out by myself (googling for long time), but I don’t get it 🙁

Thank you very much

5 months ago

{‘error’: {‘code’: ‘AccessDenied’, ‘message’: ‘Either scp or roles claim need to be present in the token.’, ‘innerError’: {‘date’: ‘2020-10-21T13:25:42’, ‘request-id
‘: ’23f377cd-f650-4d06-a0bd-759d65xxxx’, ‘client-request-id’: ’23f377cd-f650-4d06-a0bd-759d6588xxxx’}}}
I get this error can anyone please help me out.
I have successfully received the access token.

7 months ago

Hi, Im trying to execute the code but getting Internal server error in get request.

url used: URL = “https://graph.microsoft.com/v1.0/users/Christyece13@gmail.com/drive/root:/test_file_uploads”

Kindly help me to sort it out.I’m not sure if the URL im using is correct or not.

8 months ago

Hi, I tried to use this code to upload a single excel file to my onedrive, but the request status code was 400 and the file did not successfully upload. The excel file is in the same directory as the python file. I replaced the loop with this code: filename = ‘testfile.xlsx’ print(“Uploading….”) fileHandle = open(filename, ‘rb’) r = requests.put(URL+”/”+filename+”:/content”, data=fileHandle, headers=headers) fileHandle.close() print(r.status_code) if r.status_code == 200 or r.status_code == 201:    #remove folder contents    print(“succeeded”) Is it possible I used an incorrect URL? I used my email for YOURONEDRIVEUSERNAME and used the part of my email after the @… Read more »

10 months ago

I’m trying to use your script but I’m not uploading pictures, instead a simple plain/text file on OneDrive. The only minor change to the code I’ve made is adding this in the for loop(in the 23th line) for debugging purposes: h = json.loads(r.text) Now I get the following error triggered by the upload line(23): {'error': {'code': 'BadRequest', 'message': 'Write requests (excluding DELETE) must contain the Content-Type header declaration.', 'innerError': {'request-id': '7a12885b-d4c8-43ff-84af-11412d45676d', 'date': '2020-05-29T08:28:44'}}} I’ve tried to add an header (line 13) to specify the Content-Type of file but none of the following bring a succesfull upload: # headers={'Authorization': "Bearer " + TOKEN, 'Content-Type': 'multipart/form-data'} headers={'Authorization': "Bearer " + TOKEN, 'Content-Type': 'text/plain'} and they both trigger… Read more »

Last edited 10 months ago by lesec
11 months ago

I am using registered email id, but getting user not found, while calling upload api.
Please help, what i am i missing

Geoffroy Givry
Geoffroy Givry
1 year ago

Hi There, Many thanks for this tutorial!
I have one tiny (and stupid!) question. How to I get the
YOURONEDRIVEUSERNAME please? it sounds very silly but I’ve tried my login name from my email account geoff.gi@mycompanyname.onmicrosoft,com: geoff.gi
And it didn’t work. Did I miss anything?
Thanks a lot for your help!


1 year ago

Good stuff! The script completed successfully (status code 200) for my test files. Unfortunately the files are nowhere to be found in OneDrive for Business. Any idea what I am doing wrong? (Trying to upload to the root folder). Also, would you have pointers on how to limit the App’s access to only one specific folder (write only)? Thanks for sharing your script!

1 year ago

Short and sweet… Perfect

Gajendra Patidar
Gajendra Patidar
1 year ago

I’m not able to send big file like 25MB

Wa Wa
Wa Wa
1 year ago

Great script ! Thanks a lot