# Urgent Assistance to Call a Weather API **URL:** \ **Category:** Ask for Help\ **Created:** [May 6, 2022, 6:14am UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686 "2022-05-06T06:14:51Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Freek\_Stegmann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/freek_stegmann/32/16336_2.png) [@Freek\_Stegmann](https://community.glideapps.com/u/Freek_Stegmann)\ **Post date:** [May 6, 2022, 6:14am UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/1 "2022-05-06T06:14:51Z")
Hi all, I have an Openweathermap API key and the URL but am not sure how to format the new column to call the API. This is needed for a huge conference held this weekend. Anyone’s assistance would be greatly appreciated, thank you! ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [May 6, 2022, 6:24am UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/2 "2022-05-06T06:24:54Z")
Have you considered contacting a Glide expert directly? [Glide experts](https://www.glideapps.com/experts) ---
**Author:** ![Freek\_Stegmann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/freek_stegmann/32/16336_2.png) [@Freek\_Stegmann](https://community.glideapps.com/u/Freek_Stegmann)\ **Post date:** [May 6, 2022, 6:36am UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/3 "2022-05-06T06:36:24Z")
Hi Nathanael, No, actually I haven’t, I am rather new at this. Unfortunately, there is no budget to hire an expert. ---
**Author:** ![Hani\_Ibrahim](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hani_ibrahim/32/42108_2.png) [@Hani\_Ibrahim](https://community.glideapps.com/u/Hani_Ibrahim)\ **Post date:** [May 6, 2022, 11:24am UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/4 "2022-05-06T11:24:20Z")
do you use Glide tables or google sheet? if you are using Glide tables, then i don’t know how. However, if you are using google sheet i would recommend watching the following [YouTube Video](https://www.youtube.com/watch?v=3tbuFJwTEQA). i already set a google sheet connected to openweather using API key. Thus will require you to write a small google script which he is explaining its steps. i recommend doing that. Meanwhile, if you need to have what i did, i will be more than happy to share it with you. you may also have a look to [This Article](https://mixedanalytics.com/knowledge-base/access-open-weather-api-data-in-google-sheets/) which has easy to do steps. ---
**Author:** ![Freek\_Stegmann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/freek_stegmann/32/16336_2.png) [@Freek\_Stegmann](https://community.glideapps.com/u/Freek_Stegmann)\ **Post date:** [May 6, 2022, 11:57am UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/5 "2022-05-06T11:57:41Z")
Hi Hani, Thank you for your reply, much appreciated! I am currently using a single Glide table for the weather, which I cannot get to work. There is one Google Workbook linked to the app, thus I will keenly follow your instructions in your article. Once again, thank you very much for the advise, have an awesome weekend! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 6, 2022, 2:09pm UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/6 "2022-05-06T14:09:34Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5e92402c5e44255879c8697b16ddc08946893db.png) Is it something like this? You should be able to use the Fetch JSON plugin to make the API call as long as you have the API key. ---
**Author:** ![Freek\_Stegmann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/freek_stegmann/32/16336_2.png) [@Freek\_Stegmann](https://community.glideapps.com/u/Freek_Stegmann)\ **Post date:** [May 6, 2022, 2:23pm UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/7 "2022-05-06T14:23:32Z")
Hi [ThinhDinh](https://community.glideapps.com/u/thinhdinh), That is exactly the one I used and also the fetch JSON, however, it keeps on coming up with an error code that says invalid code. I have approached Openweathermaps to inquire about this because it has been nearly 24 hours since I registered and received the API key. As soon as I receive feedback from them I will keep you updated. Thank you and… ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [May 6, 2022, 11:54pm UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/8 "2022-05-06T23:54:07Z")
If time is not on your side, I would suggest trying with a new account & new API key. ---
**Author:** ![Freek\_Stegmann](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/freek_stegmann/32/16336_2.png) [@Freek\_Stegmann](https://community.glideapps.com/u/Freek_Stegmann)\ **Post date:** [May 8, 2022, 8:28am UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/9 "2022-05-08T08:28:04Z")
Just a silly question, In which field must I paste the API call? ![image.png](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/d/3d3efd907ae72c0581615932f33c3c13ee06cfae.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 8, 2022, 8:34am UTC](https://community.glideapps.com/t/urgent-assistance-to-call-a-weather-api/41686/10 "2022-05-08T08:34:13Z")
> [@Freek\_Stegmann](#): > > In which field must I paste the API call? In the URL field. And then you can use the JQ Query field to parse the response (if necessary). Refer to the video guide in the documentation. > **[Transform JSON column | Glide](https://www.glideapps.com/plugins/jq)** > > Transform JSON with JQ