# COMMUNITY MEETUP – Thu, July 2 19.00 (CET) – Glide & APIs **URL:** \ **Category:** Ask for Help\ **Created:** [June 25, 2020, 11:55pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458 "2020-06-25T23:55:59Z")\ **Posts on this page:** 20\ **Page:** 1
**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:** [June 25, 2020, 11:55pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/1 "2020-06-25T23:55:59Z")
### COMMUNITY MEETUP: July 2, 2020 (Thursday) **Glide & APIs: A love story** 19.00 (CET) 60 minutes (presentation: 30-40 minutes, Q&A ~20 minutes) Online [Google Meet link](https://meet.google.com/eej-vvuj-enq) [Add to your calendar](https://calendar.google.com/event?action=TEMPLATE&tmeid=MDlpMW1oYW82aXM2aGhvbmFyMWFmdHFycW0gc211cDF1Y29zNDN0M29xMzFqY2Rhc3RodG9AZw&tmsrc=smup1ucos43t3oq31jcdasthto%40group.calendar.google.com) ( **updated link** ) Will be presented by @Vicio_Sciascia. This community meetup is organized spontaneously by a few Gliders, not by Glide Team itself. **Let us know here what about Glide and APIs interests you in particular**. **Let us know also if you think you might be able to join.** (Should the calendar link above not work, feel free to send @nathanaelb a direct message with your email address and I will add you.) * * * ### Meeting agenda - Let’s try to sign in a few minutes early so we can start at 19.00. - Participants who wish to can say a (short) word about what they are hoping to take away from the meetup. - Presentation by Vicio, followed by Q&A: 1. A brief introduction: what APIs are and advantages of using them in Glide 2. We will learn to perform a request to an API and obtain a response containing data 3. We will **build a simple Glide App** that will show contents retrieved from an API upon user request See you next week! ---
**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:** [June 26, 2020, 12:07am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/2 "2020-06-26T00:07:40Z")
Ha I can’t join this due to the time difference ☹ Hopefully there will be a writeup about that later on! ---
**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:** [June 26, 2020, 12:13am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/3 "2020-06-26T00:13:52Z")
Sorry @ThinhDinh. We’ll make sure to take notes and share them with you. 🙂 ---
**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:** [June 26, 2020, 12:14am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/4 "2020-06-26T00:14:36Z")
Thanks a lot as always for organizing these sessions Nathanael, I highly appreciate it and I’m sure others do as well 😄 ---
**Author:** ![thienhungf](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thienhungf/32/153_2.png) [@thienhungf](https://community.glideapps.com/u/thienhungf)\ **Post date:** [June 26, 2020, 12:17am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/5 "2020-06-26T00:17:52Z")
I am also interested in your topic. But I also can’t anticipate that time. Can you sharr me the information of that discussion? 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:** [June 26, 2020, 12:19am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/6 "2020-06-26T00:19:29Z")
@ThinhDinh It is long overdue, I apologize. Vicio showed interest in presentation this topic a few weeks ago and it’ll be great to hear about Glide & API’s. So thank you, @Vicio_Sciascia. ---
**Author:** ![Vicio\_Sciascia](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vicio_sciascia/32/4940_2.png) [@Vicio\_Sciascia](https://community.glideapps.com/u/Vicio_Sciascia)\ **Post date:** [June 26, 2020, 8:04am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/7 "2020-06-26T08:04:07Z")
Hi guys, apologize for fellow Gliders that can’t participate ☹ However, I will share the content of the presentation right after the meetup. Here’s the agenda: 1. A brief introduction: what APIs are and advantages of using them in Glide 2. We will learn to perform a request to an API and obtain a response containing data 3. We will **build a simple Glide App** that will show contents retrieved from an API upon user request The Glide App that we will build will be also shared to let you perform your tests. @ThinhDinh I’m sorry you will miss the meetup, there will be a mention of honor for your help with override arrayformula limitations 😉 See you Bye ---
**Author:** ![Phil\_Jackson](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phil_jackson/32/5939_2.png) [@Phil\_Jackson](https://community.glideapps.com/u/Phil_Jackson)\ **Post date:** [June 26, 2020, 8:51pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/8 "2020-06-26T20:51:54Z")
Hoping to join. Thanks for setting up ---
**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:** [June 28, 2020, 8:47am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/9 "2020-06-28T08:47:11Z")
Hello everyone, here is the agenda on Glide & APIs for next week’s meetup: 1. A brief introduction: what APIs are and advantages of using them in Glide 2. We will learn to perform a request to an API and obtain a response containing data 3. We will **build a simple Glide App** that will show contents retrieved from an API upon user request. Should you want a calendar invite, please let me know by sending a direct message to @nathanaelb with your email address (used only for the calendar invitation of course). ---
**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:** [June 29, 2020, 9:52pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/10 "2020-06-29T21:52:39Z")
Is the “Add to your calendar” link in the initial post working? I’m a little confused. A friend told me it seems to not be working, and yet I see there were 19 clicks. **If there is a problem with the link, please let me know.** 🙏🏻 ---
**Author:** ![JasonFrederick](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jasonfrederick/32/59917_2.png) [@JasonFrederick](https://community.glideapps.com/u/JasonFrederick)\ **Post date:** [June 29, 2020, 10:04pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/11 "2020-06-29T22:04:29Z")
The event is not being added (at least to my calendar). Here’s the message I get after google calendar opens: ![Screen Shot 2020-06-29 at 6.01.36 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c2cac82e5140656b993a04a3b4df96fcc215e398.png) ---
**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:** [June 29, 2020, 10:24pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/12 "2020-06-29T22:24:27Z")
Thanks @JasonFrederick ! ---
**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:** [June 29, 2020, 11:01pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/13 "2020-06-29T23:01:43Z")
Ok, this is preposterous. My personal calendar in Google Calendar is, of course, personal and therefore private. When I create an event in my private calendar, I have the option to make a specific event “public” and to “publish” it (=share it) with a link or html code to be embedded: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/d/d2ccdf74a8a068d326fa9d11ec442b4e9c8cc77f.png) I wrongly assumed that this “public” feature would override the settings of my calendar. Why else would that feature be there then? And yet I just found this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/209bee2bc07bae2934843f165df2b14077a2f429.png) This is a very unexpected result to say the least. If anyone here works at Google… Though it is hard for me to imagine that Google would be at fault here, this seems so, so basic. ---
**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:** [June 29, 2020, 11:22pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/14 "2020-06-29T23:22:17Z")
I just updated the link to [add to calendar](https://calendar.google.com/event?action=TEMPLATE&tmeid=MDlpMW1oYW82aXM2aGhvbmFyMWFmdHFycW0gc211cDF1Y29zNDN0M29xMzFqY2Rhc3RodG9AZw&tmsrc=smup1ucos43t3oq31jcdasthto%40group.calendar.google.com). You can use this one or the one in the original post, they are the same. I hope it works now. If it doesn’t work, don’t hesitate to let me know. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [June 30, 2020, 12:04am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/15 "2020-06-30T00:04:06Z")
19:00 CET time is for me 1 pm, I could be with you surely!! Saludos @nathanaelb ---
**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:** [June 30, 2020, 7:41am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/16 "2020-06-30T07:41:01Z")
See you there @gvalero. If you want me to add you to the calendar invitation, please send me your email address in a dm. ---
**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:** [July 2, 2020, 4:59pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/17 "2020-07-02T16:59:02Z")
Last call for today’s community meetup **“Glide & APIs”**. When: now (July 2, 19.00 CET) **[Sign in here: Google Meet](https://meet.google.com/eej-vvuj-enq)** ---
**Author:** ![Vicio\_Sciascia](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vicio_sciascia/32/4940_2.png) [@Vicio\_Sciascia](https://community.glideapps.com/u/Vicio_Sciascia)\ **Post date:** [July 2, 2020, 10:33pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/18 "2020-07-02T22:33:30Z")
Thank you so much for joining the meeting guys. I really appreciated your interest and your smart questions. Here you can find the slides: https://www.slideshare.net/slideshow/embed_code/key/ttxcqBYr9XgCek We made a walkthrough creating this App: [https://yz5s7.glideapp.io/](https://yz5s7.glideapp.io/) Using **PunkApp** , the user will be able to retrieve information about random beers from [Punk API](https://punkapi.com/): an unofficial API that allows you to explore Brewdog Brewing Company craft beers’ catalogue. Here is the code for my _watcher_ script built on top of @ThinhDinh’s one: ``` function fillFormulas() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getSheetByName('Queries'); var lr = sheet.getLastRow(); var fillDownRange = sheet.getRange(lr, 4, 1); sheet.getRange("D"+(lr-1)).copyTo(fillDownRange); Utilities.sleep(2000); var spreadsheet = SpreadsheetApp.getActive(); spreadsheet.getRange('A1').activate(); spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate(); spreadsheet.getRange('A3:U3').activate(); spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Beers'), true); spreadsheet.getRange('A1').activate(); spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).offset(1,0).activate(); spreadsheet.getRange('Queries!A3:U3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_VALUES, false); spreadsheet.setActiveSheet(spreadsheet.getSheetByName('Queries'), true); spreadsheet.getRange('3:3').activate(); spreadsheet.getActiveSheet().deleteRows(spreadsheet.getActiveRange().getRow(), spreadsheet.getActiveRange().getNumRows()); } ``` It can be used to: - retrieve the last row from “Queries” sheet (a sheet used to temporarly collect user’s requests) every time the script is triggered - copy down the formula contained on column 4 in the row right above (in this case the formula will be ImportJSON that will fill cells A3 to U3 with data retrieved from Punk API) - copy data from the new row (in this case the third row) in “Queries” sheet - paste **only values** to a new empty row to another sheet used as storage (the sheet is called “Beers” here) - delete the original row from “Queries” sheet Why this trick? Because otherwise, from time to time, when you open your sheet _ALL_ ImportJSON formulas will be refreshed asking new data to APIs and that’s bad because you can reach rate limit from APIs and get banned 😇 The watcher script will be activated by an onChange Google Apps Script Trigger: ![Schermata 2020-07-02 alle 23.03.18](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/90a8cfefea3eec33365ca2470e60600fc79a7730.png) Thank you again @nathanaelb for setting it up Have fun 😊 Bye ---
**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:** [July 2, 2020, 10:45pm UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/19 "2020-07-02T22:45:01Z")
Excellent Vicio, thanks for putting all of this together! ---
**Author:** ![JackVaughan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jackvaughan/32/49023_2.png) [@JackVaughan](https://community.glideapps.com/u/JackVaughan)\ **Post date:** [July 3, 2020, 6:44am UTC](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458/20 "2020-07-03T06:44:48Z")
Nice one guys - I hope I can stay a little longer next time 😂. Didn’t time that so well 😉 [Next page](https://community.glideapps.com/t/community-meetup-thu-july-2-19-00-cet-glide-apis/11458.md?page=2)