sp_list.fields.add(field_payload).execute_query() has no attribute 'FieldTypeKind'

[garagonc]

I'm trying to add headers to an existing Sharepoint list but I received the error message: 'dict' object has no attribute 'FieldTypeKind'

The code I'm using is the following:

import pandas as pd from office365.sharepoint.client_context import ClientContext from office365.runtime.auth.user_credential import UserCredential

SharePoint credentials

USERNAME = username PASSWORD = password SITE_URL = site_url

Excel file path

EXCEL_FILE_PATH = excel_file_path

Existing SharePoint list name

EXISTING_LIST_NAME = "Listname"

def connect_to_sharepoint(site_url, username, password): """ Authenticate and connect to SharePoint. """ try: ctx = ClientContext(site_url).with_credentials(UserCredential(username, password)) print(f"Connected to SharePoint site: {site_url}") return ctx except Exception as e: print(f"Error connecting to SharePoint: {e}") return None

def add_missing_columns(sp_list, df_columns, existing_field_names): """ Add missing columns to the SharePoint list based on the Excel file headers. """ for column in df_columns: if column not in existing_field_names: print(f"Adding missing column '{column}'...") try: # Define the field payload field_payload = { "__metadata": {"type": "SP.FieldText"}, "Title": column, "FieldTypeKind": 2, # 2 corresponds to 'Text' field type } sp_list.fields.add(field_payload).execute_query() print(f"Column '{column}' created successfully.") except Exception as e: print(f"Error creating column '{column}': {e}") else: print(f"Column '{column}' already exists. Skipping...")

def main(): """ Main function to execute the SharePoint data upload process. """

# Connect to SharePoint
ctx = connect_to_sharepoint(SITE_URL, USERNAME, PASSWORD)
if ctx is None:
    return

try:
    # Access the existing SharePoint list
    sp_list = ctx.web.lists.get_by_title(EXISTING_LIST_NAME)
    print(f"List '{EXISTING_LIST_NAME}' exists. Validating and adding columns...")

    # Retrieve existing fields in the SharePoint list
    existing_fields = sp_list.fields.get().execute_query()
    print("Got existing fields")
    existing_field_names = [field.properties["Title"] for field in existing_fields]

    print(f"Existing fields in the list: {existing_field_names}")

    # Add missing columns dynamically
    add_missing_columns(sp_list, df.columns, existing_field_names)


except Exception as e:
    print(f"Error: {e}")

if name == "main": main()