# What are your use-cases for the JSON Column? **URL:** \ **Category:** Ask for Help\ **Created:** [February 28, 2024, 9:39am UTC](https://community.glideapps.com/t/what-are-your-use-cases-for-the-json-column/71247 "2024-02-28T09:39:38Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [February 28, 2024, 9:39am UTC](https://community.glideapps.com/t/what-are-your-use-cases-for-the-json-column/71247/1 "2024-02-28T09:39:38Z")
Reading how the JSON column works, I understand. But how do you use this or how do you plan to use this? What are your use cases? Thanks in advance! ---
**Author:** ![burningmikey](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/burningmikey/32/49706_2.png) [@burningmikey](https://community.glideapps.com/u/burningmikey)\ **Post date:** [February 28, 2024, 1:18pm UTC](https://community.glideapps.com/t/what-are-your-use-cases-for-the-json-column/71247/2 "2024-02-28T13:18:44Z")
I use it to create JSONs that I then write into a text column. Here is how I use the hard-written JSONs: - Horizontal aggregation: instead of having many columns with data, I aggregate the data in one JSON column. Then I use javascript functions to work on these data, which return another json containing the results I need. I then do a query JSON to retrieve each result. - Vertical aggregation: You can also aggregate each JSON (for each row) at a table level, to work with a master JSON that you can filter, or use to produce new aggregated results etc. - Structured data to send to [make.com](http://make.com) It’s not exhaustive, I’m sure experts have of other ways to use it. ---
**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:** [February 29, 2024, 12:21am UTC](https://community.glideapps.com/t/what-are-your-use-cases-for-the-json-column/71247/3 "2024-02-29T00:21:41Z")
That’s a good write-up and I don’t think I have more to add. I use vertical aggregation a lot, particularly when I have to send it to a third-party service like Make for further processing. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [February 29, 2024, 12:43pm UTC](https://community.glideapps.com/t/what-are-your-use-cases-for-the-json-column/71247/4 "2024-02-29T12:43:47Z")
Thanks all! Hoping for a @Robert_Petitto video too! ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [February 29, 2024, 1:12pm UTC](https://community.glideapps.com/t/what-are-your-use-cases-for-the-json-column/71247/5 "2024-02-29T13:12:08Z")
Already did! [![](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea5efb694429220400288978917de8bf1457c961.jpeg "Glide 101: EVERYTHING You Need to Know About Call API and Query JSON") ](https://www.youtube.com/watch?v=7F4e9JatqeM&t=690) Use the JSON object column to craft your own JSON object built from columns within your table before sending it off to Make or using it in a API call. ---
**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\ **Post date:** [February 29, 2024, 1:27pm UTC](https://community.glideapps.com/t/what-are-your-use-cases-for-the-json-column/71247/6 "2024-02-29T13:27:01Z")
Hero!