I am trying to use PowerQuery to get data from an asp website.
let
url = ".asp",
headers = [
#"Content-Type" = "application/x-www-form-urlencoded"
],
formData = "userLogin=xxx&userPassword=xxx",
options = [
Headers = headers,
Content = Text.ToBinary(formData)
],
// Send the POST request and capture the response headers
loginResponse = Web.Contents(url, options),
responseHeaders = Web.Headers(url, options),
cookies = if Record.HasFields(responseHeaders, "Set-Cookie") then responseHeaders[#"Set-Cookie"] else "no cookies found"
in
cookies
I do the same thing in VBA and Postman and I see cookies.
Is PowerQuery blocking access to cookies?
-Gina