You can translate the question and the replies:

Sharepoint via RSS

Related to: Microsoft SharePoint as data source
Using Denodo 5.0 . I found that although this technique works, it took quite a bit of manipulation and parsing to get the actual data fields. Although the Sharepoint List meta data came in cleanly, all the data content was embedded a Description" blob of text (separated by HTML tags), and had to be parsed into individual fields. Not only was this cumbersome because it required flattening the description string and using regular expressions for each fields, but the performance is now extremely slow because of this extra processing. Has anyone found a solution that works more effective than this?
RSS Sharepoint XML Regular Expressions
user
24-10-2014 11:53:09 -0400
code

1 Answer

Hi, there are multiple ways of accessing Sharepoint lists. For example you can try with the following url in a XML Data Source http://<host server>/_vti_bin/owssvr.dll?Cmd=Display&List=<List GUID>&XMLDATA=TRUE That should return the data in a better format than the RSS feed. Another option is to use the Odata URL (atom) in a XML Data Source, http://sharepoint/_vti_bin/ListData.svc/listname . Depending on your Sharepoint version you may be able to use Sharepoint's REST API as explained http://msdn.microsoft.com/en-us/library/office/jj860569(v=office.15).aspx Please let me know if any of the options described solve your case.
Denodo Team
28-10-2014 19:45:52 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here