Can FME create folders in an on-prem Sharepoint Library? Iβm successfully connecting to the library using the Sharepoint List type (Reader and Writer), and looking at written data I can see an existing folder, but I canβt use the writer to create folders.
Solved
FME - Sharepoint Library On-Prem
+2- Contributor
Best answer by benhanson
I did test without it, and the request failed so I was trying to eliminate variables.
I determined the problem however. It turns out that for nearly all POST requests to the Sharepoint API, you must supply the custom header X-RequestDigest with a value acquired by sending a POST to /_api/contextinfo.
So my initial test workflow (which is now working) consists of Creator(Transform to start flow)Β βΒ AttributeFileReader(Transformer to pull in test file) β HTTPCaller(Transformer to get XML containing RequestDigest) βΒ XMLFlattener (Transformer to extract & expose FormDigestValue) βΒ HTTPCaller (Transformer to make actual REST call to Sharepoint).
Β
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.
+59- Influencer
Safe software have a great article forΒ Getting-Started-with-Microsoft-SharePointΒ but alas the majority focusβ around using Sharepoint Online, hence the Connector transformer.
Having a quick look at the sharepoint documentation,Β Β appears you might be able to use the same API. dΒ http://server/site/_api/Β so you should be able to substitute the first part of the url with your internal address
+2- Contributor
Would this be using the HTTPCaller transformer? Does this end up looking like 1 workflow step per API call? (one httpCaller to auth and/or get context, separate to loop through with updates?)
+59- Influencer
I can imagine that would be the case. The sharepointonlineconnector is an fme package with the following actions build into a UI
uploads, downloads, deletes, or lists the contents of filesΒ https://hub.safe.com/publishers/safe/packages/microsoft-sharepoint/transformers/SharePointOnlineConnector
underneath all its doing is auth and graph/SharePoint API calls
+2- Contributor
Do you know of any samples out there that show POST operations from HTTPCaller to Sharepoint? Iβve successfully queried a folder with GETΒ /_api/web/GetFolderByServerRelativeUrl('MyLibraryName'), but this GET requestΒ doesnβt require constructing a request body, and doesnβt appear to require any special headers. Iβm not having any luck with POST operations (like what headers, what's in the upload?)
+59- Influencer
its all in thisΒ https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-folders-and-files-with-restΒ and in generalΒ https://learn.microsoft.com/en-us/sharepoint/dev/sp-add-ins/get-to-know-the-sharepoint-rest-service
postman might be a handy toolΒ https://www.postman.com/grey-star-32224/sharepoint-apis/request/hrufx1o/crud-upload-fileΒ
Β
+2- Contributor
Whatβs missing is how do I plug inΒ
{length of request body as integer}
within the HTTPCaller header parameters?
+59- Influencer
you can dive more into the detail ofΒ HTTP-Requests-with-the-HTTPCallerΒ where the Header value goes hereΒ
Β
+2- Contributor
I understand where the custom headers go, the issue is how to calculate the request body length in order to populate the value.
+25- Influencer
Are you sure that that header is required? I myself have never had a need to actually manually use this header in a httpcaller. I don't know if that is because it is not required or if it is something that all calls need and is therefore always added automatically. Can you try the call without this header?
+2- Contributor
- Best Answer
I did test without it, and the request failed so I was trying to eliminate variables.
I determined the problem however. It turns out that for nearly all POST requests to the Sharepoint API, you must supply the custom header X-RequestDigest with a value acquired by sending a POST to /_api/contextinfo.
So my initial test workflow (which is now working) consists of Creator(Transform to start flow)Β βΒ AttributeFileReader(Transformer to pull in test file) β HTTPCaller(Transformer to get XML containing RequestDigest) βΒ XMLFlattener (Transformer to extract & expose FormDigestValue) βΒ HTTPCaller (Transformer to make actual REST call to Sharepoint).
Β
Login to the community
No account yet? Create an account
An FME Account is required to contribute
LoginEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.