CODEWITHSUNDEEP
sql-serversharepointssisetlsharepoint-online
alex
alex

Reputation: 41

How to use Sharepoint REST API in SSIS

I am new to Sharepoint Online API and I would like to extract data from a Sharepoint list using a SSIS flow. I tried to do this using OData Source, using the URL:

http://name.sharepoint.com/sites/l/_vti_bin/ListData.svc but I am not able to see all the properties of list items.

So now I would like to try using the REST API:

http://name.sharepoint.com/sites/l/_api/web/lists. but the issue is that this link is not working in SSIS.

Is there any possibility to do this using SSIS objects (not code)?

Upvotes: 4

Views: 2227

Answers (1)

Hadi
Hadi

Reputation: 37313

You can simply use the Sharepoint List adapter components which are an open source project created by SQL Server community within a project called MSSQL SSIS Community:

You can check the project page at the following link:

Or you can simply download the assemblies from the link below:

You can read more about this components in the following link:

Upvotes: 1

Related Questions