Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations sizbut on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SharePoint Online-Reading/Access Lists-Using SSIS -OData Connection- Error 401 Unauthorized 1

Status
Not open for further replies.
BTrees

BTrees

IS-IT--Management
Aug 12, 2006
45
CA
Hi
I am trying to connect with Lists data on Sharepoint online. I am working in SSIS-Visual Studio 2017 and using Odata datasource connector.
I have installed SDK-2013 as well and followed all the instruction on blogs on this topic. But I am getting error , TITLE: OData Connection Manager Editor
Test connection failed. The remote server returned an error: (401) Unauthorized. (System)
I can access service document location and can see XML. Need help to get this working. Thanks


ODataConnection_y2dkdf.png





 
Status
Not open for further replies.

Similar threads

Erichss
  • Locked
  • Question
Sharepoint Column Formatting Assistance
Replies
0
Views
719
Erichss
Erichss
FuzzyCub
  • Locked
  • Question
SharePoint Online Multiple Views on One Page
Replies
0
Views
641
FuzzyCub
FuzzyCub
365user
  • Locked
  • Question
Sharepoint Online Tasks List 1
Replies
1
Views
966
Maxwell454
Maxwell454
Howesjaybird
  • Locked
  • Question
Syncing file server to sharepoint
Replies
1
Views
710
James Hauge
James Hauge
markdmac
  • Locked
  • Question
How to get a Document URL via PowerShell & SharePoint Online
Replies
0
Views
564
markdmac
markdmac

Part and Inventory Search

Sponsor

Back
Top