Setting BASEROW_ROW_PAGE_SIZE_LIMIT environment variable in coolify

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.

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.

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?

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.

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: