# Datastore list of records through API **URL:** \ **Category:** Questions\ **Tags:** data-store, make-api, api\ **Created:** [June 14, 2024, 6:36am UTC](https://community.make.com/t/datastore-list-of-records-through-api/41671 "2024-06-14T06:36:21Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![fergotz](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/fergotz/32/30863_2.png) [@fergotz](https://community.make.com/u/fergotz)\ **Post date:** [June 14, 2024, 6:36am UTC](https://community.make.com/t/datastore-list-of-records-through-api/41671/1 "2024-06-14T06:36:21Z")
**API Call to Make’s Datastore with a default limit of records** I am trying to make an API request using the HTTP module to get all the records from a data store I have in my account. The problem is that, even though the datastore has 19+ records, and the call actually recognizes that indeed we have 19+records, it only show 10 records. I have tried using the url without a limit parameter and with a limit parameter of 1,000 and I still get just 10 rows on the request. Anybody have any idea how to not have that limit? ![Captura de pantalla 2024-06-14 002757](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/b/2/b222380fe3f88a0d58c62c622ee55bce2e928b38.png) ---
**Author:** ![Henk-Blue\_Marker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/henk-blue_marker/32/89127_2.png) [@Henk-Blue\_Marker](https://community.make.com/u/Henk-Blue_Marker)\ **Post date:** [June 14, 2024, 7:13am UTC](https://community.make.com/t/datastore-list-of-records-through-api/41671/2 "2024-06-14T07:13:55Z")
Hi @fergotz, The total count of your request is 19. The limit _per page returned_ is 10 results. (so not a limit in total). There are two things you can do; you can ask for the next page, that contains the next 10 results (which in this case would only return 9) and get all 19 results with two API calls. Or you can use the `pg[]` path parameters to increase the limit per page. The URL then looks like: ```auto https://www.us1.make.com/api/v2/data-stores/42373/data?pg[100] ``` The maximum amount of results per page is 100, so adding a limit of 1000 won’t work. See: [https://www.make.com/en/api-documentation/data-stores-dataStoreId-data-get](https://www.make.com/en/api-documentation/data-stores-dataStoreId-data-get) Cheers, Henk ---
**Author:** ![Henk-Blue\_Marker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/henk-blue_marker/32/89127_2.png) [@Henk-Blue\_Marker](https://community.make.com/u/Henk-Blue_Marker)\ **Post date:** [June 14, 2024, 7:19am UTC](https://community.make.com/t/datastore-list-of-records-through-api/41671/3 "2024-06-14T07:19:46Z")
Also, is there a reason you do not use the default Data Store app? ---
**Author:** ![fergotz](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/fergotz/32/30863_2.png) [@fergotz](https://community.make.com/u/fergotz)\ **Post date:** [June 14, 2024, 2:18pm UTC](https://community.make.com/t/datastore-list-of-records-through-api/41671/4 "2024-06-14T14:18:10Z")
Thankyou! The actual use case for this API Call is by calling it on PowerBi. I just shared it on Make for easier understanding and it was part of my testing. So for each page I should make the call. Is thats correct? But how would I specify to retrieve the next page of the data store? Is it a different datastoreID? ---
**Author:** ![Henk-Blue\_Marker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/henk-blue_marker/32/89127_2.png) [@Henk-Blue\_Marker](https://community.make.com/u/Henk-Blue_Marker)\ **Post date:** [June 15, 2024, 5:44am UTC](https://community.make.com/t/datastore-list-of-records-through-api/41671/5 "2024-06-15T05:44:44Z")
Alright, that makes perfect sense! Excuse me, I made a mistake in the URL I gave you. It should be formatted as such: `https://www.us1.make.com/api/v2/data-stores/42373/data?pg[limit]=100` The query to the endpoint accepts a `pg[offset]` parameter too. The index starts at 0, so if you request `?pg[offset]=0`, you will get the first page. You can use this parameter to retrieve following pages by increasing the `pg[offset]` parameter. With a calculation based on the `count` key that is returned in each response. By dividing the count by the page limit you’ve set, you’ll know how many pages there are. Hope this helps! Cheers, Henk ---
**Author:** ![Henk-Blue\_Marker](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/henk-blue_marker/32/89127_2.png) [@Henk-Blue\_Marker](https://community.make.com/u/Henk-Blue_Marker)\ **Post date:** [June 15, 2024, 6:10am UTC](https://community.make.com/t/datastore-list-of-records-through-api/41671/6 "2024-06-15T06:10:24Z")
So it would look like this btw: `https://www.us1.make.com/api/v2/data-stores/42373/data?pg[limit]=100&pg[offset]=0` ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [June 28, 2024, 2:19pm UTC](https://community.make.com/t/datastore-list-of-records-through-api/41671/7 "2024-06-28T14:19:05Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.