Forum Discussion
POST http(s) request with xml content in Power Query
You need to have it else you get 400 response. See below.
DataSource.Error: Web.Contents failed to get contents from 'https://www.vinmonopolet.no/vmp/store-pickup/295306/pointOfServices' (400): Bad Request
Details:
DataSourceKind=Web
DataSourcePath=https://www.vinmonopolet.no/vmp/store-pickup/295306/pointOfServices
Url=https://www.vinmonopolet.no/vmp/store-pickup/295306/pointOfServicesI see the same problem not only with Host, but with with Content-Type as well. I found this post regarding the problem - http://blogs.clariusconsulting.net/kzu/setting-http-headers-in-net-this-header-must-be-modified-using-the-appropriate-property/
And I get 400 responce without these parameters as well.
Possibly guys from Power Query team modify headers using not appropriate C class level ;-).
I continued to investigate the case, and found that:
- Power Query automatically adds Host and Content-length headers. I watched that, using Whiteshark for sniffering traffic, created by Power Query. So the error, mentioned in the post, happens because:
1. we try to override the headers, wich is already prepared automatically, and
2. implementation of overriding these headers contains errors I mentioned previously.
But - possibly 2. is done intentionally, because we have no obvious reasons to override these 2 headers - automatically generated values meet the needs of the web-service in my case.
As for error 400 - in my case it ... disappeared today. I'm still try understand what happened, but at least my current understanding is that 400 responce is due to some mistakes in the service or in intermediators (protocol stack, Windows miracles etc.) and not due to mistakes in making call of the service from Power Query.
