How do i get the files updated in the last 8 hours in graph api

Question

I have been trying to create a process to tag all recently modified files in sharepoint, to then update some custom fields we created for the sites.

We are using java MS graph api, but i have not been able to do this with graph.

This is the queries i have tried

{
    "requests": [
        {
            "entityTypes": [
                "driveItem"
            ],
            "query": {
                "queryString": "isDocument:true AND Modified>\"2024-05-16:11:00:00Z\" AND refinablestring14:True AND path:\"<siteURL>\""
            }
        }
    ]
}

{
    "requests": [
        {
            "entityTypes": [
                "driveItem"
            ],
            "query": {
                "queryString": "isDocument:true AND lastModifiedDateTime>\"2024-05-16:11:00:00Z\" AND refinablestring14:True AND path:\"<siteURL>\""
            }
        }
    ]
}

The refinablestring14 is a custom field, that can be true or false, to tell me that the file was check by a previous process to fill some other fields.

Answer 1

Hi @Felix Read,

As far as I know, the graph search api doesn't support custom field currently. The queryString shouldn't contain custom field. The queryString should be like following

POST https://graph.microsoft.com/v1.0/search/query
{
    "requests": [
        {
            "entityTypes": [
                "driveItem"
            ],
            "query": {
                "queryString": "(LastModifiedTime>2024-05-16 AND path:\"https://contoso.sharepoint.com/sites/siteName\")"
            }
        }
    ]
}

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.