0

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

null
    • Yakov_Shaul
    • 6 yrs ago
    • Reported - view

    Hi Dave,

    Try converting to JSON or CSV/Excel formats.
    Here is a link that may help Create JSON data dynamically from list using javascript

    Hope this helps.

    • Dave_Fackler
    • 6 yrs ago
    • Reported - view

    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.

    • Yakov_Shaul
    • 6 yrs ago
    • Reported - view

    Dave Fackler 

    Sorry for the late response,

    SharePoint lists as a data source is on the roadmap expected within the next few months.

    • Eric_Bello
    • 5 yrs ago
    • Reported - view

    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".

Content aside

  • Status Answered
  • 5 yrs agoLast active
  • 4Replies
  • 107Views
  • 3 Following