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.
4 Comments
- 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.
- Even Microsoft's own Text Analytics Topic API needs this to get the Location header to handle asynchronous processing.
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.
- Status added:Needs Votes
