You can translate the question and the replies:

Get all JSON results from restful webservice

I have the following URL that is return JSON format for one of my views: http://mycompany:9090/denodo-restfulws/hcc_dv/views/mytestview/?$format=JSON However, it only returns the first 25 rows. I have tried every conceivable varitation to get all 150 rows (that is the count of as now). what parameter do I need to add to get ALL rows??? For example I can do the full listing by using. http://mycompany:9090/denodo-restfulws/hcc_dv/views/mytestview/?$count=1000 but it does NOT show up in JSON format I can do JSON but only get 25. if it try to put both paramters in the same URL it does NOT work. :-(
18-04-2021 22:28:45 -0400

1 Answer

Hi, In general, [REST]( Web Service URL with JSON format will return the complete result set in a single web page but for HTML format by default, it will return 25 rows per page. Hence, in order to [increase that row size](, you can either use the [$count]( in the URL or you can modify the default setting available in the web.xml.template located at <DENODO_HOME>\resources\db\wsgenerator\restfulws and restart the Denodo servers. If I face the same issue, I would check the log files **vdp.log and vdp-requests.log** located in path <DENODO_HOME>\logs\vdp by changing the log level to ‘**INFO**’ in order to debug the issue. For more infromation, you could refer to the KB article [How to log the requests issued on a VDP server](,log.). Hope this helps!
Denodo Team
21-04-2021 07:22:54 -0400
You must sign in to add an answer. If you do not have an account, you can register here