You can translate the question and the replies:

Fetching data from Sharepoint to Denodo

Hi, I am trying to fetch a list from Sharepoint to Denodo using the RSS method. I have the following issues. 1) The base view only provided me 25 records using the RSS link from the share point, whereas the sharepoint contains 1000's of records. 2) The data of the sharepoint gets embbed in an column description from the sharepoint. Could you please help ? Thanks, Shriram
user
26-08-2019 06:41:15 -0400

1 Answer

Hi, I would check if the option Limit rows was checked in the execution tab of the base view and if ti was set to 25. I would also check if the data was returned from the right list or if there was some configuration which led to the client only showing 25 rows. There are more ways to connect to Sharepoint lists in Denodo. I found the Knowledge Base article '[Microsoft SharePoint as data source](https://community.denodo.com/kb/view/document/Microsoft%20SharePoint%20as%20data%20source?category=Data+Sources)' really helpful with this. It is expected that the Virtual DataPort retrieves data directly from the data source. Hence, importing HTML tag into the description field of the base view cannot be avoided. But, to achieve the required scenario, I created a “Selection” view over the base view and used [REGEXP](https://community.denodo.com/docs/html/browse/6.0/vdp/vql/appendix/syntax_of_condition_functions/text_processing_functions#regexp) function which is a text processing function that transforms text based on regular expressions over the field. If you have a valid support account, you can also ask the support team for help with any issues you run into and they can help you out. Hope this helps!
Denodo Team
27-08-2019 11:09:59 -0400
You must sign in to add an answer. If you do not have an account, you can register here