# Help formatting JSON using the FETCH JSON column

**URL:** <https://community.glideapps.com/t/help-formatting-json-using-the-fetch-json-column/58647>\
**Category:** Ask for Help\
**Created:** [March 1, 2023, 10:04pm UTC](https://community.glideapps.com/t/help-formatting-json-using-the-fetch-json-column/58647 "2023-03-01T22:04:42Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![JLeee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jleee/32/54680_2.png) [@JLeee](https://community.glideapps.com/u/JLeee)\
**Post date:** [March 1, 2023, 10:04pm UTC](https://community.glideapps.com/t/help-formatting-json-using-the-fetch-json-column/58647/1 "2023-03-01T22:04:42Z")

</div>

Hi all,

Im hoping you can help me, i am trying to set up the address auto complete however when i receive the JSON request back im struggling to get the .formatted sections of the request. See below the response;

Just looking for what to put in the JQ Query box. Thanks in advance!!

{“type”:“FeatureCollection”,“features”:[{“type”:“Feature”,“geometry”:{“type”:“Point”,“coordinates”:[-2.225573,53.305343]},“properties”:{“country\_code”:“gb”,“housenumber”:“12”,“street”:“Moss Road”,“country”:“United Kingdom”,“county”:“Cheshire”,“datasource”:{“sourcename”:“openstreetmap”,“attribution”:“© OpenStreetMap contributors”,“license”:“Open Database License”,“url”:“[https://www.openstreetmap.org/copyright"},“state”:“England”,“district”:"Alderley](https://www.openstreetmap.org/copyright%22%7D,%22state%22:%22England%22,%22district%22:%22Alderley) Edge”,“city”:“Alderley Edge”,“lon”:-2.225573,“lat”:53.305343,“state\_code”:“ENG”,“formatted”:“12 Moss Road, Alderley Edge, United Kingdom”,“address\_line1”:“12 Moss Road”,“address\_line2”:“Alderley Edge, United Kingdom”,“timezone”:{“name”:“Europe/London”,“offset\_STD”:“+00:00”,“offset\_STD\_seconds”:0,“offset\_DST”:“+01:00”,“offset\_DST\_seconds”:3600,“abbreviation\_STD”:“GMT”,“abbreviation\_DST”:“BST”},“result\_type”:“building”,“rank”:

---

<div class="post-metadata">

**Author:** ![JLeee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jleee/32/54680_2.png) [@JLeee](https://community.glideapps.com/u/JLeee)\
**Post date:** [March 1, 2023, 10:05pm UTC](https://community.glideapps.com/t/help-formatting-json-using-the-fetch-json-column/58647/2 "2023-03-01T22:05:36Z")

</div>

It doesnt seem to let me enter the full response however here is the request ;

[https://api.geoapify.com/v1/geocode/autocomplete?text=12%20moss%20road&apiKey=5c459ad6c77c42dc908ebb5ebd7d0af4](https://api.geoapify.com/v1/geocode/autocomplete?text=12%20moss%20road&apiKey=5c459ad6c77c42dc908ebb5ebd7d0af4)

---

<div class="post-metadata">

**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:** [March 1, 2023, 10:32pm UTC](https://community.glideapps.com/t/help-formatting-json-using-the-fetch-json-column/58647/3 "2023-03-01T22:32:56Z")

</div>

Hola,

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

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

Saludos!

---

<div class="post-metadata">

**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:** [March 2, 2023, 1:16am UTC](https://community.glideapps.com/t/help-formatting-json-using-the-fetch-json-column/58647/4 "2023-03-02T01:16:39Z")

</div>

Are you aware that you have shared your API key in a public forum?

---

<div class="post-metadata">

**Author:** ![JLeee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jleee/32/54680_2.png) [@JLeee](https://community.glideapps.com/u/JLeee)\
**Post date:** [March 2, 2023, 8:01am UTC](https://community.glideapps.com/t/help-formatting-json-using-the-fetch-json-column/58647/5 "2023-03-02T08:01:01Z")

</div>

Yes sir, this is a free trial and I will be changing the key

Thanks for looking out

---

<div class="post-metadata">

**Author:** ![JLeee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jleee/32/54680_2.png) [@JLeee](https://community.glideapps.com/u/JLeee)\
**Post date:** [March 2, 2023, 9:16pm UTC](https://community.glideapps.com/t/help-formatting-json-using-the-fetch-json-column/58647/6 "2023-03-02T21:16:58Z")

</div>

This worked i used .formatted at the end!! Thanks very much i appreciate both of you helping