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.