Skip to main content

Automation of some processes on office365

Project description

Automation of some processes on office365



Require : pip install Office365-REST-Python-Client



1. Create session user


from onedrive_sharepoint.main import OneDrive

email = "XXXXXXXXXXXXXXXXXXXXXX"
password = "XXXXXXXXXXXXXXXXXXXXXX"
endpoint = "https://<tenant_name>.sharepoint.com/personal/<username>" (for onedrive)
type = "onedrive"

session = OneDrive(email=email, password=password, endpoint=endpoint, type=type)

type takes the values "onedrive" and "sharepoint"



2. Get folders

folders = session.get_folders()

for folder in folders:  

    print(folder.name)

Folder Properties

To see all the properties of a file, use the properties attribute. For example

    print(folder.properties) 

output

{
    'Exists': True,
    'IsWOPIEnabled': False,
    'ItemCount': 0,
    'Name': <folder_name>,
    'ProgID': None,
    'ServerRelativeUrl': '/personal/<tenant>/Documents/<folder_name>',
    'TimeCreated': '2022-10-10T12:58:09Z',
    'TimeLastModified': '2022-10-10T12:58:09Z',
    'UniqueId': '16636378-fd57-4456-9e0f-1331d62f1385',
    'WelcomePage': ''
}



3. Get files

files = session.get_files()

print(*files, seq="\n")

File Properties

{
    'CheckInComment': '',
    'CheckOutType': 2,
    'ContentTag': '{263E029D-372D-476B-9609-1F84D2C9B578},1,1',
    'CustomizedPageStatus': 0,
    'ETag': '"{263E029D-372D-476B-9609-1F84D2C9B578},1"',
    'Exists': True,
    'IrmEnabled': False,
    'Length': '36653',
    'Level': 1,
    'LinkingUri': '<tenant>/Documents/<filename>.csv?d=w263e029d372d476b96091f84d2c9b578',
    'LinkingUrl': '<tenant>/Documents/<filename>.csv?d=w263e029d372d476b96091f84d2c9b578',
    'MajorVersion': 1,
    'MinorVersion': 0,
    'Name': 'KOLDA.csv',
    'ServerRelativeUrl': '/personal/<tenant>/Documents/<filename>.csv',
    'TimeCreated': '2022-10-07T12:32:38Z',
    'TimeLastModified': '2022-10-07T12:32:38Z',
    'Title': None,
    'UIVersion': 512,
    'UIVersionLabel': '1.0',
    'UniqueId': '263e029d-372d-476b-9609-1f84d2c9b578'
}



4. Create folder

session.create_folder(folder_name)



5. Download files from folder

session.download_file(folder_name)



6. Upload files local to [onedriver or sharepoint] folder

session.upload_files_on_folder(path_folder_name_local, folder_name_online)

Upload single file on OneDrive|SharePoint

session.upload_file_on_folder(path_file_name_local, folder_name_online)



7. Share folder with Anonymous

session.share_folder(<folder_name>)

output

Link like this => https://<tenant>.sharepoint.com/:f:/g/personal/<username>/EnhjYxZX_VZEng8TMdYvE4UB78vdTFHSEs3vc5FgqQ1A8Q

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

onedrive-sharepoint-0.1.14.tar.gz (4.8 kB view details)

Uploaded Source

Built Distribution

onedrive_sharepoint-0.1.14-py3-none-any.whl (5.2 kB view details)

Uploaded Python 3

File details

Details for the file onedrive-sharepoint-0.1.14.tar.gz.

File metadata

  • Download URL: onedrive-sharepoint-0.1.14.tar.gz
  • Upload date:
  • Size: 4.8 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.8.10

File hashes

Hashes for onedrive-sharepoint-0.1.14.tar.gz
Algorithm Hash digest
SHA256 ade96b7b4c7f09852aba885cb60cd107b947abcb0eec1eca2a36ac90a398abed
MD5 6364507d9db4738d82c73141eb132a3d
BLAKE2b-256 333fc8d4805a469a52e4308d5093a107845762d8fad0bb2e6442ac0c8fb57887

See more details on using hashes here.

File details

Details for the file onedrive_sharepoint-0.1.14-py3-none-any.whl.

File metadata

File hashes

Hashes for onedrive_sharepoint-0.1.14-py3-none-any.whl
Algorithm Hash digest
SHA256 bbcdcd29e583fdeaf61e728b7838faa370a6022de0dcf6550e1f923b8c106e57
MD5 62dbee2e1735c6a7f586b20ef1f55a48
BLAKE2b-256 f182ee74f7c3c6bd6f476c7844574ec329e62359c26e6c413103da0ce48696b1

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page