Can you please add a Visual Basic script to the post so that it also works with Excel? Thank you!
•
11
•
@CryptoPfand It should be very easy to import the API URL via "Import data from the web" and Excel will recognize that it is JSON. Here it is shown quite well: https://www.howtoexcel.org/how-to-access-a-json-api-with-power-query/
••