Passing Cookies Between HTTPS requests in Power Query

Anonymous — Sun, 16 Apr 2023 13:52:46 GMT

Hello everyone!

I am trying to use my credentials to log in a url and then use the same cookies to fetch the data from another related url. I keep getting the below error message that I don't know how to avoid in the 'Reponse' step. I believe is related to the type of Session being passed to Web.Contents().
Expression.Error: We cannot convert a value of type Binary to type Text.
Details:
Value=[Binary]
Type=[Type]

This is my piece of code. I'd very much appreciate any help on getting it right:

let
LoginUrl = "https://example.com/auth/login",
SecureUrl = "https://example.com/status/",
Payload = [ username = "myusername", password = "strongpass" ],

// Create a new session and log in
Session = Web.Contents(LoginUrl, [
Headers = [#"Content-Type" = "application/x-www-form-urlencoded"],
Content = Text.ToBinary(Uri.BuildQueryString(Payload)),
ManualStatusHandling={400,401,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417,418,422,423,424,425,426,427,428,429,431,451,500,501,502,503,504,505,506,507,508,509,510,511}
]),

// Get the secure page using the authenticated session
    Response = Web.Contents(SecureUrl, [Headers=[Cookie=Text.Combine(Binary.ToText(Web.Contents(Session, [RelativePath=""])), "; ")]]),
    Content = Text.FromBinary(Response)
in
    Content

Thank you very much in advance!

Javier

Re: Passing Cookies Between HTTPS requests in Power Query

lbendlin — Mon, 17 Apr 2023 23:36:00 GMT

Rather ambitious. Note that you can simplify lists via ..

{400..431,451,500..511}

topic Passing Cookies Between HTTPS requests in Power Query in Developer

Passing Cookies Between HTTPS requests in Power Query

Re: Passing Cookies Between HTTPS requests in Power Query