# JSON data to display in the list

**URL:** <https://community.glideapps.com/t/json-data-to-display-in-the-list/73223>\
**Category:** Ask for Help\
**Created:** [May 9, 2024, 5:03pm UTC](https://community.glideapps.com/t/json-data-to-display-in-the-list/73223 "2024-05-09T17:03:42Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Darko\_Vukoje](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darko_vukoje/32/73227_2.png) [@Darko\_Vukoje](https://community.glideapps.com/u/Darko_Vukoje)\
**Post date:** [May 9, 2024, 5:03pm UTC](https://community.glideapps.com/t/json-data-to-display-in-the-list/73223/1 "2024-05-09T17:03:42Z")

</div>

I saw the similar topic - but asking here again.

My app gets a response from server, it is JSON array and each array item contains:

Player1ID, Player2ID, MatchDate/Time, CourtID

I want to display this is the collection.

I probably need to do it over helper table, but how to parse JSON into my items? I am not aware of any JSON parser in Glide.

Thanks

---

<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:** [May 9, 2024, 5:29pm UTC](https://community.glideapps.com/t/json-data-to-display-in-the-list/73223/2 "2024-05-09T17:29:49Z")

</div>

Yes, you will need to use a Helper Table with numbered rows.  
You can use the JSON Query column to extract the object properties.  
If you have any problems, share a sample of the JSON and somebody will help.

---

<div class="post-metadata">

**Author:** ![Darko\_Vukoje](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darko_vukoje/32/73227_2.png) [@Darko\_Vukoje](https://community.glideapps.com/u/Darko_Vukoje)\
**Post date:** [May 11, 2024, 6:17am UTC](https://community.glideapps.com/t/json-data-to-display-in-the-list/73223/3 "2024-05-11T06:17:33Z")

</div>

I created helper table, received my json, but struggling to convert JSON array into Glide array. I tried js column but it seems that Glide doesn’t allow returning array so Glide creates array column.

I tried split text '},{" but I feel there might be some better and cleaner solution.

@Darren_Murphy , please help 🙂

Here is my json that I need to convert to Glide array in helper table:

```auto
[
    {
        "player1ID": "dnDEeNNPQNyEhCGpaAyBhQ",
        "player2ID": "tHGxFNjDQl2YkPd0ga2ZYQ",
        "dayPlayed": "1",
        "hourPlayed": "15",
        "courtID": "vIMfQHxSaJFU8ogpAr0v"
    },
    {
        "player1ID": "Od9fmlcnSvWKXjhr9WrJpQ",
        "player2ID": "LDY-2YUXQj2feUUgE57xQw",
        "dayPlayed": "3",
        "hourPlayed": "18",
        "courtID": "Zk6uhkn9YXzh123c7Pra"
    },
    {
        "player1ID": "NEpViJIiTcmloNcihgkANQ",
        "player2ID": "a-y0ruSKNQguwK-4x5.VUyQw",
        "dayPlayed": "2",
        "hourPlayed": "20",
        "courtID": "BG4G07LVpEvs5c9Bc3SI"
    }
]

```

---

<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:** [May 11, 2024, 6:26am UTC](https://community.glideapps.com/t/json-data-to-display-in-the-list/73223/4 "2024-05-11T06:26:25Z")

</div>

```auto
let json = JSON.parse(p1);
return json[p2].player1ID;

```

 ![CleanShot 2024-05-11 at 14.25.22@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/b/0bdc5b32b0d7d55265563f9c6662b456de725437.png)

Obviously you’ll need a separate column for each value.  
You could also use the Query JSON column, but I find it just as easy to use JavaScript for simple cases like this.

---

<div class="post-metadata">

**Author:** ![Darko\_Vukoje](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darko_vukoje/32/73227_2.png) [@Darko\_Vukoje](https://community.glideapps.com/u/Darko_Vukoje)\
**Post date:** [May 11, 2024, 7:30am UTC](https://community.glideapps.com/t/json-data-to-display-in-the-list/73223/5 "2024-05-11T07:30:33Z")

</div>

I know this but need to create array out of json as i use the array for dynamic number of rows in helper table as per you helper table help

---

<div class="post-metadata">

**Author:** ![Darko\_Vukoje](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darko_vukoje/32/73227_2.png) [@Darko\_Vukoje](https://community.glideapps.com/u/Darko_Vukoje)\
**Post date:** [May 11, 2024, 7:49am UTC](https://community.glideapps.com/t/json-data-to-display-in-the-list/73223/6 "2024-05-11T07:49:02Z")

</div>

I currently made it work by splitting json array with } into array and then got helper rows each containing a single match

---

<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:** [May 11, 2024, 8:43am UTC](https://community.glideapps.com/t/json-data-to-display-in-the-list/73223/7 "2024-05-11T08:43:53Z")

</div>

oh, sorry I misunderstood. Do you mean like this?

```auto
let json = JSON.parse(p1);
return JSON.stringify(json[p2])

```

 ![CleanShot 2024-05-11 at 16.43.09@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cfa54c17c2c2517df0b762ceaee177a26d4f4a07.png)

---

<div class="post-metadata">

**Author:** ![Darko\_Vukoje](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darko_vukoje/32/73227_2.png) [@Darko\_Vukoje](https://community.glideapps.com/u/Darko_Vukoje)\
**Post date:** [May 11, 2024, 9:43am UTC](https://community.glideapps.com/t/json-data-to-display-in-the-list/73223/8 "2024-05-11T09:43:28Z")

</div>

Very elegant. thanks