CHARACTER_ORDERS_HISTORY does not return all results?

EVE Technology and Research Center EVE x Microsoft Excel Add-in
1

=EVEONLINE.CHARACTER_ORDERS_HISTORY(B2)
The docs say it should return all order history for 90 days, and optionally you can specify a page number with 1000 results per page.

What I found is it only returns the oldest 700 results. If you specify a page it also only returns 700 at a time and I can’t find any way to get all the results. Am I missing something or is this a bug?

2

Note on Excel web the page size is dynamic to what will fit inside the excel web limits. (So it can be max 1000, min 50)

I assume you’ve tried seeing the difference between pages 1 and 2?

=EVEONLINE.CHARACTER_ORDERS_HISTORY(B2,1) and =EVEONLINE.CHARACTER_ORDERS_HISTORY(B2,2)

If you are getting 2 pages worth of things, I’d look into =VSTACK combining the 2 outputs into a single list, that can be displayed in excel web so you can then do some filtering on it.

You can confirm the number of results you are getting via EVE Swagger Interface the swagger, the addin will fetch all pages and process them (and then split into pages if it’s on excel web, desktop will return the entire results fetched)