def Lists(Sp):
site = Site(
f'https://foundationriskpartners.sharepoint.com.us3.cas.ms/sites/{Sp}/',
authcookie=authcookie,
huge_tree=True)
# mylist = site.List(li)
li = site.GetListCollection()
# df = pd.DataFrame(li)
# df.to_excel('bidash_lists.xlsx', index=False)
mylists = [l['Title'] for l in li]
secur = {l['Title']: l['InheritedSecurity'] for l in li}
readSecurity = {l['Title']: l['ReadSecurity'] for l in li}
Allowance = {l['Title']: l['AllowAnonymousAccess'] for l in li}
depends = {}
cols = ['Business', 'Operating', 'Deal', 'DataSource']
# Get all list that have dependencies
for lis in mylists:
temp = []
try:
mylist = site.List(lis)
data = mylist.GetListItems('All Items', rowlimit=1)[0]
for col in cols:
if any(col in s for s in data.keys()):
temp.append(col)
if len(temp) != 0:
depends[lis] = temp
except Exception as e:
print(e)
print(depends)
# lookupFields = ['BusinessUnit', 'OperatingUnit', 'DealName', 'FRPS_DataSourceSK']
# for item in mydata:
# if 'Name' in item:
# item['Name_'] = item.pop('Name')
# for it in lookupFields:
# item[it]= lookupFormat(item[it])
print(f'updating Sharepoint List... : {_SPL}....')
# Connecting to the destination sharepoint list with try
print(mydata[0])
try:
site = Site(
f'https://foundationriskpartners.sharepoint.com.us3.cas.ms/sites/{_SP}/',
authcookie=authcookie)
except Exception as e:
print(e)
# print(site.GetListCollection()[0])
# Writing data to sharepoint list from sql
# reading the the desitination Sharepoint list
mylist1 = site.List(_SPL)
data1 = mylist1.GetListItems('All Items')
lists = [item['Title'] for item in site.GetListCollection()]
# Retreiving all IDs of the list if it not empty
# ids = [item['ID'] for item in data1]
# Delete all items from the sharepoint list by IDs
# mylist1.UpdateListItems(ids, kind='New')
# Adding the new Data to the sharepoint list
mylist1.UpdateListItems(data=mydata, kind='Update')
print(f'---------------Done -------------')
