# API size limit?

**URL:** https://community.baserow.io/t/api-size-limit/1905
**Category:** Technical Help
**Created:** [December 17, 2022, 9:27pm UTC](https://community.baserow.io/t/api-size-limit/1905 "2022-12-17T21:27:25Z")
**Posts on this page:** 7
**Page:** 1

<div class="post-metadata">

### Author: ![R0GGER](https://community.baserow.io/user_avatar/community.baserow.io/r0gger/32/973_2.png) [@R0GGER](https://community.baserow.io/u/R0GGER)
#### Post date: [December 17, 2022, 9:27pm UTC](https://community.baserow.io/t/api-size-limit/1905/1 "2022-12-17T21:27:25Z")

</div>

Hi,

Could somebody help me out…?  
When I use this command I only get 100 results.

`curl -X GET -H "Authorization: Token **********" https://******* /api/database/rows/table/123/?user_field_names=true&size=150`

Temporally for testing I set BASEROW\_ROW\_PAGE\_SIZE\_LIMIT=400, still 100 results… ☹

---

<div class="post-metadata">

### Author: ![petrs](https://community.baserow.io/user_avatar/community.baserow.io/petrs/32/159_2.png) [@petrs](https://community.baserow.io/u/petrs)
#### Post date: [December 18, 2022, 10:43pm UTC](https://community.baserow.io/t/api-size-limit/1905/2 "2022-12-18T22:43:20Z")

</div>

Hi @R0GGER,

setting the `BASEROW_ROW_PAGE_SIZE_LIMIT` should indeed do the trick. How did you configure it? Are you sure there are more results in your table?

---

<div class="post-metadata">

### Author: ![R0GGER](https://community.baserow.io/user_avatar/community.baserow.io/r0gger/32/973_2.png) [@R0GGER](https://community.baserow.io/u/R0GGER)
#### Post date: [December 19, 2022, 12:33am UTC](https://community.baserow.io/t/api-size-limit/1905/3 "2022-12-19T00:33:59Z")

</div>

No, using `BASEROW_ROW_PAGE_SIZE_LIMIT` as an environment variable doesn’t work and btw by default the limit is 200. So 150 results shouldn’t be an issue…

A few findings after some hours testing:

- It looks like it’s a cURL issue in command-line via console. When I choose HTTP GET I don’t have this issue.
- Using the same cURL command via the [baserow.io](http://baserow.io) API ( [https://api.baserow.io/api/database/rows/table/\*\*\*\*/?user\_field\_names=true&size=150](https://api.baserow.io/api/database/rows/table/ **** /?user_field_names=true&size=150)), I get 100 results.  
(Tested on different Linux servers)

Can somebody help me out?

---

<div class="post-metadata">

### Author: ![petrs](https://community.baserow.io/user_avatar/community.baserow.io/petrs/32/159_2.png) [@petrs](https://community.baserow.io/u/petrs)
#### Post date: [December 19, 2022, 7:59am UTC](https://community.baserow.io/t/api-size-limit/1905/4 "2022-12-19T07:59:10Z")

</div>

> [@R0GGER](#):
>
> When I choose HTTP GET I don’t have this issue.

What do you mean by that? `cURL` can’t change the number of returned results, it could probably only limit the size of the response as a whole but then you wouldn’t get a proper JSON back, so that’s probably not it.

---

<div class="post-metadata">

### Author: ![R0GGER](https://community.baserow.io/user_avatar/community.baserow.io/r0gger/32/973_2.png) [@R0GGER](https://community.baserow.io/u/R0GGER)
#### Post date: [December 19, 2022, 11:43am UTC](https://community.baserow.io/t/api-size-limit/1905/5 "2022-12-19T11:43:09Z")

</div>

I try to explain…

**cURL via console (ssh)**  
Result: 100 rows

```auto
curl \
-X GET \
-H "Authorization: Token YOUR_DATABASE_TOKEN" \
https://api.baserow.io/api/database/rows/table/124301/?user_field_names=true&size=150

```

**cURL via PHP**  
Result: 150 rows

```auto
GET https://api.baserow.io/api/database/rows/table/124301/?user_field_names=true&size=150 HTTP
Authorization: Token YOUR_DATABASE_TOKEN

```

---

<div class="post-metadata">

### Author: ![petrs](https://community.baserow.io/user_avatar/community.baserow.io/petrs/32/159_2.png) [@petrs](https://community.baserow.io/u/petrs)
#### Post date: [December 19, 2022, 4:57pm UTC](https://community.baserow.io/t/api-size-limit/1905/6 "2022-12-19T16:57:01Z")

</div>

I tried your curl command you sent over privately, and I received 142 rows back, so since `size=150` was set, there are no more records to return? Not sure how did you get 100 or 150.

---

<div class="post-metadata">

### Author: ![petrs](https://community.baserow.io/user_avatar/community.baserow.io/petrs/32/159_2.png) [@petrs](https://community.baserow.io/u/petrs)
#### Post date: [December 19, 2022, 5:33pm UTC](https://community.baserow.io/t/api-size-limit/1905/7 "2022-12-19T17:33:06Z")

</div>

Please try to put quotes around the URL in your shell, e.g.:

```auto
curl \
-X GET \
-H "Authorization: Token YOUR_DATABASE_TOKEN" \
"https://api.baserow.io/api/database/rows/table/124301/?user_field_names=true&size=150"

```
