cancel
Showing results for 
Search instead for 
Did you mean: 

how to handle long NXSQL query with REST API?

Arnault_
Confirmed Champ
Confirmed Champ

Hi,

I want to post a simple NXSQL query using RESTAPI.

SELECT * FROM my_document_type WHERE ecm:path STARTSWITH '/my_path/xx'

=> This query is OK when launched from the AdvancedSearch dialog (possibly resulting several pages)

=> The result is OK when the answer is rather small.

But if I post this query looking a very crowded location, it fails.

I suspect that the reason is indeed the length of the result.

=> how to handle multi page result of a request?

Thanks for any advice

Christian

3 REPLIES 3

Arnault_
Confirmed Champ
Confirmed Champ

[see question]

Florent_Guillau
World-Class Innovator
World-Class Innovator

It fails how? Are there any error messages returned or in the server.log?

Arnault_
Confirmed Champ
Confirmed Champ

Unfortunately I don't have access to the server log