https://community.qlik.com/t5/Featured-Members/REST-API-connection-quot-Total-field-path-quot-error-in/m-p/2544640#M477 <P>Hello Developers!!!</P><P><BR />I have tried so many things and cannot seem to get all my data (10000+ records).<BR />With native REST API settings I get the "Total field path" error so I am trying to adjust the API settings with provider's requirements.<BR />Attached here with the snapshot and the error message I'm getting now.</P><P>&nbsp;</P><P>I'm trying to use the limit and offset pagination required by the provider. when i set Offset=0 &amp; pagesize=200 and use loop to fetch<BR />the records from table it will hit the DB numerous time and fetch the 200 records for each itteration.<BR />Can someone help me, to get direct fetch the records which are available from that respective table please??</P> Thu, 12 Mar 2026 07:15:24 GMT Vishwajit_Bari 2026-03-12T07:15:24Z https://community.qlik.com/t5/Featured-Members/REST-API-connection-quot-Total-field-path-quot-error-in/m-p/2544640#M477 <P>Hello Developers!!!</P><P><BR />I have tried so many things and cannot seem to get all my data (10000+ records).<BR />With native REST API settings I get the "Total field path" error so I am trying to adjust the API settings with provider's requirements.<BR />Attached here with the snapshot and the error message I'm getting now.</P><P>&nbsp;</P><P>I'm trying to use the limit and offset pagination required by the provider. when i set Offset=0 &amp; pagesize=200 and use loop to fetch<BR />the records from table it will hit the DB numerous time and fetch the 200 records for each itteration.<BR />Can someone help me, to get direct fetch the records which are available from that respective table please??</P> Thu, 12 Mar 2026 07:15:24 GMT https://community.qlik.com/t5/Featured-Members/REST-API-connection-quot-Total-field-path-quot-error-in/m-p/2544640#M477 Vishwajit_Bari 2026-03-12T07:15:24Z