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.
 

gdocs, xpath and the new blueprints API

First post
Author
Previous Topic Next Topic
Gilbaron
The Scope
Gallente Federation
#1 - 2014-08-27 06:35:27 UTC  |  Edited by: Gilbaron
hello everyone

i basically just want the blueprints API parsed into a google docs so that i can work from there

i want everything in the doc, because i know how to work from there

the one thing that i don't know is how to import it in the doc

can someone help me with the xpath part of the importxml thing ?

(row itemID="1337" locationID="1337" typeID="973" typeName="Arbitrator Blueprint" flagID="4" quantity="-1" timeEfficiency="20" materialEfficiency="10" runs="-1"/)

i basically just want the itemID, locationID, typeID, typeName ... in columns in the document.

how would the importXML function look ?
Gilbaron
The Scope
Gallente Federation
#2 - 2014-08-27 07:43:24 UTC
okay, got it. whoever decided that viewing the doc in the browser showed uppercase, while the importXML from google docs would only work in lowercase deserves to be shot.

=IMPORTXML(https://api.eveonline.com/corp/Blueprints.xml.aspx?vCode=1337&characterID=1338&keyID=1338;"//@typeid")

works flawless

next question:

where can i get the info which ItemID a BlueprintItemID makes ? and who decided that info didn't belong in the blueprints API ?

:CCP
Acid Kanshi
AIFAM
#3 - 2014-08-27 09:44:37 UTC
Quote:
where can i get the info which ItemID a BlueprintItemID makes ? and who decided that info didn't belong in the blueprints API ?


That info is in the data dump.

EVE-Cost is a manufacturing tool for EVE players. http://www.eve-cost.eu
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2014-08-27 11:34:29 UTC
If you want that, grab the industryActivityProducts table from my site (available as xls), and upload it to gdoc. Then you can vlookup it.

You may wish to filter it down to just activityID 1

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Gilbaron
The Scope
Gallente Federation
#5 - 2014-08-27 16:52:14 UTC
Steve Ronuken wrote:
If you want that, grab the industryActivityProducts table from my site (available as xls), and upload it to gdoc. Then you can vlookup it.

You may wish to filter it down to just activityID 1


<3
Amalgation
Badger Industrial
#6 - 2014-08-28 00:08:37 UTC
How did you even get that far?

I can't get the API to give me anything, whatsoever.

https://api.eveonline.com/corp/Blueprints.xml.aspx?keyID=MyID&vCode=myVCode will only return

Quote:
Illegal page request! Please verify the access granted by the key you are using!


even with a full access API. What did you do to get it work at all?
Gilbaron
The Scope
Gallente Federation
#7 - 2014-08-28 00:13:08 UTC
Amalgation
Badger Industrial
#8 - 2014-08-28 00:14:54 UTC
Ah. I missed the Character ID part. First time I've had to throw that in with my stuff, threw me.
Gilbaron
The Scope
Gallente Federation
#9 - 2014-08-28 00:17:45 UTC
to be honest, i have absolutely no idea why that works

the character ID i'm using isn't even in the corp.
Gilbaron
The Scope
Gallente Federation
#10 - 2014-08-28 00:19:52 UTC  |  Edited by: Gilbaron
oh, and it also works without the character ID. weird. it was only in there because i just copied the query part from another sheet. and i don't even know why it was in that first sheet.

https://api.eveonline.com/corp/Blueprints.xml.aspx?vCode=myvcode&keyID=mykeyid
Dragonaire
Here there be Dragons
#11 - 2014-08-28 15:17:13 UTC
For char/ section APIs using an account type key you have to use characterID most other places and times with character or corporation keys that have only one char assigned to them you don't but as you've found the API server generally ignore extra stuff. I've found it easier to just always send the characterID part and not worry which type of key I have. Blink

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Ugurtan
Republic Military School
Minmatar Republic
#12 - 2014-11-09 19:20:47 UTC
Gilbaron, are you managing to get the columns you want with a single importXML call, or do you have to use one for every attribute you want in the spreadsheet? Toying around with xpath for a while now, but dont get how i can import the whole row line with a single import XML. This works fine with other XML structures like the eve central where you can get what you want with a single import call, but I guess thats because the results are all of type element and not attribute?

if anyone has figured that out some help would be appreciated.