def main(): sdlc = 'dev' site_url = \ 'https://alterramtnco.sharepoint.com/:x:/r/teams/UDPDevTeam/MasterData/dev/access/lkpEntityLocation.xlsx?d=' \ 'w6788e8cf8c984cb3a5da58b7fe09b45c&csf=1&web=1&e=XKVdtd' # site_url = 'https://alterramtnco.sharepoint.com/:f:/r/teams/UDPDevTeam/MasterData/dev?csf=1&web=1&e=wlVsxo' # site_url = 'https://alterramtnco.sharepoint.com/:f:/r/teams/UDPDevTeam/MasterData/dev?csf=1&web=1&e=oZh6g1' # MasterData > Dev # site_url = 'https://alterramtnco.sharepoint.com/:f:/r/teams/UDPDevTeam/MasterData/dev?csf=1&web=1&e=Hb8FYE' # site_url = 'https://alterramtnco.sharepoint.com/:w:/r/teams/UDPDevTeam/MasterData/dev/Test.docx' \ # '?d=w0ad8c687dc9a4725a98b1d18953eb0ae&csf=1&web=1&e=UWAWMa' site_url = 'https://alterramtnco.sharepoint.com/teams/UDPDevTeam' # site_url = 'https://alterramtnco.sharepoint.com/:f:/r/teams/UDPDevTeam' ctx = ClientContext.connect_with_credentials( site_url, UserCredential('*****@*****.**', '4@Potatoes')) # web = ctx.web # ctx.load(web) # ctx.execute_query() # print("Web title: {0}".format(web.properties['Title'])) # list_obj = ctx.web.lists.get_by_title('MasterData') # folder = list_obj.rootFolder # ctx.load(folder) # ctx.execute_query() # print("List url: {0}".format(folder.properties["ServerRelativeUrl"])) # ServerRelativeUrl = "{0}".format(folder.properties["ServerRelativeUrl"]) # upload_file(ctx) # 'https://alterramtnco.sharepoint.com/:f:/r/teams/UDPDevTeam/MasterData/dev?csf=1&web=1&e=DRKVOw' read_folder_and_files(ctx, 'Form Templates') # read_all_folders(ctx) # print(ctx.get_lists()) download_file(ctx)
ListTemplateType.Contacts)) fake = Faker() for idx in range(0, 100): contact_properties = { 'Title': fake.name(), 'FullName': fake.name(), 'Email': fake.email(), 'Company': fake.company(), 'WorkPhone': fake.phone_number(), 'WorkAddress': fake.street_address(), 'WorkCity': fake.city(), 'WorkZip': fake.postcode(), 'WorkCountry': fake.country(), 'WebPage': { 'Url': fake.url() } } contact_item = contacts_list.add_item(contact_properties) context.execute_query() print("Contact '{0}' has been created".format( contact_item.properties["Title"])) if __name__ == '__main__': ctx = ClientContext.connect_with_credentials( "https://mediadev8.sharepoint.com/sites/team", UserCredential(settings['user_credentials']['username'], settings['user_credentials']['password'])) generate_contacts(ctx)
info.url = os.path.basename(path) info.overwrite = True target_file = target_folder.files.add(info) context.execute_query() print("File url: {0}".format(target_file.properties["ServerRelativeUrl"])) def download_file(context): path = "../../tests/data/SharePoint User Guide.docx" response = File.open_binary(context, "Shared Documents/SharePoint User Guide.docx") response.raise_for_status() with open(path, "wb") as local_file: local_file.write(response.content) if __name__ == '__main__': site_url = 'https://mediadev8.sharepoint.com/teams/DemoSite/' ctx = ClientContext.connect_with_credentials(site_url, UserCredential(settings['user_credentials']['username'], settings['user_credentials']['password'])) # upload_file(ctx) download_file(ctx) # get a source file located in library 'Shared Documents' # source_file = ctx.web.get_file_by_server_relative_url("/teams/DemoSite/Shared Documents/Guide.docx") # move a file into sub folder called 'Archive' # source_file.moveto("/teams/DemoSite/Shared Documents/Archive/Guide.docx", 1) # execute a query # ctx.execute_query()
def getMyDriveClient(tenant_name, user_principal_name, password): user_name = user_principal_name.split('@')[0] my_drive_url = "https://{0}-my.sharepoint.com/personal/{1}_{0}_onmicrosoft_com/".format(tenant_name, user_name) return ClientContext.connect_with_credentials(my_drive_url, UserCredential(user_principal_name, password))