API Task Power Query Limited to 4000 lines

Using my Dolibarr
1

Using MS Power Query I seem to be limited to receiving no more than 4000 “task” lines through an API. I need to increase the number of lines to 10000+

If I change the query to (noting that for security reasons I have removed the ERP address and DOLAPIKEY)
=Json.Document(Web.Contents(“https://erp.???.au/api/index.php/tasks?sortfield=t.rowid&sortorder=ASC&limit=10000”, [Headers=[Accept=“application/json”, DOLAPIKEY=

I receive the following error;
DataSource.Error: Web.Contents failed to get contents from sortfield=t.rowid&sortorder=ASC&limit=10000’ (500): Internal Server Error
Details:
DataSourceKind=Web
DataSourcePath=
Url=//erp.??.au/api/index.php/tasks?sortfield=t.rowid&sortorder=ASC&limit=10000

Please help with a solution, thanks.

2

Hello,

Error 500 means PHP error, check your hosting logs

3

Thanks, I will look into it.