How to retrieve custom response headers from a URL using Web Headers

[pranaysharmaman]

I'm trying to make a call to a REST API that returns the total count of rows in a header X-Total-Count.

However when making a call through Power BI, the Web.Headers only retrieves generic response headers like Content-Type, Server etc.

How can I specify the call or maybe an alternate way to retreive the custom response header X-Total-Count?

[jprdynamicapps]

The headers available through Power Query are a small subset of what comes back. Unfortunately, Power Query filters out the rest. The only way to get them is to write a custom connector.

Upvote suggestion to get all headers back here: https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=e47d7520-1509-ed11-b5cf-281878de6c19

[Anonymous]

I am facing the same issue and can not still figure out it

[v-henryk-mstf]

Hi @pranaysharmaman ,

The supported parameters are of the following types.

let
    searchText = "Power Query"
in
    Web.Headers(
        "https://www.bing.com",
        [
            RelativePath = "search",
            Query = [q = searchText]
        ]
    )

related document link:

Web.Headers - PowerQuery M | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[pranaysharmaman]

This also has the same limitation.

The headers returned are only generic ones. 

Power BI only returns following headers - 

Postman returns - 

Majority of headers are missing from Power BI

[danextian]

Hi @pranaysharmaman 

These might be able to pull the information you need.

Table.FromColumns({Lines.FromBinary(Web.Contents("url"), null, null, 65001)})

= Web.BrowserContents("url")

[pranaysharmaman]

These only return the "body". I'm interested in a "header" (custom response header called X-Total-Count)

[dvl_ctaul]

Did you ever figure this out?

[Venn26]

Up...

Never figured this out neither