Get SharePoint List Item

Questions
1

Hi, my goal is to get a SharePoint list item.

  • I am the admin of the SharePoint Tenant but it has 2FA enabled.
  • Setting up the SharePoint node fails (Error: Insufficient parameters for OAuth2 callback) when setting up the credentials.
  • There is only 1 field when setting up the credentials being the SharePoint ‘Subdomain’ so there’s not a lot of config options.
  • ChatGPT says one approach is to register my site as an app (in Azure AD) and create a ‘secret’ etc etc… which I can do… BUT I read that external secrets can only be used with an n8n Enterprise Plan.

Is there an easy-ish process to setting up SharePoint credentials (that handle 2FA) ?

Thanks.

2

You could use anHTTP Request node instead, with an Application Type (<-- click link to go to a previous post with details) credential for access to sharepoint instead of a delegated type. I don’t think that should involve any 2FA steps.

If you need to do the delegated type of credential, I’m not sure how the 2FA requirement affects it. I would think that’s just an extra step when you connect a user on the credential.