We’re updating to consume the openAPI specs to future proof the addin. This will touch on every endpoint that talks to ESI, testing has been as broad as possible but issues could still happen as the test scenarios don’t cover everything perfectly.
Highly advised to report issues in the #spreadsheets discord channel so we can fix them right away
Due to this upgrade the streaming functions have been removed due to their complexity and instability.
Removed endpoints
MARKET_ORDERS_STREAMING
MARKET_STRUCTURE_ORDERS_STREAMING
Fixes
Improved cache resolution
Lowered max page size of corporation_orders to 500 to improve excel web performance
Removed (active) and (paused) logic from skill queue as it was inexact and misleading, using excel date and comparing it to the items is a much more exact approach.
We’ve had some concurrency issue affecting this release, leading to incomplete data / N/A when refreshing multiple functions at once, a hotfix has just been released that can be fetched via CTRL+F5 in the sidebar to load in new files.
I’ll go check out character mining and see if it needs a new hotfix for that. Thanks for the report!
Sadly I’ll have to revert the API changes for now, the massive scale of concurrency was breaking down the implementation and I’ll be redoing the functionality.
Changes that remain are the scopes, removal of (paused) / (active) in skill queue, and removal of the STREAMING functions to retain an easier upgrade experience for anyone on 1.8/1.8.1