Accessing and updating sharepoint list using SOAP/REST

Question

I have been searching and researching a problem I have been tasked with for a few days and figured now is the time to ask for help. I am a C# Application developer and have the following task.

In my data center, I have a SQL database full of information.

On another network at another installation, there is a Sharepoint site, I do not administer the site but do have admin privileges to read and write.

What I am hoping to accomplish is to write an application or a job that will take data from my SQL database and update the sharepoint list (again on another network).

The list is located on a URL like https://MYSITE/DIR/1/1-2/Lists/Test/AllItems.aspx

I have tried to access the list several ways using (_vti_bin/ListData.svc) such as:

• https://MYSITE/_vti_bin/ListData.svc -

  An error has occurred on the server.

• https://MYSITE/DIR/1/1-2/Lists/Test/AllItems.aspx/_vti_bin/ListData.svc - Just shows the list

Any help would be appreciated.

Answer 1

Unfortunately, WSS 3.0 / MOSS 2007 does not support REST. You should use the "classic" web service (SOAP) approach via the UpdateListItems method of the Lists web service.

Answer 2

Another alternative that may be worth exploring is to use SQL Server Integration Services (SSIS). There's package on Codeplex that integrates SharePoint with SQL Server for data integration. See here for more details -

Accessing SharePoint Lists with SQL Server Integration Services SSIS 2005

Extracting and Loading SharePoint Data in SQL Server Integration Services