You can translate the question and the replies:

Sharepoint via RSS

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?
24-10-2014 11:53:09 -0400

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 Please let me know if any of the options described solve your case.
Denodo Team
28-10-2014 19:45:52 -0400
You must sign in to add an answer. If you do not have an account, you can register here