# Have a Query: Regarding Get API response

**URL:** <https://community.glideapps.com/t/have-a-query-regarding-get-api-response/77347>\
**Category:** Ask for Help\
**Created:** [October 26, 2024, 10:50am UTC](https://community.glideapps.com/t/have-a-query-regarding-get-api-response/77347 "2024-10-26T10:50:45Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [October 26, 2024, 10:50am UTC](https://community.glideapps.com/t/have-a-query-regarding-get-api-response/77347/1 "2024-10-26T10:50:45Z")

</div>

Hi Guys,

I have followed the video

[![](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=944s)

And I am fetching the response of the API

My response is as follows

```auto
[
  {
    "text": "Hi, this kurti from?",
    "created_at": "Wed, 17 Apr 2024 03:00:41 GMT",
    "sentiment": 0,
    "like_count": 0,
    "commenter": "@soniasingh9798"
  },
  {
    "text": "Ap long hair mein jyada achhe lagte ho",
    "created_at": "Tue, 16 Apr 2024 10:06:40 GMT",
    "sentiment": 0,
    "like_count": 4,
    "commenter": "@meghanadesai4730"
  },
  {
    "text": "What you think about your family planning 🤔",
    "created_at": "Tue, 16 Apr 2024 16:40:28 GMT",
    "sentiment": 0,
    "like_count": 0,
    "commenter": "@KanchanSingh-ic4fy"
  },
  {
    "text": "Uh explained very well ❤you r my fav❤ i loved your dressing sense❤❤",
    "created_at": "Tue, 16 Apr 2024 14:17:49 GMT",
    "sentiment": 1,
    "like_count": 0,
    "commenter": "@bhpdecencysagar"
  },
  {
    "text": "Your hair looks great!! Loving the colour on you 🎉",
    "created_at": "Tue, 16 Apr 2024 10:05:56 GMT",
    "sentiment": 1,
    "like_count": 7,
    "commenter": "@akshitarmundhra1830"
  },
  {
    "text": "Prerna di you are the inspiration ❤",
    "created_at": "Tue, 16 Apr 2024 13:08:13 GMT",
    "sentiment": 1,
    "like_count": 0,
    "commenter": "@shinewithamu9921"
  },
  {
    "text": "Hey gorgeous Prerna you look stunning in this suit. Plz share details of this outfit",
    "created_at": "Wed, 17 Apr 2024 07:05:04 GMT",
    "sentiment": 1,
    "like_count": 0,
    "commenter": "@yuvdhruv6739"
  },
  {
    "text": "This is not even supplement....there is doubt over how much if it actually gets absorbed",
    "created_at": "Wed, 17 Apr 2024 03:53:33 GMT",
    "sentiment": 0,
    "like_count": 0,
    "commenter": "@reet25meet"
  },
  {
    "text": "❤❤❤",
    "created_at": "Tue, 16 Apr 2024 13:08:08 GMT",
    "sentiment": 1,
    "like_count": 0,
    "commenter": "@neelamchhabra3378"
  },
  {
    "text": "I take supplements too. And I I'm in love with the kurta you are wearing , can you u share from where have you purchased it?",
    "created_at": "Tue, 16 Apr 2024 11:55:06 GMT",
    "sentiment": 1,
    "like_count": 1,
    "commenter": "@prakratijain5118"
  },
  {
    "text": "Yeah Uk london main available hai kya? Is der any side effects ?",
    "created_at": "Tue, 16 Apr 2024 11:22:44 GMT",
    "sentiment": 0,
    "like_count": 2,
    "commenter": "@Unnati_Thakur04"
  },
  {
    "text": "Dress link plz..",
    "created_at": "Tue, 16 Apr 2024 21:03:47 GMT",
    "sentiment": 0,
    "like_count": 0,
    "commenter": "@muskansachora4773"
  },
  {
    "text": "Why u go fr paid promotion?",
    "created_at": "Tue, 16 Apr 2024 15:02:14 GMT",
    "sentiment": 0,
    "like_count": 0,
    "commenter": "@bindukai4999"
  },
  {
    "text": "Pehle bhi apke hair asche lgte the pr ye wale to look like celebrity",
    "created_at": "Tue, 16 Apr 2024 10:24:37 GMT",
    "sentiment": 0,
    "like_count": 1,
    "commenter": "@mayankrajsingh7651"
  },
  {
    "text": "Checkout my feed @riyubathija for fashion related content every alternate day👍",
    "created_at": 1672143081,
    "sentiment": 0,
    "like_count": 0,
    "commenter": "riyubathija"
  },
  {
    "text": "Land le le mera",
    "created_at": 1672744208,
    "sentiment": 0,
    "like_count": 0,
    "commenter": "thar __love__ india"
  },
  {
    "text": "To throw an epic christmas party ...1st - have enough MONEY 😂😂",
    "created_at": 1672131590,
    "sentiment": 0,
    "like_count": 0,
    "commenter": "lovelicious__143"
  },
  {
    "text": "No the most important thing is 1- have enough MONEY 😂😂😂",
    "created_at": 1672131524,
    "sentiment": 0,
    "like_count": 0,
    "commenter": "lovelicious__143"
  },
  {
    "text": "Earring pdetails plz",
    "created_at": 1671971899,
    "sentiment": 0,
    "like_count": 0,
    "commenter": "shwetavrinda"
  },
  {
    "text": "Red lips look fabulous on you",
    "created_at": 1671947448,
    "sentiment": 1,
    "like_count": 0,
    "commenter": "fashionistaspeaks"
  },
  {
    "text": "Purple Outfit from ?",
    "created_at": 1671910622,
    "sentiment": 0,
    "like_count": 0,
    "commenter": "muskanhasija18"
  }
]

```

**My doubt**

How can I make it such that parsed data is fed into each row in my table Meaning Each items is fed to different rows.

Right now I am able to have them coma separated in the single column.

I need to move each element into each rows so that I can display it as list view.

Also need to attach corresponding “sentiment” value in the next column

Thank you in advance for your help.

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [October 27, 2024, 11:32pm UTC](https://community.glideapps.com/t/have-a-query-regarding-get-api-response/77347/2 "2024-10-27T23:32:36Z")

</div>

Hi Guys,

I have successfully gotten this

I am able to get the Json response parsed which has

COmments , Sentiment score as shown in screenshot below

 ![Screenshot 2024-10-28 at 9.36.47 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/8/a8931d0569b7fde87ce1491dd8c9076e0fa83ccc.png)

I tried json query again but it gives me all Comments in single column.

 ![Screenshot 2024-10-28 at 9.36.58 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/2/22cb1e285cf51efcf8a94244e7d1a49a35bc4f48.png)

how do I make them write into seperate rows?

Thank you in advance.

Regards,  
Dilip

---

<div class="post-metadata">

**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\
**Post date:** [October 28, 2024, 7:16am UTC](https://community.glideapps.com/t/have-a-query-regarding-get-api-response/77347/3 "2024-10-28T07:16:17Z")

</div>

Hi Guys,

Read various posts and did take help of chat GPT help. Should I use Make or Zapier to achieve this?

There is nothing inbuilt in glide that I Can make use of ?

Regards,  
Dilip
