Skip to Content
0

Access Sharepoint List via REST Web Service call in Data Services

May 10, 2017 at 02:46 PM

144

avatar image
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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Arun Sasi May 22 at 04:19 AM
0

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-21bc25e66952

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

Hope this is useful

Regards

Arun Sasi

Share
10 |10000 characters needed characters left characters exceeded
Jairzinho Bonilla May 18 at 10:21 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded