GESI and Google Sheets


(Namso Izag) #1

Hello,

I successfully made this tutorial and have a few questions.

1 How I can get only two values from the class =characters_character_blueprints ()
I only want the ME and TE

1.1 How I can only get one Item listed?

1.2 If I use esi.evetech universe/types with the id of “pyerite id=35” I get a “Curl” and a “Request URL” but I don’t know how to convert it to google spreadsheet.

=IMPORTXML("https://esi.evetech.net/latest/universe/types/35/?datasource=tranquility&language=en-us", "//application/xml")
my second argument have an error.

1.3 I found =markets_prices() but I need the exact sell order for one item in Jita or Amarr, GESI only have adjusted and average price?


(Omarus Nagibatus) #2

EVE API doesn’t return XML files, its JSON and it cannot be inserted to google docs with =IMPORTXML()

You can use API I made for my project:
=ImportXML(“http://api.eve-pi.com/jitamarket?t=35&q=35000”; “//buy”)

It will return amount of ISK you need to buy 35000 of Pyerite (ID 35) in Jita from sell orders currently present.

Same thing with reverse version:
=ImportXML(“http://api.eve-pi.com/jitamarket?t=35&q=35000”; “//sell”)

It will return amount of ISK you will get if you decide to sell 35000 of Pyerite to buy orders in Jita.

I can make same thing for Amarr trade hub too.

You can replace “http://api.eve-pi.com/jitamarket?t=35&q=35000” with string that use other cells, like this: “http://api.eve-pi.com/jitamarket?t=” & A1 & “&q=” & A2
It will take item type ID from A1 and quantity from A2.


(system) #3

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