SharePoint Input Record Limit

Question

When I run the SharePoint Input for a list I got an error 'list object has no attribute columns'. The tool works for one list, but not the other. The one that does not work has 50K records. Is there a limit to this tool and if so is there a workaround?

aatalai · Answer

@BMaisel have you tried to download the data and use the green input tool to read the data? See this article, it should help

Gaurav_Dhama_ · Answer

Hi @BMaisel

Recently Microsoft has changed the way you will authenticate to SharePoint, so my old code had to be updated.

I had to get the app registration done on Azure portal with Graph API permissions:

I used msal library to get authenticate and access SharePoint.

app = msal.ConfidentialClientApplication(
        "your_client_id_goes_here", 
        authority = "authority_goes_here",
        "client_secret_goes_here"
    )

result = app.acquire_token_for_client(scopes="https://graph.microsoft.com/.default")

then below URL gets the items inside the SP List

https://graph.microsoft.com/v1.0/sites/{site_id}/lists/{list_id}/items

BMaisel · Answer

Thanks @Gaurav_Dhama_  I tried doing python code, but couldn't get it to work. Do you have an example of code that worked for you to download from a SharePoint List.