Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
phima
Contributor II
Contributor II

REST with Sharepoint Search API: Path for total Number of Rows

Happy New Year dev-friends,

i am using a REST data connection to extract data from a sharepoint Search-API.

However we just hit the limit of 500 rows. So now we need to set up pagination for the connection.

The issue i'm facing is: I don't know what path to put in the field "total records path".

phima_0-1641211382335.png

I've tried the obvious whats sent in the body of the response (e.g. d/query/PrimaryQueryResult/RelevantResults/TotalRows - with dots and with slashes) but i always get the following error:

Field containing total records in the current source was not found. Please provide path to the correct field in the Pagination parameter 'Total field path.'

phima_1-1641211567438.png

However the field exists in the body:

phima_2-1641211645957.png

 

Does someone have an idea what to fill in the box?

The API looks like this:

https://<URL>/_api/search/query?querytext=%27ContentTypeId:0x010094EE5B82F3AD471FA2AE4D7B756703BA001...

 

Thanks in advance!

 

 

 

 

1 Reply
Ken_T
Specialist
Specialist

there are multiple posts about this exact error, but no helpful information about troubleshooting or resolving this error. does anyone have info that they can share on this error?