These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

API: typename to typeid
Author
Previous Topic Next Topic
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#1 - 2012-09-20 11:30:42 UTC
This is going to be a pretty low use api (as you'd normally have the database anyway), but it's one that's not directly provided by CCP:

Typename to typeid. json and xml output.


http://www.fuzzwork.co.uk/api/typeid.php?typename=Tritanium
http://www.fuzzwork.co.uk/api/typeid.php?typename=Tritanium&format=xml

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
ItsmeHcK1
Immortalis Inc.
Shadow Cartel
#2 - 2012-09-21 23:54:17 UTC
Nice one.

Don't think I'll use it, but still. P
Ch3244
Native Freshfood
Minmatar Republic
#3 - 2012-10-03 01:00:23 UTC
xml link comes up blank
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2012-10-03 01:02:38 UTC
Ch3244 wrote:
xml link comes up blank



The content is still there. Take a look at the page source

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Ch3244
Native Freshfood
Minmatar Republic
#5 - 2012-10-03 01:18:36 UTC
Steve Ronuken wrote:
Ch3244 wrote:
xml link comes up blank



The content is still there. Take a look at the page source

ah, yes i see.

now if only there was a way to make excel change the url per cell. so i could have a column of typenames and have excel change the url to http://www.fuzzwork.co.uk/api/typeid.php?typename=XXXX&format=xml and then retrieve the typeID.

is this possible with excell?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#6 - 2012-10-03 01:29:16 UTC
Ch3244 wrote:
Steve Ronuken wrote:
Ch3244 wrote:
xml link comes up blank



The content is still there. Take a look at the page source

ah, yes i see.

now if only there was a way to make excel change the url per cell. so i could have a column of typenames and have excel change the url to http://www.fuzzwork.co.uk/api/typeid.php?typename=XXXX&format=xml and then retrieve the typeID.

is this possible with excell?



An option you might want to take instead:

http://www.fuzzwork.co.uk/resources/typeids.csv

it's useful for vlookup. Just stick it all into another worksheet.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter