Office365-REST-Python-Client
Office365-REST-Python-Client copied to clipboard
vgrem
Failure to upload dataframe to SharePoint List
All of scripts writing Dataframes to a Sharepoint list are now all failing.
Here is a sample of the upload script:
Username = "username" Password = "password" site_url = 'https://company.sharepoint.com/sites/TEST/' ctx = ClientContext(site_url).with_credentials(UserCredential(user_name=Username, password=Password)) list_title = 'Provider_Master' view_title = 'All Items' page_size = 5000
list_action = ctx.web.lists.get_by_title(list_title) items = list_action.items.get().top(page_size).execute_query()
ctx.load(list_action) for index, row in df.iterrows(): print(row['MAPPING_SOURCE'], row['BUSINESS_UNIT_NAME'],row['PROVIDER_NPI'],row['PROVIDER_NAME'],row['NETSUITE_PROVIDER_ID'],row['NETSUITE_PROVIDER_NAME'] ,row['NETSUITE_LOCATION_ID_LEGACY'],row['NETSUITE_LOCATION_NAME_LEGACY'],row['NETSUITE_LOCATION_ID'],row['NETSUITE_LOCATION_NAME'],row['LEGACY_PROVIDER_NAME'] ,row['PROVIDER_TYPE'],row['SENIOR_DATE'],row['SBU'],row['DHS_POD'],row['HEALIX_PROVIDER_NAME'],row['HEALIX_NETSUITE_LOCATION_ID_LEGA'],row['HEALIX_NETSUITE_LOCATION_NAME_LE'] ,row['HEALIX_NETSUITE_LOCATION_ID'],row['HEALIX_NETSUITE_LOCATION_NAME'],row['NETSUITE_PLATFORM_ID'],row['NETSUITE_SUBSIDIARY_ID_LEGACY'],row['NETSUITE_SUBSIDIARY_ID'] ,row['DIVISION'],row['CITY'],row['PAYCOM_NAME'],row['PRIMARY_TAXONOMY'],row['PRIMARY_TAXONOMY_DESCRIPTION'],row['CORRECT_NAME'] ) list_action.add_item({'MAPPING_SOURCE': row['MAPPING_SOURCE'],'BUSINESS_UNIT_NAME': row['BUSINESS_UNIT_NAME'],'PROVIDER_NPI': row['PROVIDER_NPI'] ,'PROVIDER_NAME': row['PROVIDER_NAME'],'NETSUITE_PROVIDER_ID': row['NETSUITE_PROVIDER_ID'],'NETSUITE_PROVIDER_NAME': row['NETSUITE_PROVIDER_NAME'] ,'NETSUITE_LOCATION_ID_LEGACY': row['NETSUITE_LOCATION_ID_LEGACY'], 'NETSUITE_LOCATION_NAME_LEGACY': row['NETSUITE_LOCATION_NAME_LEGACY'] ,'NETSUITE_LOCATION_ID': row['NETSUITE_LOCATION_ID'], 'NETSUITE_LOCATION_NAME': row['NETSUITE_LOCATION_NAME'],'LEGACY_PROVIDER_NAME': row['LEGACY_PROVIDER_NAME'] ,'PROVIDER_TYPE': row['PROVIDER_TYPE'],'SENIOR_DATE': row['SENIOR_DATE'],'SBU': row['SBU'],'DHS_POD': row['DHS_POD'],'HEALIX_PROVIDER_NAME': row['HEALIX_PROVIDER_NAME'] ,'HEALIX_NETSUITE_LOCATION_ID_LEGA': row['HEALIX_NETSUITE_LOCATION_ID_LEGA'],'HEALIX_NETSUITE_LOCATION_NAME_LE': row['HEALIX_NETSUITE_LOCATION_NAME_LE'] ,'HEALIX_NETSUITE_LOCATION_ID': row['HEALIX_NETSUITE_LOCATION_ID'],'HEALIX_NETSUITE_LOCATION_NAME': row['HEALIX_NETSUITE_LOCATION_NAME'] ,'NETSUITE_PLATFORM_ID': row['NETSUITE_PLATFORM_ID'],'NETSUITE_SUBSIDIARY_ID_LEGACY': row['NETSUITE_SUBSIDIARY_ID_LEGACY'],'NETSUITE_SUBSIDIARY_ID': row['NETSUITE_SUBSIDIARY_ID'] ,'DIVISION': row['DIVISION'],'CITY': row['CITY'],'PAYCOM_NAME': row['PAYCOM_NAME'],'PRIMARY_TAXONOMY': row['PRIMARY_TAXONOMY'],'PRIMARY_TAXONOMY_DESCRIPTION': row['PRIMARY_TAXONOMY_DESCRIPTION'] ,'CORRECT_NAME': row['CORRECT_NAME']}) ctx.execute_batch()
ClientRequestException: ('-1, System.UriFormatException', 'Invalid URI: The Uri string is too long.', '500 Server Error: Internal Server Error for url: https://company.sharepoint.com/sites/Site/_api/$batch')
I have confirmed that the above code works perfectly using version 2.3.1.
