# Glide Read Rows API

**URL:** <https://community.glideapps.com/t/glide-read-rows-api/62738>\
**Category:** Ask for Help\
**Created:** [June 14, 2023, 6:12am UTC](https://community.glideapps.com/t/glide-read-rows-api/62738 "2023-06-14T06:12:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alaap\_Kanchwala](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alaap_kanchwala/32/37980_2.png) [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)\
**Post date:** [June 14, 2023, 6:12am UTC](https://community.glideapps.com/t/glide-read-rows-api/62738/1 "2023-06-14T06:12:04Z")

</div>

Hello all, I am trying to read all my rows out of a big table. This said big table has 20k rows, yet when i get the API JSON response fro all my rows in that table, I only get a response containing the first 10k rows. Is there any work around this?

Here is my code, written for run in google apps script:

function readGlideAppRows() {  
var url = ‘[https://api.glideapp.io/api/function/queryTables](https://api.glideapp.io/api/function/queryTables)’;  
var headers = {  
‘Content-Type’: ‘application/json’,  
‘Authorization’: ‘Bearer 006e44ef-39d3-4bb2\*\*\*\*\*\*\*’  
};  
var payload = {  
“appID”: “zvDeo8IUE\*\*\*\*\*\*\*”,  
“queries”: [  
{  
“tableName”: “native-table-ba0e1a5f-b661-4408-b38\*\*\*\*\*\*\*\*\*88”  
}  
]  
};

var options = {  
‘method’: ‘post’,  
‘headers’: headers,  
‘payload’: JSON.stringify(payload)  
};

var response = UrlFetchApp.fetch(url, options);  
var responseData = JSON.parse(response.getContentText());

console.log(responseData[0][‘rows’].length);

// Handle the responseData here  
}

@Darren_Alderman

@Robert_Petitto

---

<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 14, 2023, 6:17am UTC](https://community.glideapps.com/t/glide-read-rows-api/62738/2 "2023-06-14T06:17:10Z")

</div>

This is covered in the [documentation](https://www.glideapps.com/docs/reference/data-sources/using-glide-tables-api#queries).

In a case like this, the API response should contain a `next` parameter. You should make a subsequent call, passing a `startAt` value of whatever the `next` value was. Keep doing that until there is no `next` in the response.

Please note that filtered queries are now supported (Big Tables only), and the use of these is also covered in the docs.

---

<div class="post-metadata">

**Author:** ![Alaap\_Kanchwala](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/alaap_kanchwala/32/37980_2.png) [@Alaap\_Kanchwala](https://community.glideapps.com/u/Alaap_Kanchwala)\
**Post date:** [June 14, 2023, 6:27am UTC](https://community.glideapps.com/t/glide-read-rows-api/62738/3 "2023-06-14T06:27:47Z")

</div>

Thank you so much!

---

<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:** [June 15, 2023, 6:28am UTC](https://community.glideapps.com/t/glide-read-rows-api/62738/4 "2023-06-15T06:28:47Z")

</div>

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