Could not create SSL/TLS secure channel with Excel

Hello everybody

1 years ago, with the help of the link below, I brought the market data of the structure and used it in Excel.

https://web.archive.org/web/20190310221844/https://wiki.zansha.space/index.php/SSO_Authentication_in_Microsoft_Power_Query

lately, i came back to EVE and tried to use it again, but an error occurred.

when call Web.Contents(actualUrl, options) in PowerQuery.

DataSource.Error : could not create ssl/tls secure channel

I checked all the esi application and refresh token in postman.

Any changes on how to get esi information from excel?

The error most likely due to ESI moving the a newer version of ssl/tls.
Google have a lot of results for the error, explaining how to change the version power query uses:
https://www.google.com/search?&q=DataSource.Error+%3A+could+not+create+ssl%2Ftls+secure+channel+excel
I’m not 100% what version of ssl/tls ESI changed to, so you will have to do a little trial and error to figure out what works.

Hahaha, I’m stupid.

I must have searched for that keyword, but why couldn’t I find it?

As a result of looking at the link, the problem I have been troubled for several days has been solved very easily.

Thank you very much.

Power Query - Could not create SSL/TLS secure channel