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),
in
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.
