Obtaining Sharepoint Online List from SSIS

Ricardo Baptista 0 Reputation points
2025-04-21T11:55:37.9466667+00:00

Hello,

Trying to connect to a online sharepoint list using odata component but always getting 401 error, but my account is authorized to access it (if use URL on browser i can see it).

User's image

I know MFA is enabled, but only for out our internal network IPs.

User and Password has been verified multiple times and are correct.

Any idea or tests I could perform to identify what could be wrong?

Thanks

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,681 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.