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))