Sharepoint API: Missing items when retrieving items from a list

Question

I was trying to retrieve some questions from a list in Sharepoint using the following API call: https://<site url>/_api/web/lists/getbytitle('<list title>')/items

 In the browser, I got XML file with items. However I realized a lot of items were missing. For example, list A has 48 questions, but in XML JSON files only 18 questions can be found. And since the number of items is quite small, it is not over the default limit. Even given this situation, I still tried adding ?$top=1000 to the API call, but it did not work either. It happened to some of lists but not all lists.

Could you please share your expertise on that?

Many thanks!

Answer 1

Hi XU Zhijian,

Thanks for posting in the community.

We would love to help you on your query, however, the situation you mentioned is related to Graph API, and our team focus on queries about SharePoint built-in feature. Since we have a specific channel Q&A Community coping with such questions, I suggest you post a new thread (assign the tabs Microsoft Graph and SharePoint Development) there for expert help.

Also, we welcome community members to share ideas about the situation if one has related experiences.

Sorry for that our category may have limited resources on checking on your concern further.

Thanks for your understanding.

George | Microsoft Community Moderator