Skip to Content
avatar image
Former Member

Access Sharepoint List via REST Web Service call in Data Services

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • May 22 at 04:19 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 18 at 10:21 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded