topic Using Cookies Headers in Developer

Using Cookies Headers

Anonymous — Fri, 26 Mar 2021 05:25:15 GMT

Hi Team

Based on the suggestion from one of our community members, I was trying cookies as Headers to see if it works. I was trying in PowerBI Desktop but it didn't work as the result for Headers was NULL. Then, I tried this in Visual Studio this morning and struck at a point. Maybe you can help. Here is my code:

Cookies.Feed = () =>

let
Source = Web.Contents(Uri.Combine("https://abc.123.com", "/api/cookie"), [Headers =[#"Authorization"= "Bearer "&TokenMethod("password", "token", "code")[access_token]]]),
Source_Headers = Value.Metadata(Source)[Headers],
Auth_Cookie_Header = Source_Headers[#"Set-Cookie"]
in
Auth_Cookie_Header;

In this code above, TokenMethod is a function that gets me the access_token.

My code is big, so sharing what is relevant here. I want to use cookies along with the access_token as HEADERS in this function below:

System.Feed = (url as text) =>
let
source = Web.Contents(url, [Headers = DefaultRequestHeaders]),
json = Json.Document(source),

Json;

I've defined DefaultRequestHeaders as mentioned below:

DefaultRequestHeaders = [

#"Authorization"= "Bearer "&TokenMethod("password", "token", "code")[access_token],
#"Cookie"=Cookies.Feed()[Auth_Cookie_Header]
];

When I try this, it returns an error stating "We cannot apply field access to the type text". I think its not the right way for me to define DefaultRequestHeaders and use it in my System.Feed function as Headers.

Could you please help me correct the way it has to be defined. If someone has handled this in their connector, I would appreciate if you could share an example.

Re: Using Cookies Headers

lbendlin — Sun, 28 Mar 2021 02:06:53 GMT

DefaultRequestHeaders = [

"Authorization"= "Bearer "&TokenMethod("password", "token", "code"),

"Cookie"=Cookies.Feed()
];

Re: Using Cookies Headers

Anonymous — Mon, 29 Mar 2021 07:22:02 GMT

@lbendlin I've tried that but it says the credentials provided for the source are invalid. Although, I see the token response successfully. Is there a way to see what is actually returned in the Cookies, that is not being accepted as proper credentials? It is from this function:

Cookies.Feed = () =>

Re: Using Cookies Headers

lbendlin — Mon, 29 Mar 2021 11:53:46 GMT

Use the "Diagnose step" feature in Power Query to see the network traffic, or use Fiddler.