Skip to main content
Solved

Sharepoint URL Retrieval

  • November 20, 2018
  • 3 replies
  • 51 views

Forum|alt.badge.img+1

Is there a way to retrieve the URL of documents within sharepoint?

Best answer by markatsafe

The FME SharePoint List reader only returns the file name of the attached document. You can build the document URL if you know a little about your sharepoint configuration. If you're using FME to read your sharepoint lists you'll know the root directory, something like:

https://myorganisation-my.sharepoint.com/personal/user_name/

Then add the folder name, i.e. Documents or 'personal' followed by the file name. You can get the pattern of the URL by opening sharepoint, right clicking on the document name and use Copy Link

Accessing your document in FME will depend on the authentication used by your sharepoint configuration. Currently (2018) HTTPCaller does not support SAML (SharePoint Online) authentication.

There are more ideas on this in this SharePoint question

View original
Did this help you find an answer to your question?

3 replies

nampreetatsafe
Safer
Forum|alt.badge.img+12

Hi @craniumak: thanks for your question! Are you wanting to retrieve the URLs off all documents stored on a particular Sharepoint site/folder? Or are you trying to read a document stored in Sharepoint via it's URL using FME?


Forum|alt.badge.img+2
  • Best Answer
  • November 22, 2018

The FME SharePoint List reader only returns the file name of the attached document. You can build the document URL if you know a little about your sharepoint configuration. If you're using FME to read your sharepoint lists you'll know the root directory, something like:

https://myorganisation-my.sharepoint.com/personal/user_name/

Then add the folder name, i.e. Documents or 'personal' followed by the file name. You can get the pattern of the URL by opening sharepoint, right clicking on the document name and use Copy Link

Accessing your document in FME will depend on the authentication used by your sharepoint configuration. Currently (2018) HTTPCaller does not support SAML (SharePoint Online) authentication.

There are more ideas on this in this SharePoint question


timwarfe
Contributor
Forum|alt.badge.img+7
  • Contributor
  • November 26, 2019

I have the documents listed from a root folder perspective and can manually create a file path to launch the document as an URL.

Is there a way to display the Path of the document as an attribute automatically? (Not manually derived) @markatsafe @mark2atsafe @mark2catsafe


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings