topic Pagination Issue with REST Connector for OData V4 API in Data Movement & Streaming

topic Pagination Issue with REST Connector for OData V4 API in Data Movement & Streaming https://community.qlik.com/t5/Data-Movement-Streaming/Pagination-Issue-with-REST-Connector-for-OData-V4-API/m-p/2474737#M2547 <P class="p1">Hello,</P> <P class="p1">I am experiencing an issue with the Qlik REST connector when retrieving data from an <STRONG>OData V4 API</STRONG>. Data retrieval works correctly, except for pagination.</P> <P class="p1"> </P> <P class="p1"><STRONG>Problem Details:</STRONG></P> <UL> <LI class="p1">The <EM><STRONG><SPAN class="s1"><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/149497">@odata</a>.nextLink</SPAN></STRONG></EM><SPAN> field contains the following url for pagination:</SPAN></LI> </UL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arnaudklr_1-1722932678580.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/170262i397D90EB925563D9/image-size/medium?v=v2&px=400" role="button" title="arnaudklr_1-1722932678580.png" alt="arnaudklr_1-1722932678580.png" /></span></P> <UL> <LI class="p1">During the REST connector configuration, I specified the pagination path as <STRONG><EM><SPAN class="s1">root/@odata.nextLink</SPAN></EM></STRONG><SPAN class="s2">. However, this does not seem to work (</SPAN>I noticed that the <EM><STRONG><SPAN class="s1"><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/149497">@odata</a>.nextLink</SPAN></STRONG></EM><SPAN> field is constructed without the system name):</SPAN></LI> </UL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arnaudklr_2-1722932736658.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/170263i0D05420ED2117500/image-size/medium?v=v2&px=400" role="button" title="arnaudklr_2-1722932736658.png" alt="arnaudklr_2-1722932736658.png" /></span></P> <P> </P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arnaudklr_0-1722932588690.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/170261i2C6294B98E68AB7F/image-size/medium?v=v2&px=400" role="button" title="arnaudklr_0-1722932588690.png" alt="arnaudklr_0-1722932588690.png" /></span></P> <UL> <LI> <P class="p1">On the other hand, with an <STRONG>OData V2 API</STRONG>, pagination works correctly. Perhaps because the <EM><STRONG>__next</STRONG></EM> field is built with the system name:</P> </LI> </UL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arnaudklr_3-1722932889469.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/170264i8067B3374E1722A1/image-size/medium?v=v2&px=400" role="button" title="arnaudklr_3-1722932889469.png" alt="arnaudklr_3-1722932889469.png" /></span></P> <P class="p1"> </P> <P class="p1"><STRONG>Questions:</STRONG></P> <UL> <LI class="p3"><SPAN class="s2">Is there a limitation in Qlik's configuration to handle nextURL for an OData V4 service that does not contain the system name in the following url?</SPAN></LI> <LI class="p3">Could it be an issue with my connector configuration?</LI> <LI class="p3">Is there any other solution for using an OData V4 service rather than an OData V2 service?</LI> </UL> <P class="p1"> </P> <P class="p1">Thank you in advance for your assistance.</P> <P class="p1">Best regards,</P> Wed, 19 Mar 2025 21:48:59 GMT arnaudklr 2025-03-19T21:48:59Z Pagination Issue with REST Connector for OData V4 API https://community.qlik.com/t5/Data-Movement-Streaming/Pagination-Issue-with-REST-Connector-for-OData-V4-API/m-p/2474737#M2547 <P class="p1">Hello,</P> <P class="p1">I am experiencing an issue with the Qlik REST connector when retrieving data from an <STRONG>OData V4 API</STRONG>. Data retrieval works correctly, except for pagination.</P> <P class="p1"> </P> <P class="p1"><STRONG>Problem Details:</STRONG></P> <UL> <LI class="p1">The <EM><STRONG><SPAN class="s1"><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/149497">@odata</a>.nextLink</SPAN></STRONG></EM><SPAN> field contains the following url for pagination:</SPAN></LI> </UL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arnaudklr_1-1722932678580.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/170262i397D90EB925563D9/image-size/medium?v=v2&px=400" role="button" title="arnaudklr_1-1722932678580.png" alt="arnaudklr_1-1722932678580.png" /></span></P> <UL> <LI class="p1">During the REST connector configuration, I specified the pagination path as <STRONG><EM><SPAN class="s1">root/@odata.nextLink</SPAN></EM></STRONG><SPAN class="s2">. However, this does not seem to work (</SPAN>I noticed that the <EM><STRONG><SPAN class="s1"><a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/149497">@odata</a>.nextLink</SPAN></STRONG></EM><SPAN> field is constructed without the system name):</SPAN></LI> </UL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arnaudklr_2-1722932736658.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/170263i0D05420ED2117500/image-size/medium?v=v2&px=400" role="button" title="arnaudklr_2-1722932736658.png" alt="arnaudklr_2-1722932736658.png" /></span></P> <P> </P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arnaudklr_0-1722932588690.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/170261i2C6294B98E68AB7F/image-size/medium?v=v2&px=400" role="button" title="arnaudklr_0-1722932588690.png" alt="arnaudklr_0-1722932588690.png" /></span></P> <UL> <LI> <P class="p1">On the other hand, with an <STRONG>OData V2 API</STRONG>, pagination works correctly. Perhaps because the <EM><STRONG>__next</STRONG></EM> field is built with the system name:</P> </LI> </UL> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="arnaudklr_3-1722932889469.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/170264i8067B3374E1722A1/image-size/medium?v=v2&px=400" role="button" title="arnaudklr_3-1722932889469.png" alt="arnaudklr_3-1722932889469.png" /></span></P> <P class="p1"> </P> <P class="p1"><STRONG>Questions:</STRONG></P> <UL> <LI class="p3"><SPAN class="s2">Is there a limitation in Qlik's configuration to handle nextURL for an OData V4 service that does not contain the system name in the following url?</SPAN></LI> <LI class="p3">Could it be an issue with my connector configuration?</LI> <LI class="p3">Is there any other solution for using an OData V4 service rather than an OData V2 service?</LI> </UL> <P class="p1"> </P> <P class="p1">Thank you in advance for your assistance.</P> <P class="p1">Best regards,</P> Wed, 19 Mar 2025 21:48:59 GMT https://community.qlik.com/t5/Data-Movement-Streaming/Pagination-Issue-with-REST-Connector-for-OData-V4-API/m-p/2474737#M2547 arnaudklr 2025-03-19T21:48:59Z