Skip to main content
Question

Sharepoint writer error 405 issue

  • January 10, 2020
  • 2 replies
  • 198 views

Hi

 

I am trying to wrote the values of new excel rows to a sharepoint list online but I get the following error

 

"Microsoft SharePoint List Writer: Client-side error: '405 Client Error: Method Not Allowed for url: https://sharepointsite/_api/contextinfo' returned from SharePoint. Error message was: 'The HTTP method 'GET' cannot be used to access the resource 'GetContextWebInformation'. The operation type of the resource is specified as 'Default'. Please use correct HTTP method to invoke the resource.' "

 

I read elsewhere that this was resolved previously by an update. Any idea of a work around or anyone else know how I can resolve so I can use as an automation on FME Server?

 

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.

2 replies

chrisatsafe
Contributor
Forum|alt.badge.img+2
  • Contributor
  • January 13, 2020

Hi @jman123,

Just wanted to confirm, what build of FME are you currently using? On FME Desktop, you can check in Help > About FME Workbench.

Additionally , are you only getting this error when you run the job on Server or do you also get this error when you run it in Workbench?


  • Author
  • January 20, 2020

Hi @chrisatsafe, thanks for your response sorry for the delay. I am on FME(R) 2019.0.20

I am running this job on workbench.

I ran it again today and I get a new warning:

Microsoft SharePoint List Writer: SSL certificate verification failed for host 'dovergovuk.sharepoint.com'. HTTPS connections may not be secure. Disabling verification of SSL certificates. Message: HTTPSConnectionPool(host='dovergovuk.sharepoint.com', port=443): Max retries exceeded with url: /sites/AllCouncil (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1051)')))

And also this error:

Microsoft SharePoint List Writer: Error authenticating via SAML. Verify that the username and password are correct, and that this is a SharePoint Online instance. Response message was: '200'

 

Not sure why I get 200 with the error. I also get the error when trying to access the reader version of sharepoint

 

Thanks