# Any details on the new excel integration?

**URL:** <https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561>\
**Category:** General Discussion\
**Created:** [June 16, 2023, 8:34pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561 "2023-06-16T20:34:43Z")\
**Posts on this page:** 1\
**Showing post:** 88

<div class="post-metadata">

**Author:** ![Hundasuupa](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/hundasuupa/32/412082_2.png) [@Hundasuupa](https://forums.eveonline.com/u/Hundasuupa)\
**Post date:** [June 27, 2023, 4:55pm UTC](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561/88 "2023-06-27T16:55:52Z")

</div>

V1.1 has been pushed to the production servers.  
To obtain the update right away you can hit CTRL+F5 in the taskpanel to refetch new content.  
It’s probably needed to go to My Add-ins and hitting refresh for Excel to relink the updated function information to the functions. Once the app store version get updated the add-in should automatically fetch this new version and load it properly, so this is more of a way to get it right away.

**New endpoint**

- Character\_LP endpoint added into CHARACTER\_LP(character\_id\_or\_entity)

**Data changes**

- INVENTORYSEARCH, GROUP, CATEGORY now uses SDE data instead of ESI
- CHARACTER\_SKILLS now outputs an “Unallocated SP” item to expose that data from the endpoint.
- MARKET\_ORDERS functions now include a data\_updated date field for each item.
- CHARACTER\_BLUEPRINTS and CORPORATION\_BLUEPRINTS now include a “blueprint\_data” field with the relevant blueprint information.

**New parameters**

- CHARACTER\_SKILLS now has an optional search\_string parameter
- Character and Corporation INDUSTRY\_JOBS now has an optional status\_filter parameter
- Character and Corporation BLUEPRINTS now has an optional search\_string parameter
- MARKET\_ORDERS and MARKET\_ORDERS\_STREAMING now has an optional sell\_buy\_only\_boolean parameter to filter by sell/buy.
- MARKET\_ORDERS and MARKET\_ORDERS\_STREAMING now has an optional location\_id parameter to allow easier filter by station/structure id
- Character and Corporation ASSETS now has an optional location\_filter parameter that will pre-filter the data by matching final\_location.id or location.id to the input.
- Character and Corporation ASSETS now has an optional page filter to paginate results to 1000 per page while still resolving all assets first and obtaining a resolved final\_location and location where possible.

**UI fixes/changes**

- Fixed duplicated CHARACTER in the try it out for Implants and Fittings calls.
- Reworded requirements on corporation functions in the list to better reflect the required roles.
- Character\_Lp try it out now added to the sidebar list.
- Moved INVENTORYSEARCH to the public category.
- The sidebar will now properly detect if the ExcelApi is not in the minimun required version.

**Bug fixes and other changes.**

- Improved multipage endpoint error handling.
- Removal of unneccesary structure calls for corporation location resolution.
- MARKET\_ORDERS\_STREAMING now properly supports a type\_id\_or\_entity input as it’s type parameters like MARKET\_ORDERS offers.
- Categories more reliably return their respective group.
- Groups more reliable return their respective types.
- Corporation and character contracts logic bug in naming output fixed that was preventing output.
- Throttling improved to better support larger sheets with multiple streaming functions.

---

_[View the full topic](https://forums.eveonline.com/t/any-details-on-the-new-excel-integration/409561)._