Unfortunately you cannot upload files to SharePoint just yet, unless you do it manually using the ShaprePoint API.
Please consider voting for the idea here:
https://knowledge.safe.com/content/idea/23503/sharepoint-file-uploader.html
Hi Aaron
What version of FME are you using?
I worked for Barnsley until last week - that case study was ours. At the time (FME 2016 I think) there was no native support for reading and writing to SharePoint, but I have a hunch it was added in FME 2018 or 2018.1 - at least I managed to write an Excel file to SharePoint just before I left - SharePoint 2013 on premise - by specifying the URL of the document library folder.
A couple of limitations - the document was left 'checked out' and it only committed once - overwrite failed. Sadly I don't have access to an environment I can re-test this with now :(
The alternative is to use HTTPCaller to use the SharePoint web services to save the document - you can also specify permissions, check in and so on with the web service. If you need help with that, @revesz is your man, and I'm sure he'll be along soon now I've tagged him!
Cheers,
Riley
And here is the link to the last time I asked Andras to explain this :)
SOAP request to SharePoint
Hi Aaron
What version of FME are you using?
I worked for Barnsley until last week - that case study was ours. At the time (FME 2016 I think) there was no native support for reading and writing to SharePoint, but I have a hunch it was added in FME 2018 or 2018.1 - at least I managed to write an Excel file to SharePoint just before I left - SharePoint 2013 on premise - by specifying the URL of the document library folder.
A couple of limitations - the document was left 'checked out' and it only committed once - overwrite failed. Sadly I don't have access to an environment I can re-test this with now :(
The alternative is to use HTTPCaller to use the SharePoint web services to save the document - you can also specify permissions, check in and so on with the web service. If you need help with that, @revesz is your man, and I'm sure he'll be along soon now I've tagged him!
Cheers,
Riley
Huh, I used an HTTPCaller to upload (POST) the Excel file and got an http response of 200 but the file isn't there. Any ideas? (Yes, I cleared my cache before reloading the page.)
Huh, I used an HTTPCaller to upload (POST) the Excel file and got an http response of 200 but the file isn't there. Any ideas? (Yes, I cleared my cache before reloading the page.)
Are you running FME under the same login as you access SharePoint? And did you 'check in' the document?
If not, documents in the SharePoint UI only show to other users once they've been checked in, which would explain the behaviour you're seeing.
If not that, I'm not sure what else to try, sorry :(
Huh, I used an HTTPCaller to upload (POST) the Excel file and got an http response of 200 but the file isn't there. Any ideas? (Yes, I cleared my cache before reloading the page.)
Yep, running under same login and doc is checked in. I realized I'm only getting a 200 http response but not a 201, which would indicate the POST succeeded. Not sure why and nothing to go on in the logs that I can see.
Huh, I used an HTTPCaller to upload (POST) the Excel file and got an http response of 200 but the file isn't there. Any ideas? (Yes, I cleared my cache before reloading the page.)
Sorry then @aaron I'm not sure what to try next. Did you try it with 2018.1 though - would be interested to know if that worked for you?
Sorry then @aaron I'm not sure what to try next. Did you try it with 2018.1 though - would be interested to know if that worked for you?
Yes, I was using 2018.1 (build 18528). Maybe I had a parameter wrong or the settings on our SharePoint site won't allow it. I'll certainly chime back in if I discover something.
