Is there a way to retrieve the URL of documents within sharepoint?
Solved
Sharepoint URL Retrieval
+1Best 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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+13- Safer
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?
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
+9- Contributor
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