cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Web.Contents unencoding forward slahes

Hi,

 

I'm trying to call the Google Search Console API which requires the following format:

 

GET https://www.googleapis.com/webmasters/v3/sites/siteUrl/urlCrawlErrorsCounts/query

Where siteUrl is an encoded URL of the format:

 

https%3A%2F%2Fwww.example.com

 

However when I put that in to the Web.Contents function it always unencodes the forward slashes meaning I can never reach the Google endpoint.

 

Example:

CfceSgI

 

 

 

 

 

 

 

 

 

I have used the Uri.EscapeDataString() function but Web.Contents just undoes the encoding.

 

How do I tell the function not to unencode the string?

 

Thanks,

Richard

3 REPLIES 3
Highlighted
Microsoft
Microsoft

Re: Web.Contents unencoding forward slahes

Hi @Richard_W,

You can ask for help from Google Support  to get how to use Google Search Console API to retrieve data. Then use "Get Data->Web" entry in Power BI Desktop or directly add connection information in Advanced Editor to connect to your API. There are some samples for your reference.

API Strategies with Power BI
Get Data from Twitter API with Power Query

how to connect my web api wtih Power BI Reports?

Regards,
Angelia

Highlighted
Frequent Visitor

Re: Web.Contents unencoding forward slahes

Hi @v-huizhn-msft,

 

Thanks for your response, however I can't seem to find any reference to people trying to encode a '/' in Web.Contents.

 

I firmly believe this is a problem with the Web.Contents function and for some reason it is unencoding any '%2F' into a '/' even though I don't want it to.

 

Example power query:-

 

let
    URL = "https://www.example.com/en-gb",
    Encode = Uri.EscapeDataString(URL),
    Source = Web.Contents("https://dataapi.com/site/" & Encode & "/dataEndpoint"),
in
    Source

The expected result from this power query should be:-

 

https://dataapi.com/site/https%3A%2F%2Fwww.example.com%2Fen-gb/dataEndpoint

 

But instead the actual call from Web.Contents is to:-

 

https://dataapi.com/site/https%3A//www.example.com/en-gb/dataEndpoint

 

Which is wrong!

 

How can I force Web.Contents to keep the '%2F' encoded and not to unencode it to a '/'?

 

Thanks,

Richard

Highlighted
Frequent Visitor

Re: Web.Contents unencoding forward slahes

I've used fiddler to see what URL is going out from Power BI and can confirm that it is unencoding the '%2F' to a '/'.

 

Any idea what I can do to stop this?

 

Thanks,

Richard

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors