How to get list page by page (by parts)

[agamaya-user]

I have a long list and when I try to read it, I get an exception:
Error (Receiver) Operation timed out after 10000 milliseconds with 0 bytes received,more='

so I need to read this list by parts, first 1000 items, then second 1000 items and so on.
How can I do this ?

[mgroat]

There's no built-in way to do it, but here's a workaround that I've used:

function getSharePointAll($sp, $listName) {
	$pageSize = 1000;
	$currentMax = -1;
	$totalResult = [];
	while(true) {
		$currentResult = $sp->query($listName)->where("ID",">",$currentMax)
				->limit($pageSize)->sort('ID','ASC')->get();
		
		//We get a 'No data returned.' warning after we've collected everything
		if(isset($currentResult['warning'])) {
			break;
		}
		$currentMax = end($currentResult)['id'];
		$totalResult = array_merge($totalResult,$currentResult);
	}
	return $totalResult;
}