# Query JSON just showing an "A"

**URL:** <https://community.glideapps.com/t/query-json-just-showing-an-a/75633>\
**Category:** Ask for Help\
**Created:** [August 14, 2024, 8:09am UTC](https://community.glideapps.com/t/query-json-just-showing-an-a/75633 "2024-08-14T08:09:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\
**Post date:** [August 14, 2024, 8:09am UTC](https://community.glideapps.com/t/query-json-just-showing-an-a/75633/1 "2024-08-14T08:09:57Z")

</div>

The data is sensitive so hesitant to post the JSON itself. It works fine in the query JSON column in Glide however in the button it does this: ![Screenshot 2024-08-14 100601](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/7/370c42ec25a00c43f2aab31b28b21c4aaf72be9b.png) .

We’ve found the action to be more reliable in the column however it is not letting us pull any values. Anyone else experience this issue and know how to fix?

---

<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:** [August 14, 2024, 9:20am UTC](https://community.glideapps.com/t/query-json-just-showing-an-a/75633/2 "2024-08-14T09:20:16Z")

</div>

I saw this the other day while I was experimenting with some stuff.  
I didn’t spend too much time worrying about it, but I did find a workaround, which was to write the JSON to the same table that I was trying to Query it from. Maybe that will work for you.

---

<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:** [August 14, 2024, 11:31pm UTC](https://community.glideapps.com/t/query-json-just-showing-an-a/75633/3 "2024-08-14T23:31:18Z")

</div>

Is there a reason why you don’t use it as a column, but as an action?

---

<div class="post-metadata">

**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\
**Post date:** [August 19, 2024, 4:48pm UTC](https://community.glideapps.com/t/query-json-just-showing-an-a/75633/4 "2024-08-19T16:48:25Z")

</div>

[Why Does the Call API Action in Glide Seem to Cache Data? | Glide Help Center](https://help.glideapps.com/en/articles/9623330-why-does-the-call-api-action-in-glide-seem-to-cache-data) this exact article but the query json column instead of the json object/template column

---

<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:** [August 19, 2024, 11:53pm UTC](https://community.glideapps.com/t/query-json-just-showing-an-a/75633/5 "2024-08-19T23:53:36Z")

</div>

Thanks for sharing!