Pagination Error When Retrieving Sharepoint Items

Like (0) Share

Report

Posted on 29 Sep 2022 16:47:05 by PaddyP

Hi all,

I hope somebody can help me with my phenomenon 😉

I have a Sharepoint List with 999 items.

I try to get them with a GetItems function. Since I have more than 100 items in my list, I use a pagination value of 2.000.

But any value over 900 leads to this error:

"The API 'sharepointonline' returned an invalid response for workflow operation 'Elemente_abrufen' of type 'OpenApiConnection'. Error details: 'The API operation 'GetItems' is missing required property 'body/value/52/Title'.'"

What can I do? Is it a problem with pagination or with list content?

Thx 🙂

All responses (3)

Answers (1)

PaddyP 4 on 30 Sep 2022 at 11:25:43

Like (0)

Report

Re: Pagination Error When Retrieving Sharepoint Items

Thank you Craig,
it was indeed a completely empty entry that I didn't see 😎
Silly me!
BR
PaddyP
Craig Stewart ABZ 957 Super User 2024 Season 1 on 29 Sep 2022 at 21:33:49

Like (0)

Report

Re: Pagination Error When Retrieving Sharepoint Items

Is your Title column, set as required but contains no values

Try changing the Title field to Optional (from Required)

It might be that it's hidden, empty and you don't use it but it's set to require data

Make it visible if is not already and see if you have the following visible in your sharepoint list
Verified answer

Craig Stewart ABZ 957 Super User 2024 Season 1 on 29 Sep 2022 at 21:33:45

Like (0)

Report

Re: Pagination Error When Retrieving Sharepoint Items

Is your Title column, set as required but contains no values

Try changing the Title field to Optional (from Required)

It might be that it's hidden, empty and you don't use it but it's set to require data

Make it visible if is not already and see if you have the following visible in your sharepoint list

Then change the settings

Hopefully that's what's required here.