topic Qlik Sense REST Connector to connect to Smartsheet in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Sense-REST-Connector-to-connect-to-Smartsheet/m-p/1920780#M16677 <P>Hi,</P> <P>this is my first time using the REST connector, so I hope to get some help from the forum. I have used REST connector to connect Qlik Sense app to Smartsheet. However, I noticed that the data loaded is being limited to just 100 lines.</P> <DIV>Based on the API document for Smartsheet, I think I need to add the&nbsp;includeAll=true query string parameter.&nbsp;<SPAN><SPAN class="Object"><A href="https://smartsheet.redoc.ly/#section/Work-at-Scale/Paging" target="_blank" rel="noopener">https://smartsheet.redoc.ly/#section/Work-at-Scale/Paging</A></SPAN></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><SPAN class="Object">I have tried to set this under the Additional request parameters, but I'm not sure if I have set this correctly as the data after reloading is still limiting to just 100 records. I'm not familiar with the Pagination set-up requirements, so I've left it as none for now.&nbsp;</SPAN></SPAN></DIV> <DIV><SPAN><SPAN class="Object"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-04-21_14-52-55.png" style="width: 928px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/77567iB3E67542FA91EC23/image-size/large?v=v2&amp;px=999" role="button" title="2022-04-21_14-52-55.png" alt="2022-04-21_14-52-55.png" /></span></SPAN></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><SPAN class="Object">Any idea what I'm missing or doing wrong?</SPAN></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><SPAN class="Object">Regards,</SPAN></SPAN></DIV> <DIV><SPAN><SPAN class="Object">Jamie</SPAN></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> Thu, 21 Apr 2022 06:57:37 GMT jamielim 2022-04-21T06:57:37Z Qlik Sense REST Connector to connect to Smartsheet https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Sense-REST-Connector-to-connect-to-Smartsheet/m-p/1920780#M16677 <P>Hi,</P> <P>this is my first time using the REST connector, so I hope to get some help from the forum. I have used REST connector to connect Qlik Sense app to Smartsheet. However, I noticed that the data loaded is being limited to just 100 lines.</P> <DIV>Based on the API document for Smartsheet, I think I need to add the&nbsp;includeAll=true query string parameter.&nbsp;<SPAN><SPAN class="Object"><A href="https://smartsheet.redoc.ly/#section/Work-at-Scale/Paging" target="_blank" rel="noopener">https://smartsheet.redoc.ly/#section/Work-at-Scale/Paging</A></SPAN></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><SPAN class="Object">I have tried to set this under the Additional request parameters, but I'm not sure if I have set this correctly as the data after reloading is still limiting to just 100 records. I'm not familiar with the Pagination set-up requirements, so I've left it as none for now.&nbsp;</SPAN></SPAN></DIV> <DIV><SPAN><SPAN class="Object"><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2022-04-21_14-52-55.png" style="width: 928px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/77567iB3E67542FA91EC23/image-size/large?v=v2&amp;px=999" role="button" title="2022-04-21_14-52-55.png" alt="2022-04-21_14-52-55.png" /></span></SPAN></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><SPAN class="Object">Any idea what I'm missing or doing wrong?</SPAN></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV><SPAN><SPAN class="Object">Regards,</SPAN></SPAN></DIV> <DIV><SPAN><SPAN class="Object">Jamie</SPAN></SPAN></DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> Thu, 21 Apr 2022 06:57:37 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Sense-REST-Connector-to-connect-to-Smartsheet/m-p/1920780#M16677 jamielim 2022-04-21T06:57:37Z