nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Limit to Rows Returned for Legacy List endpoint?

Jamie Cross

Pretty sure my testing bears it out, but since it doesn't seem to be documented anywhere, is there a row limit of 75000 rows returned for the Legacy List endpoint?

I have an advanced list that previews at 80,409 rows, but when called through the endpoint or using the "Run" function on the website it only returns 75000 rows.

Find more posts tagged with

Comments

Janet Wittenberg

Hi Jamie,

Yes you are correct. Unfortunately because advanced lists is so powerful aka dangerous to create wild joins, we have to protect the API from swamping the school transactional database with a runaway query.

Jamie Cross

Any thoughts on paging returned data ala some of the other endpoints?

Janet Wittenberg

Unfortunately pagination doesn't protect the database from the large query. Our current recommendation is to segment your lists by a parameter (filter criteria) that will guarantee your lists to return under 75K rows.