1.7.4 Patch notes are as follow, and is being deployed as we speak to production.
New function
Adding a .ROUTE(origin, destination, [flag], [avoid]) function, will display a list of solarsystems produced by ESI.
Avoid parameter is setup to accept a string of the solarsystem ids seperated by a “,” doublechecked against SDE solarsystems ids. origin and destination are also verified before submission to ESI.
Updates to existings functions and parameters
Adding agents to character_standings, optional boolean parameters, will only display the names of the agents, with their id queriable via .CHARACTER if needed.
Performance boost by removing the .corporation card from standings and resolves only the name now. id ofc remains for .CORPORATION lookup.
Adding a contract type filter option to CHARACTER/CORPORATION_CONTRACTS.
Added by allowing a “,” in the status_filter string parameter, so it’s now a status_or_type_filter fx. “item_exchange,outstanding” will now combo these two options.
Reversed the contracts list so 500 will be the latest 500 (hopefully).
Improvements
Improved internal ESI errors in functions/cards to be displayed in the sidebar.
Improved the Errors in the sidebar, now fixed to the bottom instead of being above the character list. Much more visible now.
Character Contracts and Corporation Contracts seem to be broken. I am getting only results from the past month and pagination doesn’t work. Character Contracts are supposed to return 500 but I get 172. 7/6/24 2:27 AM is the oldest and in game I get 4 pages with the oldest being 2023.12.23 13:11
Is this with no filters on? For some endpoints conducting a test of the payload from ESI is kinda required. EVE Swagger Interface and debugging with the proper scope + character_id/corporation_id is the simplest way to confirm the data being sent in.
Yeah it was not filters. ie =EVEONLINE.CHARACTER_CONTRACTS(xxxxxx,,,1,TRUE). ACTUALLY esi it returning the same. Interesting. How is it supposed to work? Is it bound by dates and only 500 ±page within that date range?
Also paging 2,3,4,5 i get N/A with the plugin and no results in ESI. So doesnt seem to be a paging issue. Just overall data available.
The 500 items limit is more of processing limit to speed up the function, as the filters can do a lot of the heavy lifting of pre-sorting the contracts, and after sorting them the function returns the first 500 matching contracts. Since it could take couple of minutes if the contracts returned are over 10k+
…N/A with the plugin…
The plugin tries to only use N/A when the call was successful but the page is empty, or the results after filtering are empty. So that’s the expected return data for that.
For the data returned, all I really know is the ESI specs.
Character: Returns contracts available to a character, only if the character is issuer, acceptor or assignee. Only returns contracts no older than 30 days, or if the status is “in_progress”.
Corporation: Returns contracts available to a corporation, only if the corporation is issuer, acceptor or assignee. Only returns contracts no older than 30 days, or if the status is “in_progress”.
From that description it does sound like it’s close to the 30 day period. (30 days is common in other ESI endpoints)
So you’d have to save them either as values to keep some history over 30 days.
CTRL+SHIFT+V paste will paste it as values and deattached it form the plugin. But a pretty manual process.
But this kind of a approach benefits more from a proper database, so you can minimize manual work and any, bound to happen eventually, human errors from handling that amount of data.
Excel-As-A-Database can get messy.
Ah that makes sense. Thanks for explaining it to me. I am working on logistics stats that will show month over month trends. I will make a vba script to just run and save monthly tabs and aggregate over that static data.
Sorry to bother you again. Do you know if there are issues with updating the character cards? I have a toon I just added to my sheet and the corp that is showing is my old corp. I changed corps 2 weeks ago. Idk if its a update issue or is there something I can do to force it within excel?
This endpoint is used for the character cards corporation. It has a 7 day cache on it (60480 seconds). So two weeks should have been enough, without knowing anything beyond the ESI specs for the endpoint.
Note, for CORPORATION endpoints where you use a character_id as the input, we use another method to fetch the corporation_id of the character for internal usage in the function, that has a lower cache timer.
But it’s not planned on being integrated into character cards for performance reasons mostly, since it’s an uncommon scenario to have happen to every character card.
So for the card to update with the correct corp, once you recalculate it ofc, you’ll have to wait a for the character ESI endpoint to reflect the current corporation.
