Excel Rest query with Odata returns first 100 lines of any given table

[djardins (Benoit Desjardins)]

Any idea why when using Rest query with Excel we only get back the first 100 lines in the table although in the query editor we see all lines.

[josecgomez]

Default behavior on all.kf epicor you can pass in the $top parameter

[djardins (Benoit Desjardins)]

Thanks Josecgomez

Can this be done on a table per table basis? Where exactly in the $top parameter.

Thanks

[josecgomez]

Its a parameter in the oData URL ?$top=1000

[Bart_Elia]

Correct on the defaults. You can change this in the web.config for global handling - all services default to 100 records and encourage you to iterate records 100 at a time. If you consider the memory and CPU impact of a runaway query at the db and app server level, the default is there to keep you from having someone denial of service your own servers

The way to think about doing unknown volume queries is to assume you need to chunk them into bite sized portions - 100 is the number that was chosen based upon scale lab results. Of course you can override that in your environment since you know your data and processes and hardware.

[DaneStewart]

@Bart_Elia

change this in the web.config for global handling - all services default to 100 records and encourage you to iterate records 100 at a time. If you consider the memory and CPU impact of a runaway query at the db and app server level, the default is there to keep you from having someone denial of service your own servers

The way to think about doin

The ?$top=1000 parameter was super helpful for me. Thx.