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 Mike Lewis 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

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





 
 https://files.engineering.com/getfile.aspx?folder=a02a4eae-7b0c-4560-abc4-e97189ef3d4b&file=ODataConnection.PNG
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top