https://connect.hyland.com/t5/nuxeo-forum/how-to-handle-long-nxsql-query-with-rest-api/m-p/323898#M10899 <P>Hi,</P> <P>I want to post a simple NXSQL query using RESTAPI.</P> <BLOCKQUOTE> <P>SELECT * FROM my_document_type WHERE ecm:path STARTSWITH '/my_path/xx'</P> </BLOCKQUOTE> <P>=&gt; This query is OK when launched from the AdvancedSearch dialog (possibly resulting several pages)</P> <P>=&gt; The result is OK when the answer is rather small.</P> <P>But if I post this query looking a very crowded location, it fails.</P> <P>I suspect that the reason is indeed the length of the result.</P> <P>=&gt; how to handle multi page result of a request?</P> <P>Thanks for any advice</P> <P>Christian</P> Tue, 11 Aug 2015 13:49:57 GMT Arnault_ 2015-08-11T13:49:57Z https://connect.hyland.com/t5/nuxeo-forum/how-to-handle-long-nxsql-query-with-rest-api/m-p/323898#M10899 <P>Hi,</P> <P>I want to post a simple NXSQL query using RESTAPI.</P> <BLOCKQUOTE> <P>SELECT * FROM my_document_type WHERE ecm:path STARTSWITH '/my_path/xx'</P> </BLOCKQUOTE> <P>=&gt; This query is OK when launched from the AdvancedSearch dialog (possibly resulting several pages)</P> <P>=&gt; The result is OK when the answer is rather small.</P> <P>But if I post this query looking a very crowded location, it fails.</P> <P>I suspect that the reason is indeed the length of the result.</P> <P>=&gt; how to handle multi page result of a request?</P> <P>Thanks for any advice</P> <P>Christian</P> Tue, 11 Aug 2015 13:49:57 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-handle-long-nxsql-query-with-rest-api/m-p/323898#M10899 Arnault_ 2015-08-11T13:49:57Z https://connect.hyland.com/t5/nuxeo-forum/how-to-handle-long-nxsql-query-with-rest-api/m-p/323899#M10900 <P>[see question]</P> Tue, 11 Aug 2015 13:58:16 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-handle-long-nxsql-query-with-rest-api/m-p/323899#M10900 Arnault_ 2015-08-11T13:58:16Z https://connect.hyland.com/t5/nuxeo-forum/how-to-handle-long-nxsql-query-with-rest-api/m-p/323900#M10901 <P>It fails how? Are there any error messages returned or in the server.log?</P> Wed, 12 Aug 2015 09:16:19 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-handle-long-nxsql-query-with-rest-api/m-p/323900#M10901 Florent_Guillau 2015-08-12T09:16:19Z https://connect.hyland.com/t5/nuxeo-forum/how-to-handle-long-nxsql-query-with-rest-api/m-p/323901#M10902 <P>Unfortunately I don't have access to the server log</P> Wed, 12 Aug 2015 09:39:48 GMT https://connect.hyland.com/t5/nuxeo-forum/how-to-handle-long-nxsql-query-with-rest-api/m-p/323901#M10902 Arnault_ 2015-08-12T09:39:48Z