Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Fetch metadata from SharePoint Online document libraries

(I posted this already but wasn't signed in and can't find the post to delete it)

 

So, I'm trying to fetch custom metadata from around 50+ SharePoint Online document libraries.  Here's my findings so far:

  • SharePoint.Files and SharePoint.Contents connectors only fetch limited metadata
  • SharePoint.Tables version 1.0 works but requires a lot of drilldowns on columns like FieldValueAsText.  When I tried to execute the query for 1 library, it ran for about 3 hours before I decided to just kill it.  Too slow.
  • SharePoint.Tables version 2.0 might work, and it cleanly loads all the metadata I want, but it only renders the contents of the top-level folder.
  • OData connector doesn't work and renders an authentication error.

I've tried searching far and wide, and have had zero luck.  Can anyone provide any recommendations?

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for the response, but I already know how to get data from a SharePoint list the conventional ways.  I'm asking if there's a method that doesn't take HOURS to refresh.  And as I mentioned, the OData connector always tells me I'm not authorized, even though I clearly am.