Skip to main content

    Power BI

    New

    Add ability to get ResponseHeader when use Web.Contents

    Vote (11) Share
    Ivan Bondarenko's profile image

    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 (2)
    Ivan Bondarenko's profile image Profile Picture

    c3cb1933 de2d-47f3-8aa0-d0a2821c5faf on 05 Jul 2020 22:38:38

    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.

    Ivan Bondarenko's profile image Profile Picture

    b929a23e 389f-40fa-bed7-3eb6c1f515fa on 05 Jul 2020 22:26:59

    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.