How to get children from a sharepoint list item using msgraph v1.0?

Leandro Alves Silva 0

Yesterday my code stopped working to retrieve a list of files from a folder.

The scenario is as follows: the folder is an item from a SharePoint list.

The URL I was using is: https://graph.microsoft.com/v1.0/sites/{domain}:/sites/{alias}:/lists/{list_id}/items/{number_item}/driveItem/children?$select=id,name,createdDateTime,parentReference,folder,file

The folder still exists with the same number, and nothing has changed within the folder in terms of file structure or names. Token is right.

I don't know what is wrong.

This is what I've been receiving from the request since yesterday.

{
    "error": {
        "code": "invalidRequest",
        "message": "Invalid request"
    }
}

Leandro Alves Silva 0 Reputation points

2024-03-14T21:11:04.87+00:00

I found this site: Microsoft Graph changelog. My error started after a change by Microsoft in the driveItem item. However, according to the documentation, the list children method is still available.

https://learn.microsoft.com/en-us/graph/api/resources/driveItem?view=graph-rest-beta

2 answers

RaytheonXie_MSFT 31,076 Reputation points Microsoft Vendor

2024-03-15T02:33:05.3833333+00:00

Hi @Leandro Alves Silva,

Per my test, I could use the api to get children from a sharepoint list item. Please refer to following test result

Could you check if the api works currently?

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.
Please sign in to rate this answer.
RaytheonXie_MSFT 31,076 Reputation points Microsoft Vendor

2024-03-18T08:46:23.4933333+00:00

Hi @Leandro Alves Silva,

Would you tell me whether your issue has been resolved or have any update? If you have any questions or progress, you can contact me in time.

Leandro Alves Silva 0 Reputation points

2024-03-18T13:54:45.36+00:00

Same error... I'm checking this route word for word, but everything is exactly the same
"Sites" are right cause when i'm using another route to get the id by weburl, i've received the correct number 967, that is the folder.

Leandro Alves Silva 0 Reputation points

2024-03-18T13:59:52.3466667+00:00

headers i'm passing:

headers = { "Authorization": "Bearer " + str(run_token()) ,"Content-Type": "text/plain" ,"Prefer": "HonorNonIndexedQueriesWarningMayFailRandomly" }

Leandro Alves Silva 0 Reputation points

2024-03-18T17:59:54.2333333+00:00

Now, testing in MS Graph Explorer.:

I'm asking the IT team if I have the necessary rules and permissions to perform this task. If they haven't changed anything regarding the permissions, it remains confusing because before the update from Microsoft, it worked.

RaytheonXie_MSFT 31,076 Reputation points Microsoft Vendor

2024-03-19T02:38:35.7033333+00:00

Hi @Leandro Alves Silva,

Have you checked if the permission for the item have been expired. You could check the permission in the linkhttps://jwt.io/

RaytheonXie_MSFT 31,076 Reputation points Microsoft Vendor

2024-03-27T01:35:28.7933333+00:00

Hi @Leandro Alves Silva,

would you please provide us with an update on the status of your issue?

Leandro Alves Silva 0 Reputation points

2024-03-28T21:06:40.7133333+00:00

So, the API suddenly started working again. We didn't change permissions or anything else, and it just came back online. I still believe it was due to some update from Microsoft. On the website https://developer.microsoft.com/en-us/graph/changelog?page=1, you can see that there were many updates on March 21, and that was precisely the day the API started working again.
Sign in to comment
Leandro Alves Silva 0 Reputation points

2024-03-28T21:09:34.79+00:00

I'll consider it a temporary bug since it stopped working and then started working again on March 21 in the same manner.

Therefore, without any changes or adjustments, I consider the issue resolved.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment