Access Sharepoint List via REST Web Service call in Data Services

[Former Member]

Hi,

I have a request at my hand to design a data services job, to connect and copy the data from a Share Point List to a table in a database, using a REST Web Service call to that list.

I have tried many options but could not successfully load the data. Are there any other options, to load the data from sharepoint list (automatically and not manually) to a table using data services?

[former_member198401]

Jonathan,

Here's a trick.

Refer to the below site for exporting the contents of Sharepoint List to Excel File.

https://support.office.com/en-us/article/export-an-external-list-to-excel-fcbb5cdc-cf49-4131-8294-21...

Next step is use the Excel files as an Input to Data Services

Hope this is useful

Regards

Arun Sasi

[Former Member]

if you are allowed to use a different tool. SSIS has an out of the box connector to SharePoint lists.

it's relatively easy to connect SSIS to the list, create a flat file as a destination, and later if you really want to use BODS, you can read the flat file to write the info into a database.

I did this long time ago when BODS web service connection was kind of immature and I was running out of options.