# Is there a route for querying system details in bulk?

**URL:** <https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231>\
**Category:** Third Party Developers\
**Tags:** api, esi, tool\
**Created:** [May 12, 2022, 7:03am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231 "2022-05-12T07:03:22Z")\
**Posts on this page:** 17\
**Page:** 1

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [May 12, 2022, 7:03am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/1 "2022-05-12T07:03:22Z")

</div>

Is there a route for querying system details in bulk?

I see [EVE Swagger Interface](https://esi.evetech.net/ui/#/Universe/get_universe_systems_system_id) route however,  
`/universe/systems/{system_id}` only gives one system detail.

For example if I want to query a route using [EVE Swagger Interface](https://esi.evetech.net/ui/#/Routes/get_route_origin_destination) with `/route/{origin}/{destination}` but with more details on the system I have to perform _N_ follow up queries for each system in the returned route of _system\_id_’s. Local caching aside, there is still the issue of that _first_ uncached bulk query.

For example this is problematic if you want a command line tool (using PowerShell for example) to query a route with system details. You’re spawning off _N_ thread jobs (not a problem but just moving parts to wait and receive results for) for each system in the route rather than just one more query for the bulk route details. For tools like this you’re probably not locally caching anyway for simplicity.

Basically spawning follow up queries in PowerShell like this

```auto
foreach ($system in $route){
      if ($Parallel.IsPresent){
        $threadJobs[$routeIndex] = Start-ThreadJob -Name $routeIndex -InputObject $system -ScriptBlock {Get-EveSystem -SystemId $input}
        $routeIndex++
      }

```

waiting and receiving the results like so

```auto
    if ($Parallel.IsPresent){
      Wait-Job -Job $threadJobs -Timeout 60
      foreach ($threadJob in $threadJobs){
        $routeDetail[[int]$threadJob.Name] = Receive-Job -Job $threadJob
        Remove-Job -Job $threadJob
      }
    }
    $routeDetail

```

---

<div class="post-metadata">

**Author:** ![Paz\_Lammaschtu](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/paz_lammaschtu/32/264397_2.png) [@Paz\_Lammaschtu](https://forums.eveonline.com/u/Paz_Lammaschtu)\
**Post date:** [May 12, 2022, 8:53am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/2 "2022-05-12T08:53:40Z")

</div>

No, for that you can use Fuzzwork dumps and a database:  
[https://www.fuzzwork.co.uk/dump/latest/mapSolarSystems.sql.bz2](https://www.fuzzwork.co.uk/dump/latest/mapSolarSystems.sql.bz2)  
Querying EVE API for such nearly static data is bad resource usage.

---

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [May 12, 2022, 8:54am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/3 "2022-05-12T08:54:14Z")

</div>

No, I don’t want to consume more dependencies, it’s a module with functions written in Powershell for command line use.

What you’re asking me to do is bloat up a simple command line tool. No Fing way.

It is not a desktop app, it is not a hosted website, it’s a COMMAND LINE TOOL, a FEW FUNCTIONS.

As for static resources, [SDE parity checklist · Issue #1103 · esi/esi-issues · GitHub](https://github.com/esi/esi-issues/issues/1103) is a ticket to move them into the API.

---

<div class="post-metadata">

**Author:** ![Paz\_Lammaschtu](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/paz_lammaschtu/32/264397_2.png) [@Paz\_Lammaschtu](https://forums.eveonline.com/u/Paz_Lammaschtu)\
**Post date:** [May 12, 2022, 8:57am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/4 "2022-05-12T08:57:46Z")

</div>

It’s just against the way the API wants to be used. Your tool is an edge case in this case.

Just because someone wants to see this in the API doesn’t mean that it’s a good thing.

---

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [May 12, 2022, 8:59am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/5 "2022-05-12T08:59:12Z")

</div>

Ahh yes the ESI is for websites only thinking.

Eve itself is an edge case in the gaming world.

---

<div class="post-metadata">

**Author:** ![Paz\_Lammaschtu](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/paz_lammaschtu/32/264397_2.png) [@Paz\_Lammaschtu](https://forums.eveonline.com/u/Paz_Lammaschtu)\
**Post date:** [May 12, 2022, 9:01am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/6 "2022-05-12T09:01:33Z")

</div>

> [@Emotional\_Support\_Clown](#):
>
> Ahh yes the ESI is for websites only thinking.

Not what I said.

---

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [May 12, 2022, 9:01am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/7 "2022-05-12T09:01:51Z")

</div>

> [@Paz\_Lammaschtu](#):
>
> Just because someone wants to see this in the API doesn’t mean that it’s a good thing.

Well, what else is the API for if somebody doesn’t want it?

The whole point of the API is for somebody to use it.

I have no problem sending 100 query threadjobs every time I use the tool then. I am not going to bloat up my app just to suit your “no no” desires and hinder what is simply copy a PowerShell module across to deploy.

---

<div class="post-metadata">

**Author:** ![Paz\_Lammaschtu](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/paz_lammaschtu/32/264397_2.png) [@Paz\_Lammaschtu](https://forums.eveonline.com/u/Paz_Lammaschtu)\
**Post date:** [May 12, 2022, 9:07am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/8 "2022-05-12T09:07:56Z")

</div>

The API is for “changing” data. For static data you have the dumps. That’s a healthier way for the API’s resource usage.

---

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [May 12, 2022, 9:08am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/9 "2022-05-12T09:08:53Z")

</div>

That’s filed under “not my problem”.

The direction is to move to API parity [SDE parity checklist · Issue #1103 · esi/esi-issues · GitHub](https://github.com/esi/esi-issues/issues/1103)

 ![image](https://global.discourse-cdn.com/eveonline/original/4X/7/5/f/75facf5dcc8b43ea7cc8a0edfe68a9ab1f387af0.png)  
Source: [SDE parity checklist · Issue #1103 · esi/esi-issues · GitHub](https://github.com/esi/esi-issues/issues/1103#issuecomment-483060810)

I am not going to code against something that is to be DEPRECATED.

---

<div class="post-metadata">

**Author:** ![Paz\_Lammaschtu](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/paz_lammaschtu/32/264397_2.png) [@Paz\_Lammaschtu](https://forums.eveonline.com/u/Paz_Lammaschtu)\
**Post date:** [May 12, 2022, 9:13am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/10 "2022-05-12T09:13:30Z")

</div>

Everyone can file feature requests. To assert that CCP wants to comply to this and will is pire speculation. The time this request is open doesn’t really support your assertion.

> [@Emotional\_Support\_Clown](#):
>
> That’s filed under “not my problem”.

I am sure the API doesn’t care about your problem and I have a guess who will “win” this fight…

---

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [May 12, 2022, 9:13am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/11 "2022-05-12T09:13:50Z")

</div>

> [@Paz\_Lammaschtu](#):
>
> I have a guess who will “win” this fight…

ESI is dead anyway, CCP abandoned it long ago. SDE to be deprecated too.

Not sure what you’re winning.

---

<div class="post-metadata">

**Author:** ![Paz\_Lammaschtu](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/paz_lammaschtu/32/264397_2.png) [@Paz\_Lammaschtu](https://forums.eveonline.com/u/Paz_Lammaschtu)\
**Post date:** [May 12, 2022, 9:16am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/12 "2022-05-12T09:16:02Z")

</div>

Yes, it’s easier for some people to think of their dream way but that’s not how it works.

---

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [May 12, 2022, 9:16am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/13 "2022-05-12T09:16:32Z")

</div>

You’re like the goblin who pops up in every topic just to respond, for the sake of it, see [Roadmap for third party developers and the API - #2 by Paz\_Lammaschtu](https://forums.eveonline.com/t/roadmap-for-third-party-developers-and-the-api/361636/2) you add nothing of value.

> [@Paz\_Lammaschtu](#):
>
> The SDE and Fuzzworks great formatting of it is up-to-date, just check the regular forum threads.

Powershell works with Objects, I don’t need your formatting or bloat.

---

<div class="post-metadata">

**Author:** ![Paz\_Lammaschtu](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/paz_lammaschtu/32/264397_2.png) [@Paz\_Lammaschtu](https://forums.eveonline.com/u/Paz_Lammaschtu)\
**Post date:** [May 12, 2022, 9:20am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/14 "2022-05-12T09:20:24Z")

</div>

I see you are not interested in a solution. Do yourself and the community a favour and leave the forum.

---

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [May 12, 2022, 9:20am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/15 "2022-05-12T09:20:52Z")

</div>

Not yours no, if we followed your solutions, hosting a simple “hello world” in the cloud would have umpteen modules and services behind it and cost a fortune.

![image](https://global.discourse-cdn.com/eveonline/original/4X/0/2/b/02b0c0f839ac3fb8f3bebb4af15ce04802b867da.jpeg)  
Figure 1: You

---

<div class="post-metadata">

**Author:** ![Emotional\_Support\_Clown](https://sea1.discourse-cdn.com/eveonline/user_avatar/forums.eveonline.com/emotional_support_clown/32/310422_2.png) [@Emotional\_Support\_Clown](https://forums.eveonline.com/u/Emotional_Support_Clown)\
**Post date:** [May 12, 2022, 9:22am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/16 "2022-05-12T09:22:13Z")

</div>

> [@Paz\_Lammaschtu](#):
>
> Do yourself and the community a favour and leave the forum.

Classy, you act like you’re some kind of godlike entity with a non-answer for everything.

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/eveonline/original/3X/4/1/41ec4921cbaca7a6f9ea556e7cc20018461eae5e.png) [@system](https://forums.eveonline.com/u/system)\
**Post date:** [August 10, 2022, 9:22am UTC](https://forums.eveonline.com/t/is-there-a-route-for-querying-system-details-in-bulk/362231/17 "2022-08-10T09:22:53Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.