How to Retrieve All Records from EspoCRM?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • zerosix
    Member
    • Jan 2024
    • 45

    How to Retrieve All Records from EspoCRM?

    I am retrieving data from the EspoCRM endpoint http://espocrmwebsiteapi/v1/myentity. However, the response is limited to 200 records at a time, and I have more than 500 records in total.

    How can I fetch all the records? thanks in advance
  • shalmaxb
    Senior Member
    • Mar 2015
    • 1621

    #2
    in folder data -> config.php, change the value here: 'recordListMaxSizeLimit' => 200,

    but be aware, the larger the number of records, the more database action happens. In your case I guess will slow down displaying the records a bit, if you would modify it to larger numbers, a database timeout could happen. That is the reason for the default of 200.

    Comment

    • yuri
      Member
      • Mar 2014
      • 8627

      #3
      Also consider implementing pagination on the client site if possible. To send a few requests with an offset and limit parameters
      If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.

      Comment

      Working...