Good Afternoon,

Using Datalink, is it possible to build a connector that points to a SharePoint list?

Thanks,

Jeff

The DataLink user guide lists these connector types:

Microsoft SQL Server database connector

Generic JDBC database connector

FTP connector

SFTP connector

Windows Share connector

Filesystem connector

SOAP connector

REST connector

And I noticed Microsoft has posted a few guides online about using REST to communicate with installed SharePoint instances, which presumably includes published lists of content.

But in studying the REST examples provided by Microsoft, it does look as though a fair amount of coding would be needed to use the REST API to communicate directly with SharePoint to pull content from a list (and then into DataLink).

I've been wondering if this is possible for a couple months.  As of now, I am manually exporting a CSV from the Sharepoint list, then dropping the file in a folder on the DataLink server which imports the data on a schedule.  It would be great if DataLink could grab the information directly from sharepoint, but I have been unable to find a way to make that happen thus far.

Jeff,

Another thought to Gorakh's response would be to create an automated workflow in Sharepoint that would auto export the list to a CSV and dump it to a fileshare where Datalink could pick it up.  This isn't ideal like a direct connector but a potential viable work around and something that is relatively straight forward.

The other thought is to go talk with your Sharepoint Farm Admin and ask him if he would be able to provide you with the query into the database to pull the specific list from... Then you could just pull the query directly from the database... but not sure if that is possible or not.

SharePoint lists can export in RSS format. Theoretically, couldn't the REST connector be modified to read this XML?