Setting BASEROW_ROW_PAGE_SIZE_LIMIT environment variable in coolify

Technical Help
1

I’ve read about the 200 record api limit and that I need to add an environment variable to the self hosted baserow, which I did using Coolify.

image
image1426×818 65.9 KB

I checked with the Coolify community if I did it correctly (link to post), they confirmed I did it correct.

Still when I try to get more than 200 records, I get this error in Webstudio.

image
image736×418 24.4 KB

I’m using the URL:

https://myselfhostedbaserow.com/api/database/rows/table/111/?user_field_names=false&size=201

When setting the size to 200, I retrieve the records. More than 200, I get this error.

Anyone any idea?

2

Hey @360Creators,

It looks like that setting hasn’t been loaded. Have you restarted your instance after you set that variable?

I’m not an expert with Coolify, but it should work as long as Baserow starts with that variable set in the environment. You can verify it by running:

docker run \
  -d \
  --name baserow \
  -e BASEROW_PUBLIC_URL=http://localhost 
  -e BASEROW_ROW_PAGE_SIZE_LIMIT=1000 \
  -v baserow_data:/baserow/data \
  -p 80:80 \
  -p 443:443 \
  --restart unless-stopped \
  baserow/baserow:1.30.0

I can fetch up to 1000 rows.

3

Thanks davide!

Appearently I needed to change the environment variable in the compose file itself, instead of in the environment variable tab in coolify.

Got it working now :grin: