# Jq (JSON transformation) Column

**URL:** <https://community.glideapps.com/t/jq-json-transformation-column/31749>\
**Category:** Ask for Help\
**Tags:** custom-code\
**Created:** [September 14, 2021, 2:19am UTC](https://community.glideapps.com/t/jq-json-transformation-column/31749 "2021-09-14T02:19:52Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [September 14, 2021, 2:19am UTC](https://community.glideapps.com/t/jq-json-transformation-column/31749/1 "2021-09-14T02:19:52Z")

</div>

Based on [Fetch Column](https://community.glideapps.com/t/fetch-column/31731), I made the column [column.sh/jq](https://column.sh/jq), which lets you simply transform columns of JSON data (without fetching):

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/8/987afcbe76c021000354032a9c45561b45b412aa.png)

---

<div class="post-metadata">

**Author:** ![phong\_tran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phong_tran/32/32160_2.png) [@phong\_tran](https://community.glideapps.com/u/phong_tran)\
**Post date:** [September 14, 2021, 7:28am UTC](https://community.glideapps.com/t/jq-json-transformation-column/31749/2 "2021-09-14T07:28:53Z")

</div>

Can you guide me how to translate?

---

<div class="post-metadata">

**Author:** ![phong\_tran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phong_tran/32/32160_2.png) [@phong\_tran](https://community.glideapps.com/u/phong_tran)\
**Post date:** [September 14, 2021, 7:30am UTC](https://community.glideapps.com/t/jq-json-transformation-column/31749/3 "2021-09-14T07:30:14Z")

</div>

Can you tell me the URL code?

---

<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:** [September 14, 2021, 11:26am UTC](https://community.glideapps.com/t/jq-json-transformation-column/31749/4 "2021-09-14T11:26:48Z")

</div>

The URL is in the image.

```auto
https://jq.column.sh

```

It’s not a translate column, it’s a coincidence that David has this JSON with a Japanese name of the Pokemon, and he wants to retrieve that here.

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [September 14, 2021, 1:28pm UTC](https://community.glideapps.com/t/jq-json-transformation-column/31749/5 "2021-09-14T13:28:57Z")

</div>

I moved the column to [https://column.sh/jq](https://column.sh/jq) to make it easier to manage many of them.

---

<div class="post-metadata">

**Author:** ![phong\_tran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phong_tran/32/32160_2.png) [@phong\_tran](https://community.glideapps.com/u/phong_tran)\
**Post date:** [September 15, 2021, 4:54am UTC](https://community.glideapps.com/t/jq-json-transformation-column/31749/6 "2021-09-15T04:54:21Z")

</div>

I’m too bad to know how to use it 😭