Ivan Bondarenko on 20 May 2016 20:00:17
Some sources, e.g. Cognos Mashup Service, Yandex.Metrica, require authentication on first URL when usual "httprequester" can get Set-Cookie headers from ResponseHeaders.
Then we can do httprequest to second URL (that differs from first one) for reports or data (having Cookie in headers).
Would be great to cover this scenario in Power Query.
- Comments (3)
RE: Add ability to get ResponseHeader when use Web.Contents
Wouldn't it be acceptable to list the "safe" headers. It is very annoying to see that there is a mismatch between Azure Storage which heavily uses headers for pagination and PowerBI which can't read those headers.
RE: Add ability to get ResponseHeader when use Web.Contents
Even Microsoft's own Text Analytics Topic API needs this to get the Location header to handle asynchronous processing.
RE: Add ability to get ResponseHeader when use Web.Contents
Second! I also use an API that pages results using a "cursor" it sticks in the response header. Since that isn't accessible I'm limited to one page results. If the result from Web.Contents(someflag) was split into two fields, the header & the content that would help with these odd (but numerous) API's.