I use REST connector with custom pagination because I can't use Offset way.
I did it about 1.5 years ago but now it doesn't works.
For Custom pagination it works but I can't undersant how get total records in Custom pagination.
Also I didn't find solution for Offset way.
I saw different examples how work with other paginations but not with Offset.
Both ways Custom and Offset are welome if it possible to get Total from REST request and use it to load data.
How to get from XML correct Total value and then use it in Total Field Path?
Thanks in advance.
Example is below.
Curl request: http://api.worldbank.org/v2/countries?page=1&per_page=2
For this case values for Total Field Path "root/total" or "total" don't work.
<wb:countries page="1" pages="152" per_page="2" total="304">
<wb:region id="LCN" iso2code="ZJ">
<wb:adminregion id="" iso2code="" />
<wb:incomeLevel id="HIC" iso2code="XD">
<wb:lendingType id="LNX" iso2code="XX">
Did you ever figure this out?
I get this error:
Error: QVX_UNEXPECTED_END_OF_DATA: Field containing total pages in the current source was not found. Please provide path to the correct field in the Pagination parameter 'Total field path.'
I don't have a pagination parameter "Total field path' on the REST connector though.