Get data from string when website requires authentication

[AA2023]

Hi

Would like to display data from a weblink. Once data is received, I can trim / concatenate the string.

==WEBSERVICE("link") seems to do the job for non-authenticated websites. For example

=WEBSERVICE("https://api.open-meteo.com/v1/forecast?latitude=52.3555&longitude=1.1743&current=temperature")

will return temperature 8.8 °C for England @ 52.3555°N, 1.1743°W

{"latitude":52.36,"longitude":1.1799998,"generationtime_ms":0.0209808349609375,"utc_offset_seconds":0,"timezone":"GMT","timezone_abbreviation":"GMT","elevation":35.0,"current_units":{"time":"iso8601","interval":"seconds","temperature":"°C"},"current":{"time":"2023-11-13T05:00","interval":900,"temperature":8.8}}

The above string can be processed for displaying data in different cells.

How do I go about getting data when site needs authentication
Perhaps there is another function similar to WEBSERVICE("")

 

[bobaol]

Hi, how about try multiple tools, like using Excel to create your link, then use another Windows Macro, like MacroExpress, to copy and paste to a browser. MacroExpress allows you to connect multiple applications together and come up with results. It requires a little learning, but it is very fast to learn it. The situation you're described on top is a mess because of authentication. I highly doubt it is possible to use Excel alone. Using Excel alone would be very tough, I think. Using SendKeys might work, but again, very tough. anyway, good luck!