Limit to Rows Returned for Legacy List endpoint?

Jamie Cross
Jamie Cross
Tenth Anniversary Kudos 2 Name Dropper Participant
in Education Management APIs
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.

Comments

  • Janet Wittenberg
    Janet Wittenberg
    Ninth Anniversary Kudos 2 Participant Facilitator 1
    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
    Jamie Cross
    Tenth Anniversary Kudos 2 Name Dropper Participant
    Any thoughts on paging returned data ala some of the other endpoints?

     
  • Janet Wittenberg
    Janet Wittenberg
    Ninth Anniversary Kudos 2 Participant Facilitator 1
    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.

Categories