# Is there a API request to fetch all rows?

**URL:** https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989
**Category:** Ask for Help
**Created:** [June 12, 2022, 9:04am UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989 "2022-06-12T09:04:29Z")
**Posts on this page:** 16
**Page:** 1

<div class="post-metadata">

### Author: ![P\_Redjo](https://avatars.discourse-cdn.com/v4/letter/p/b9bd4f/32.png) [@P\_Redjo](https://community.glideapps.com/u/P_Redjo)
#### Post date: [June 12, 2022, 9:04am UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/1 "2022-06-12T09:04:30Z")

</div>

I see that there is data API for Add row, Set Columns, Delete Row. Is there a similar request for fetching all Glide table rows from outside Glide?

---

<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: [June 12, 2022, 9:31am UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/2 "2022-06-12T09:31:29Z")

</div>

There is, but at this point in time it’s only available to Enterprise customers. I’m not sure if there are any plans to open it to other customers once the new pricing structure fully kicks in. @DJP might be able to comment on that.

---

<div class="post-metadata">

### Author: ![P\_Redjo](https://avatars.discourse-cdn.com/v4/letter/p/b9bd4f/32.png) [@P\_Redjo](https://community.glideapps.com/u/P_Redjo)
#### Post date: [June 12, 2022, 10:51am UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/3 "2022-06-12T10:51:40Z")

</div>

Thank you Darren for the info. I was thinking of automating the data synchronization between a Glide app and the backend DB (not via Mate/Zapier). But it is not essential and I can use a workaround. Cheers!

---

<div class="post-metadata">

### 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: [June 12, 2022, 1:06pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/4 "2022-06-12T13:06:52Z")

</div>

Agreed…would be nice if the full API became available to non-enterprise customers.

---

<div class="post-metadata">

### Author: ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)
#### Post date: [June 12, 2022, 2:08pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/5 "2022-06-12T14:08:52Z")

</div>

In one thread about the new pricing, it was mentioned that it should already be available to non-enterprise customers, and they were going to fix the links? @DJP, do you have a recollection of this conversation?

> [@new All-New Team Plans Coming Thursday, April 21st](https://community.glideapps.com/t/all-new-team-plans-coming-thursday-april-21st/40912/195):
>
> The Read function is included on the Pro team plan. Let me make an update to that tooltip Right now, we only have the feature to read all rows. Reading a subset of rows is not currently available

---

<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: [June 12, 2022, 2:21pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/6 "2022-06-12T14:21:15Z")

</div>

ah, nice. I stand corrected.

---

<div class="post-metadata">

### Author: ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)
#### Post date: [June 12, 2022, 2:23pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/7 "2022-06-12T14:23:30Z")

</div>

Well, I don’t have a new paid plan to check for this availability (waiting for them to announce the discount to move my pro app over), but on my current pro plan on the old plan, I do not currently have access to the read API.

---

<div class="post-metadata">

### 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: [June 12, 2022, 5:53pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/8 "2022-06-12T17:53:12Z")

</div>

From what I’ve seen it isn’t available yet unless I’m missing it.

---

<div class="post-metadata">

### Author: ![P\_Redjo](https://avatars.discourse-cdn.com/v4/letter/p/b9bd4f/32.png) [@P\_Redjo](https://community.glideapps.com/u/P_Redjo)
#### Post date: [June 13, 2022, 1:57am UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/9 "2022-06-13T01:57:12Z")

</div>

Great to be able to read from 3rd party even if it is just to read one whole table. We can still retrieve the set of required info using relation columns and joined lists. This really opens many opportunities for collaboration with enterprise db’s. The backend can actively check the Glide tables and update them selectively. Thanks people!

---

<div class="post-metadata">

### Author: ![DJP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/djp/32/62545_2.png) [@DJP](https://community.glideapps.com/u/DJP)
#### Post date: [June 21, 2022, 6:39pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/10 "2022-06-21T18:39:02Z")

</div>

Hello, all! Sorry for the late reply

The Read function will be included on the Pro team plan, which will allow you to read an entire table. As Robert pointed out, it is not available yet, but stay tuned!

---

<div class="post-metadata">

### Author: ![P\_Redjo](https://avatars.discourse-cdn.com/v4/letter/p/b9bd4f/32.png) [@P\_Redjo](https://community.glideapps.com/u/P_Redjo)
#### Post date: [June 22, 2022, 3:46am UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/11 "2022-06-22T03:46:36Z")

</div>

Thanks for the confirmation! Looking forward to it.

---

<div class="post-metadata">

### Author: ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)
#### Post date: [September 7, 2022, 4:14pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/12 "2022-09-07T16:14:18Z")

</div>

any update on this ?

---

<div class="post-metadata">

### Author: ![DJP](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/djp/32/62545_2.png) [@DJP](https://community.glideapps.com/u/DJP)
#### Post date: [September 7, 2022, 4:28pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/13 "2022-09-07T16:28:50Z")

</div>

Hey, Liam!

Yes, there is an update on this. It is currently available on the Business tier. You can see “Glide Advanced API” on our [Pricing Page](https://www.glideapps.com/pricing).

---

<div class="post-metadata">

### Author: ![liam\_putra](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/liam_putra/32/46372_2.png) [@liam\_putra](https://community.glideapps.com/u/liam_putra)
#### Post date: [September 7, 2022, 5:14pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/14 "2022-09-07T17:14:39Z")

</div>

i thought it will be available on the PRO plan ?

---

<div class="post-metadata">

### Author: ![Sean\_Martin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sean_martin/32/57816_2.png) [@Sean\_Martin](https://community.glideapps.com/u/Sean_Martin)
#### Post date: [September 7, 2022, 6:10pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/15 "2022-09-07T18:10:52Z")

</div>

Api access is available on the Pro plan. The ability to Get All Rows (read) is only available on Business and Enterprise plans. If you’d like to chat more about these plans feel free to PM me and we can set up a zoom.

---

<div class="post-metadata">

### Author: ![David\_Gabler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david_gabler/32/44332_2.png) [@David\_Gabler](https://community.glideapps.com/u/David_Gabler)
#### Post date: [September 25, 2022, 7:31pm UTC](https://community.glideapps.com/t/is-there-a-api-request-to-fetch-all-rows/42989/16 "2022-09-25T19:31:46Z")

</div>

> [@liam\_putra](#):
>
> i thought it will be available on the PRO plan

I did too. This isn’t the only place it was mentioned. I’d seen it in other threads that the READ would be available on the PRO plan. Disappointing, as $250/mo is beyond the budget for my app, and I sure could have used that READ access. UPDATE just isn’t very useful without some way to READ what’s already there. DELETE and ADD are also less useful.
