# Use Google place api to fill in information about an establishment

**URL:** <https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974>\
**Category:** Ask for Help\
**Created:** [November 23, 2021, 4:35pm UTC](https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974 "2021-11-23T16:35:40Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thomas\_Siegwald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_siegwald/32/34970_2.png) [@Thomas\_Siegwald](https://community.glideapps.com/u/Thomas_Siegwald)\
**Post date:** [November 23, 2021, 4:35pm UTC](https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974/1 "2021-11-23T16:35:40Z")

</div>

Hi everybody !  
I am currently playing with Glide and the Google place api.

Today, I have the name and address of an establishment, I would like that with this information, I manage to make an API request of the API google place, so that it completes me the other information (schedules, telephones, etc)

I can do the first part, from the name and address, find the place\_id, then make the request and have all the information.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/c/bc7dc485c8cf33bb6100d2a2e3e85073156d0d2e.png)

Where I get stuck: retrieve the answer from the first query to get the place\_id and place this place\_id in a specific column. (But I guess when I can do that, I can do the next thing)

And then, once I have my query with the place\_id, associate the values of the response to the right columns.

Is this possible? And if so, could you help me?

Edit : Here is what I get from the request to get the place\_id

```auto
{
   "predictions" : [
      {
         "description" : "Barabaar, 4 Bd des Brotteaux, 69006 Lyon, France",
         "matched_substrings" : [
            {
               "length" : 8,
               "offset" : 0
            },
            {
               "length" : 16,
               "offset" : 12
            },
            {
               "length" : 5,
               "offset" : 30
            },
            {
               "length" : 4,
               "offset" : 36
            }
         ],
         "place_id" : "ChIJRT8dL4zq9EcRp8tR4U6yxis",
         "reference" : "ChIJRT8dL4zq9EcRp8tR4U6yxis",
         "structured_formatting" : {
            "main_text" : "Barabaar",
            "main_text_matched_substrings" : [
               {
                  "length" : 8,
                  "offset" : 0
               }
            ],
            "secondary_text" : "4 Bd des Brotteaux, 69006 Lyon, France",
            "secondary_text_matched_substrings" : [
               {
                  "length" : 16,
                  "offset" : 2
               },
               {
                  "length" : 5,
                  "offset" : 20
               },
               {
                  "length" : 4,
                  "offset" : 26
               }
            ]
         },
         "terms" : [
            {
               "offset" : 0,
               "value" : "Barabaar"
            },
            {
               "offset" : 10,
               "value" : "4 Bd des Brotteaux"
            },
            {
               "offset" : 30,
               "value" : "69006"
            },
            {
               "offset" : 36,
               "value" : "Lyon"
            },
            {
               "offset" : 42,
               "value" : "France"
            }
         ],
         "types" : ["bar", "restaurant", "food", "point_of_interest", "establishment"]
      }
   ],
   "status" : "OK"
}

```

thanks in advance!

Sincerely,  
Thomas

---

<div class="post-metadata">

**Author:** ![Thomas\_Siegwald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_siegwald/32/34970_2.png) [@Thomas\_Siegwald](https://community.glideapps.com/u/Thomas_Siegwald)\
**Post date:** [November 23, 2021, 4:38pm UTC](https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974/2 "2021-11-23T16:38:36Z")

</div>

Hi again

I saw this vidéo : [Get Part of URL column • Glide](https://www.glideapps.com/plugins/url-parts)

I’ve moved on, I can do it, like in the video above.

It works for Chuck Norris jokes, but not for Google place ☹

Any idea why?

---

<div class="post-metadata">

**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:** [November 23, 2021, 11:45pm UTC](https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974/3 "2021-11-23T23:45:32Z")

</div>

So you already have the result of the request in Glide and now what you want is to extract info out?

---

<div class="post-metadata">

**Author:** ![Thomas\_Siegwald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_siegwald/32/34970_2.png) [@Thomas\_Siegwald](https://community.glideapps.com/u/Thomas_Siegwald)\
**Post date:** [November 24, 2021, 8:41am UTC](https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974/4 "2021-11-24T08:41:41Z")

</div>

Hello,

I’m not sure if this is a good idea or not, but I’m not sure if it’s a good idea to use the google place api in Glide for 2 reasons:

- Core problem

- " `https://maps.googleapis.com/maps/api` doesn’t support getting requests from frontend JavaScript running in web apps in the way your code is trying to use it.  
Instead you must use the supported [Google Maps JavaScript API](https://developers.google.com/maps/documentation/javascript/tutorial), the client-side code for which is different from what you’re trying"

I’ll find another way

---

<div class="post-metadata">

**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\
**Post date:** [November 24, 2021, 1:19pm UTC](https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974/5 "2021-11-24T13:19:35Z")

</div>

Hola @Thomas_Siegwald

You can use replit or GitHub to write your code, then just use the Experimental code column to paste the link from replit/GitHub and get exactly what you need.

---

<div class="post-metadata">

**Author:** ![Thomas\_Siegwald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_siegwald/32/34970_2.png) [@Thomas\_Siegwald](https://community.glideapps.com/u/Thomas_Siegwald)\
**Post date:** [November 24, 2021, 1:25pm UTC](https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974/6 "2021-11-24T13:25:08Z")

</div>

Hi @SantiagoPerez ,

Thank you for your feedback,

I don’t understand, what do you mean?

I just wanted to parse the JSON I got from my query, but Google blocks the use of it, I can’t do anything about it ☹

I don’t have a script or a code! Just an Url that I build via my different columns

---

<div class="post-metadata">

**Author:** ![Thomas\_Siegwald](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thomas_siegwald/32/34970_2.png) [@Thomas\_Siegwald](https://community.glideapps.com/u/Thomas_Siegwald)\
**Post date:** [November 24, 2021, 1:38pm UTC](https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974/7 "2021-11-24T13:38:42Z")

</div>

Ah Yes, I see

I test and I come back

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 25, 2021, 1:39pm UTC](https://community.glideapps.com/t/use-google-place-api-to-fill-in-information-about-an-establishment/34974/8 "2021-11-25T13:39:03Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.