[Solved] Import data from an API link that contains JSON to EXCEL [closed]

First of all you need to examine the structure of the JSON response, using any online JSON viewer (e. g. http://jsonviewer.stack.hu/), where you can see that your JSON object contains atletas array, clubes, posicoes, status, time objects, and several properties with scalar values: Going further there are objects within atletas array, each of them contains … Read more

[Solved] Google places API key error

I think you are missing steps . 1. Go to Google Developers Console. 2. Enable Google Maps Javascript API. 3. Then Generate API key . 4. Then put that API key in the bottom of your code in this section. <script type=”text/javascript” src=”https://maps.googleapis.com/maps/api/js?key=YOUR_GOOGLE_MAPS_JAVASCRIPT_API_KEY&libraries=places&callback=initService” async defer></script> This will 100% work, if follow the steps carefully. 1 … Read more

[Solved] A Random Wikipedia Article Generator

According to: https://en.wikipedia.org/wiki/Wikipedia:Special:Random The endpoint for a categorized random subject is: https://en.wikipedia.org/wiki/Special:RandomInCategory/ And not: https://en.wikipedia.org/wiki/Special:Random/ So you should change your url to: url = requests.get(f”https://en.wikipedia.org/wiki/Special:RandomInCategory/{topic}”) 1 solved A Random Wikipedia Article Generator

[Solved] How to implement currency conversion

Please change you code with below code [WebMethod] public decimal ConvertGOOG(decimal amount, string fromCurrency, string toCurrency) { WebClient web = new WebClient(); string apiURL = String.Format(“http://finance.google.com/finance/converter?a={0}&from={1}&to={2}”, amount, fromCurrency.ToUpper(), toCurrency.ToUpper()); string response = web.DownloadString(apiURL); var split = response.Split((new string[] { “<span class=bld>” }), StringSplitOptions.None); var value = split[1].Split(‘ ‘)[0]; decimal rate = decimal.Parse(value, CultureInfo.InvariantCulture); return rate; … Read more