# Join values of a field in a JSON array

**URL:** https://community.glideapps.com/t/join-values-of-a-field-in-a-json-array/65354
**Category:** Ask for Help
**Created:** [August 24, 2023, 4:05pm UTC](https://community.glideapps.com/t/join-values-of-a-field-in-a-json-array/65354 "2023-08-24T16:05:18Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Abhishek\_Sinha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abhishek_sinha/32/52361_2.png) [@Abhishek\_Sinha](https://community.glideapps.com/u/Abhishek_Sinha)
#### Post date: [August 24, 2023, 4:05pm UTC](https://community.glideapps.com/t/join-values-of-a-field-in-a-json-array/65354/1 "2023-08-24T16:05:19Z")

</div>

I get following array from a API query in JSON

```auto
{
    "category": [{
          "id": 28,
          "name": "Dogs"
      },
      {
          "id": 14,
          "name": "Cats"
      },
      {
          "id": 878,
          "name": "Sheep"
      }]
}

```

The output I need is a joined list - Dogs,Cats,Sheep  
I tried figuring it out with Javascript code and found some codes using .map but apparently those functions are not available.

Can someone help please ?

---

<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 24, 2023, 4:36pm UTC](https://community.glideapps.com/t/join-values-of-a-field-in-a-json-array/65354/2 "2023-08-24T16:36:55Z")

</div>

Use the Query JSON column:

```auto
$join(category.name,', ')

```

 ![CleanShot 2023-08-25 at 00.35.23@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/dfd289098b5d8e88518d7421f9602a0ac4b83f48.png)

---

<div class="post-metadata">

### Author: ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)
#### Post date: [August 24, 2023, 6:05pm UTC](https://community.glideapps.com/t/join-values-of-a-field-in-a-json-array/65354/3 "2023-08-24T18:05:57Z")

</div>

The method that Darren shared is great! Just tried with JS because you have mentioned that couldn’t do this with JS and I wanted to know if that is true! 🙌 😃  
( Hope I’m correct with the code! If not please let me know because love to fix them and learn! )

Here’s what I got! :

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/0/804068c9e49107edd0c665f19aef033228ef6def.png)

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/9/090cb2784e24baf10dcc3c250141684baefe3543.png)

JavaScript Code :

```auto
const categories = JSON.parse(p1);
const names = categories.category.map(category => category.name);
const csv = names.join(',');
return csv;

```

Thank 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 24, 2023, 11:53pm UTC](https://community.glideapps.com/t/join-values-of-a-field-in-a-json-array/65354/4 "2023-08-24T23:53:01Z")

</div>

You should start using JSONata if you get access to the column Darren mentioned. It’s much shorter than normal JS.

---

<div class="post-metadata">

### Author: ![Abhishek\_Sinha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abhishek_sinha/32/52361_2.png) [@Abhishek\_Sinha](https://community.glideapps.com/u/Abhishek_Sinha)
#### Post date: [August 25, 2023, 4:12pm UTC](https://community.glideapps.com/t/join-values-of-a-field-in-a-json-array/65354/5 "2023-08-25T16:12:19Z")

</div>

Perfect…it worked as you said…

---

<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: [September 1, 2023, 4:12pm UTC](https://community.glideapps.com/t/join-values-of-a-field-in-a-json-array/65354/6 "2023-09-01T16:12:21Z")

</div>

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