Power Query Data from Web redirect with cookies (Error 302)

[SimDam]

Dear all,

I am trying to connect to a weblink containing a JSON (Using GetData->FromWeb). The link is redirecting me to a log in page with Windows authentication, sets the cookie and then redirect me back to the page I need. Everything works if I connect to the page via the browser but apparently, Power Query cannot manage this redirect (give always error 302).

Any suggestion on how to manage this case in PowerQuery maybe with M code?

Thank you

[SimDam]

Can you suggest how to do that?

[lbendlin · Accepted solution]

https://docs.microsoft.com/en-us/power-query/startingtodevelopcustomconnectors

https://docs.microsoft.com/en-us/power-query/custom-connector-development-faq

[lbendlin]

you need to create custom connectors to handle redirects.