Connect to SharePoint List in Data Model
Is it possible to connect to a SharePoint list as a source in a data model? I tried various options using the OData source adapter, but could not find a way to get it to work. Is there some trick to getting it to work?
Dave F.
4 replies
-
Hi Dave,
Try converting to JSON or CSV/Excel formats.
Here is a link that may help Create JSON data dynamically from list using javascriptHope this helps.
-
Yakov Shaul No, that does not help. JSON and CSV/Excel formats would both require that the data from the SharePoint list be exported to file first (in either format) before being used in a model. That is not what I'm looking for. BI Office had the ability to add SharePoint lists as a data source for use in its data model tool -- does Pyramid 2018 not have that capability?
Dave F.
-
Dave Fackler
Sorry for the late response,
SharePoint lists as a data source is on the roadmap expected within the next few months.
-
Yakov Shaul Can we use XML instead? Views in Sharepoint can be displayed as XML.
I tried, but I am facing 2 issues.
1) Dumping the XML to a file then uploading it into Pyramid, I cannot figure out how to setup parameters so that Pyramid recognises it. Any guidance welcome.
2) Trying to use the sharepoint "xml" URL into Pyramid fails with error "Request Error - Failed to read file null".