Eve x Excel.

Eve x Excel functions parameters 1.7


CTRL+F or use the autocomplete below

inside excel a [variable] is an optional parameter.
ommitted here but visible in the card

View technical details about endpoints in ESI

Get active character(s) logged in.

Get alliance by id. 

 
Parameters:
  • name: alliance_id 
  • description:
     The alliance id
  • optional: FALSE
  • type: number
Search for alliances that match a given sub-string. Requires a logged in character 
 
Parameters:
  • name: search 
  • description:
     The string to search on
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
Get blueprint by id. 
 
Parameters:
  • name: blueprint_or_type_id 
  • description:
     The blueprint id or type id
  • optional: FALSE
  • type: number
Get blueprint explosion, material, component and excess for producing each step, experimental. Based on 0/0 blueprints 
 
Parameters:
  • name: blueprint_or_type_array 
  • description:
     The array or range of blueprints or types to explode
  • optional: FALSE
  • type: any
  • name: quantity_array 
  • description:
     The array or range of quantities to manufacture for each blueprint or type. If omitted, a quantity of 1 for each blueprint or type is used
  • optional: FALSE
  • type: any
Get category by id. 
 
Parameters:
  • name: category_id 
  • description:
     The category id
  • optional: FALSE
  • type: number
  • name: expanded 
  • description:
     Whether the search should include a list of groups in the category. If omitted, strict = false
  • optional: FALSE
  • type: boolean
  • name: expand_groups 
  • description:
     Whether the search should include another list of types in the group list. Requires expanded as TRUE.
  • optional: FALSE
  • type: boolean
Get character by id. 
 
Parameters:
  • name: character_id 
  • description:
     The character id
  • optional: FALSE
  • type: number
  • name: fetch_location_and_ship 
  • description:
     Fetch location and ship data if the character is signed in
  • optional: FALSE
  • type: boolean
Get assets for a character 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, assets for all signed in characters will be returned
  • optional: FALSE
  • type: any
  • name: type_name_or_type_id 
  • description:
     (String) Type name to filter results by or type id number to strict filter out by.  Also accepts group_id:X,Y,Z to display only items matching the group id. or type_id:A,B,C. These custom filters must be entered as a string
  • optional: FALSE
  • type: any
  • name: location_filter 
  • description:
     Location id to filter out results by. Can be station id or structure id. Uses final location and location fields to match. If a cell/string is used it will try to convert to a number.
  • optional: FALSE
  • type: any
  • name: page 
  • description:
     Page of results to display (200 per page)
  • optional: FALSE
  • type: number
Get attributes for a character 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, attributes for the first signed in character will be returned
  • optional: FALSE
  • type: any
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, blueprints for all signed in characters will be returned
  • optional: FALSE
  • type: any
  • name: search_string 
  • description:
     String to filter out results by
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
  • name: page 
  • description:
     Page of results to display (500 per page). Defaults shows all.
  • optional: FALSE
  • type: number
Get clone information for a character. 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id
  • optional: FALSE
  • type: any
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity.
  • optional: FALSE
  • type: any
  • name: title_filter 
  • description:
     Title to filter by, string, substring match.
  • optional: FALSE
  • type: string
  • name: status_or_type_filter 
  • description:
     Status or type to filter by, string, exact match. Seperated by ,
  • optional: FALSE
  • type: string
  • name: page 
  • description:
     Page of results to return. 500 per page
  • optional: FALSE
  • type: number
  • name: include_deleted 
  • description:
     Include delete contracts, defaults to false.
  • optional: FALSE
  • type: boolean
Get corporation role information for a character. 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id
  • optional: FALSE
  • type: any
Get fittings for a character. 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id
  • optional: FALSE
  • type: any
Get implant information for a character. 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id
  • optional: FALSE
  • type: any
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, industry jobs for all signed in characters will be returned
  • optional: FALSE
  • type: any
  • name: status_filter 
  • description:
     String to filter out results by matching it to the status property
  • optional: FALSE
  • type: string
  • name: type_id_filter 
  • description:
     Type id number to filter out results by matching it to the product output from the job
  • optional: FALSE
  • type: number
Get loyalty point information for a character. 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity
  • optional: FALSE
  • type: any
Get mining activity for a character 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, skills for the first signed in character will be returned
  • optional: FALSE
  • type: any
Get open market orders for a character 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, open market orders for all signed in characters will be returned
  • optional: FALSE
  • type: any
Get historical market orders for a character 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity If omitted, historical market orders from the last 90 days for all signed in characters will be returned
  • optional: FALSE
  • type: any
  • name: page 
  • description:
     Page of results to return (1000 per page) defaults to displaying all
  • optional: FALSE
  • type: number
Get planets/colonies for a character. 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id
  • optional: FALSE
  • type: any
  • name: planet_id 
  • description:
     Planet id
  • optional: FALSE
  • type: number
Get planets/colonies for a character. 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id
  • optional: FALSE
  • type: any
Get skill queue for a character 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, skill queue for the first signed in character will be returned
  • optional: FALSE
  • type: any
Get skills for a character 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, skills for the first signed in character will be returned
  • optional: FALSE
  • type: any
  • name: search_string 
  • description:
     Search string to filter skills by
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
Get standings information for a character. 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity
  • optional: FALSE
  • type: any
  • name: id 
  • description:
     Corp/faction id to display
  • optional: FALSE
  • type: number
  • name: show_agents 
  • description:
     Show agents, default FALSE
  • optional: FALSE
  • type: boolean
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id. If omitted, wallet balance for the first signed in characters will be returned
  • optional: FALSE
  • type: any
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, wallet journal for all signed in characters will be returned
  • optional: FALSE
  • type: any
  • name: ref_type 
  • description:
     Filter to only display a certain ref type
  • optional: FALSE
  • type: string
  • name: page 
  • description:
     Page of results to display (200 per page)
  • optional: FALSE
  • type: number
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity. If omitted, transactions for all signed in characters will be returned
  • optional: FALSE
  • type: any
  • name: page 
  • description:
     Page of results to return (200 per page)
  • optional: FALSE
  • type: number
Search for character that match a given sub-string. Min. 5 letters for non-strict searching. Requires a logged in character 
 
Parameters:
  • name: search 
  • description:
     The string to search on
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
Get constellation by id. 
 
Parameters:
  • name: constellation_id 
  • description:
     The constellation id
  • optional: FALSE
  • type: number
Get corporation by id. 
 
Parameters:
  • name: corporation_id 
  • description:
     The corporation id
  • optional: FALSE
  • type: number
Get assets for a corporation 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity.
  • optional: FALSE
  • type: any
  • name: type_name_or_type_id 
  • description:
     Type name as string to filter results by or type id number to strict filter out by.  Also accepts group_id:X,Y,Z to display only items matching the group id. or type_id:A,B,C. These custom filters must be entered as a string
  • optional: FALSE
  • type: any
  • name: location_filter 
  • description:
     Location id to filter out results by. Can be station id or structure id. Uses final location and location fields to match. Tries to convert cells/strings to numbers.
  • optional: FALSE
  • type: any
  • name: page 
  • description:
     Page of results to display (200 per page)
  • optional: FALSE
  • type: number
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity.
  • optional: FALSE
  • type: any
  • name: search_string 
  • description:
     String to filter out results by
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
  • name: page 
  • description:
     Page of results to display (500 per page). Defaults shows all.
  • optional: FALSE
  • type: number
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity to be used to select the corporation, required for access reasons.
  • optional: FALSE
  • type: any
  • name: title_filter 
  • description:
     Title to filter by, string, substring match.
  • optional: FALSE
  • type: string
  • name: status_or_type_filter 
  • description:
     Status or type to filter by, string, exact match. Seperated by ,
  • optional: FALSE
  • type: string
  • name: end_location_filter 
  • description:
     End location to filter by, exact match, integer
  • optional: FALSE
  • type: number
  • name: page 
  • description:
     Page of results to return. 500 per page, defaults to 1st page
  • optional: FALSE
  • type: number
  • name: include_deleted 
  • description:
     Include delete contracts, defaults to false.
  • optional: FALSE
  • type: boolean
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity.
  • optional: FALSE
  • type: any
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity.
  • optional: FALSE
  • type: any
  • name: status_filter 
  • description:
     String to filter out results by matching it to the status property
  • optional: FALSE
  • type: string
  • name: type_id_filter 
  • description:
     Type id number to filter out results by matching it to the product output from the job
  • optional: FALSE
  • type: number
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity.
  • optional: FALSE
  • type: any
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity.
  • optional: FALSE
  • type: any
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity.
  • optional: FALSE
  • type: any
  • name: observer_id 
  • description:
     The observer id
  • optional: FALSE
  • type: number
Get open market orders for a corporation 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity that has access to the corporation orders
  • optional: FALSE
  • type: any
Get historical market orders for a corporation 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity that has access to the corporation orders
  • optional: FALSE
  • type: any
  • name: page 
  • description:
     Page of results to display (1000 per page)
  • optional: FALSE
  • type: number
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity.
  • optional: FALSE
  • type: any
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity that has access to the corporation wallet journal
  • optional: FALSE
  • type: any
  • name: division_id 
  • description:
     The division id. Defaults to 1
  • optional: FALSE
  • type: number
  • name: ref_type 
  • description:
     Filter to only display a certain ref type
  • optional: FALSE
  • type: string
  • name: page 
  • description:
     Page of results to display (200 per page)
  • optional: FALSE
  • type: number
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity that has access to the corporation wallet transactions
  • optional: FALSE
  • type: any
  • name: division_id 
  • description:
     The division id. Defaults to 1
  • optional: FALSE
  • type: number
  • name: page 
  • description:
     Page of results to return (200 per page)
  • optional: FALSE
  • type: number
 
 
Parameters:
  • name: character_id_or_entity 
  • description:
     The character id or entity that has access to the corporation wallet information
  • optional: FALSE
  • type: any
Search for corporations that match a given sub-string. Requires a logged in character 
 
Parameters:
  • name: search 
  • description:
     The string to search on
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
Get group by id. 
 
Parameters:
  • name: group_id 
  • description:
     The group id
  • optional: FALSE
  • type: number
  • name: expanded 
  • description:
     Whether the search should include a list of types in the group. If omitted, strict = false
  • optional: FALSE
  • type: boolean
Get solarsystem index by ID. 
 
Parameters:
  • name: solarsystem_id 
  • description:
     The solarsystem id to get indices for, if ommitted returns all solar system indices
  • optional: FALSE
  • type: number
Search for inventory types that match a given sub-string. 
 
Parameters:
  • name: search 
  • description:
     The string to search on
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
  • name: display_unpublished 
  • description:
     Whether the search should display unpublished types. If omitted, display_unpublished = false
  • optional: FALSE
  • type: boolean
Get market history for a type in a region. Limited to 300 calls per minute 
 
Parameters:
  • name: region_id 
  • description:
     The region id
  • optional: FALSE
  • type: number
  • name: type_id_or_entity 
  • description:
     The type id or entity
  • optional: FALSE
  • type: any
  • name: latest_only 
  • description:
     How many days to aggregate in a single cell, 1 or TRUE will return the latest data available only for direct usage
  • optional: FALSE
  • type: any
Get market orders for a type in a region. Stations and public structures. 
 
Parameters:
  • name: region_id 
  • description:
     The region id
  • optional: FALSE
  • type: number
  • name: type_id_or_entity 
  • description:
     The type id or entity
  • optional: FALSE
  • type: any
  • name: sell_buy_only_boolean 
  • description:
     Only show sell if TRUE, only show buy if FALSE, both if left empty
  • optional: FALSE
  • type: boolean
  • name: location_id 
  • description:
     Location id filter for the orders
  • optional: FALSE
  • type: number
Get market orders stats for a type in a region. Stations and public structures. 
 
Parameters:
  • name: region_id 
  • description:
     The region id
  • optional: FALSE
  • type: number
  • name: type_id_or_entity 
  • description:
     The type id or entity
  • optional: FALSE
  • type: any
  • name: location_id 
  • description:
     Station or solarsystem id
  • optional: FALSE
  • type: number
Get market orders for a type in a region. Stations and public structures. Auto updates every hour. Max 100 _STREAMING functions. 
 
Parameters:
  • name: region_id 
  • description:
     The region id
  • optional: FALSE
  • type: number
  • name: type_id 
  • description:
     The type id
  • optional: FALSE
  • type: any
  • name: sell_buy_only_boolean 
  • description:
     Only show sell if TRUE, only show buy if FALSE, both if left empty
  • optional: FALSE
  • type: boolean
  • name: location_id 
  • description:
     Location id filter for the orders
  • optional: FALSE
  • type: number
Get market orders for a type from a structure. Private and public structures. Requires a logged in character for ACL checks. 
 
Parameters:
  • name: structure_id 
  • description:
     The structure id
  • optional: FALSE
  • type: number
  • name: type_id_or_entity 
  • description:
     The type id or entity
  • optional: FALSE
  • type: any
  • name: sell_buy_only_boolean 
  • description:
     Only show sell if TRUE, only show buy if FALSE, both if left empty
  • optional: FALSE
  • type: boolean
  • name: character_id_or_entity 
  • description:
     The character id or entity to use for the structure ACL. If ommitted uses the first signed in character
  • optional: FALSE
  • type: any
Get market orders stats for a type in a structure. 
 
Parameters:
  • name: structure_id 
  • description:
     The structure id
  • optional: FALSE
  • type: number
  • name: type_id_or_entity 
  • description:
     The type id or entity
  • optional: FALSE
  • type: any
  • name: character_id_or_entity 
  • description:
     The character id or entity to use for the structure ACL. If ommitted uses the first signed in character
  • optional: FALSE
  • type: any
Get market orders for a type from a structure. Private and public structures. Requires a logged in character for ACL checks. Auto updates every hour. Max 100 _STREAMING functions. 
 
Parameters:
  • name: structure_id 
  • description:
     The structure id
  • optional: FALSE
  • type: number
  • name: type_id 
  • description:
     The type id
  • optional: FALSE
  • type: any
  • name: sell_buy_only_boolean 
  • description:
     Only show sell if TRUE, only show buy if FALSE, both if left empty
  • optional: FALSE
  • type: boolean
  • name: character_id_or_entity 
  • description:
     The character id or entity to use for the structure ACL. If ommitted uses the first signed in character
  • optional: FALSE
  • type: any
Get region by id. 
 
Parameters:
  • name: region_id 
  • description:
     The region id
  • optional: FALSE
  • type: number
Get route between solarsystems by parameters. 
 
Parameters:
  • name: origin 
  • description:
     Origin solarystem id
  • optional: FALSE
  • type: number
  • name: destination 
  • description:
     Destination solarystem id
  • optional: FALSE
  • type: number
  • name: flag 
  • description:
     Route type flag, secure, insecure, shortest. Default is shortest
  • optional: FALSE
  • type: string
  • name: avoid 
  • description:
     Solarsystems to avoid, array of integers
  • optional: FALSE
  • type: any
Get PI schematic by id or output type_id. 
 
Parameters:
  • name: schematic_id_or_output_type_id 
  • description:
     The schematic id
  • optional: FALSE
  • type: number
Get region by searchstring. If empty return all 
 
Parameters:
  • name: searchstring 
  • description:
     The string to search for
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
Get solarsystem by searchstring. If empty return all 
 
Parameters:
  • name: searchstring 
  • description:
     The string to search for
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
Get stations by searchstring. If empty return all 
 
Parameters:
  • name: searchstring 
  • description:
     The string to search for
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
Get solarsystem by id. 
 
Parameters:
  • name: solarsystem_id 
  • description:
     The solarsystem id
  • optional: FALSE
  • type: number
Get station by id. 
 
Parameters:
  • name: station_id 
  • description:
     The station id
  • optional: FALSE
  • type: number
Get structure by id. 
 
Parameters:
  • name: structure_id 
  • description:
     The structure id
  • optional: FALSE
  • type: number
  • name: character_id_or_entity 
  • description:
     The character id or entity
  • optional: FALSE
  • type: any
Search for structures that match a given sub-string. Requires a logged in character 
 
Parameters:
  • name: search 
  • description:
     The string to search on
  • optional: FALSE
  • type: string
  • name: strict 
  • description:
     Whether the search should be a strict match. If omitted, strict = false
  • optional: FALSE
  • type: boolean
Get type by id. 
 
Parameters:
  • name: type_id 
  • description:
     The item type id
  • optional: FALSE
  • type: number
  • name: include_dogma 
  • description:
     Include dogma information
  • optional: FALSE
  • type: boolean
Get war by id. 
 
Parameters:
  • name: war_id 
  • description:
     The war id
  • optional: FALSE
  • type: number
Get killmails related to a war. 
 
Parameters:
  • name: war_id 
  • description:
     The war id
  • optional: FALSE
  • type: number
List all wars