ec-doris / kohesio-backend

APIs serving Kohesio's frontend
https://kohesio.ec.europa.eu
6 stars 2 forks source link

Excel export is limited to 100 lines #264

Closed madewild closed 1 month ago

madewild commented 2 months ago

https://kohesio.development.ec.europa.eu/en/projects?keywords=eurovelo has 112 projects but only 100 get exported

DiaZork commented 2 months ago

There was a limit of 100 projects when using keyword that was removed but there is this strange behavior of random number of result that happen only with the csv export. This problem is only when we call http://kohesio.development.ec.europa.eu/api/projects/download/csv?keywords=eurovelo&language=en with this API call it work http://kohesio.development.ec.europa.eu/wikibase/facet/eu/search/project/csv?language=en&keywords=eurovelo&limit=1000&offset=0 while the 2 should do the same thing

So my guess is that the problem come from the BFF or the network between some service that cut the connection before the file is fully transferred (knowing that the cut does look random when the file is not full so it might be something like that)

madewild commented 1 month ago

All 112 projects are exported now