Any details on the new excel integration?

Communications Center General Discussion
88

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.
3 Likes