Read items from sharepoint

[BeginnerRaffe]

Hello,

I have read that are some issues to read may items from sharepoint? I have tested with 500 and it seams to work for me. Are there any limitations how many items you can read?

I would like to make a query when I read from sharepoint. I got a date field in my sharepoint list and I would like only to read the items that is newer than a specific date. It that possible? (My sharepoint lits will contain many items ...)

I use the code below:

use Office365\SharePoint\ClientContext;
use Office365\Runtime\Auth\ClientCredential;
use Office365\SharePoint\ListItem;

$credentials = new ClientCredential("{client-id}", "{client-secret}");
$client = (new ClientContext("https://{your-tenant-prefix}.sharepoint.com"))->withCredentials($credentials);

$web = $client->getWeb();
$list = $web->getLists()->getByTitle("{list-title}"); //init List resource
$items = $list->getItems(); //prepare a query to retrieve from the. How do I make q query here?
$client->load($items); //save a query to retrieve list items from the server
$client->executeQuery(); //submit query to SharePoint server
/** @var ListItem $item */
foreach($items as $item) {
print "Task: {$item->getProperty('Title')}\r\n";
}

[cweiske]

Sharepoint has an infamous limit of 5000 items, see https://learn.microsoft.com/en-us/sharepoint/troubleshoot/lists-and-libraries/items-exceeds-list-view-threshold - if you hit it, you will get an exception:

{
  "error": {
    "code": "-2147024860, Microsoft.SharePoint.SPQueryThrottledException",
    "message": {
      "lang": "en-US",
      "value": "The attempted operation is prohibited because it exceeds the list view threshold."
    }
}

For lists it is said this can be circumvented by setting indexes on columns: https://www.codeproject.com/Articles/1076854/Overcoming-the-List-View-Threshold-in-SharePoint-C

I failed to get around that limit when using $folder->getFiles() and had to resort to splitting up files into multiple folders.