EVE-Online RP Discussion and Resources > EVE Guides, Mechanics & Gameplay

Who plays with the API?

(1/3) > >>

orange:
So, I have spent a solid part of the weekend thus far playing with the Eve API and Google Docs Spreadsheets.  I have learned a few things along the way... like URL length is limited to 2048 characters!

This matters because Google Docs has a limit of 50 XML calls.  So, the total number of items I can price based on Eve-Central is limited by these two things and the need to make other calls (like for corporate assets from the API).

This weekend's sheets are focused on capturing corporation asset value and member market information (second sheet).  May even have a basic "market killboard" built for LDIS by the end of the weekend.

What have you built using the API?


Edit: for xpath calls, using parenthesis does what you think it would do.

For example:

--- Code: ---//row[@duration>0 and (@stationid='1' or@stationid='2')]/@what I want
--- End code ---

purple:
A rather inelegant solution to google's 50 call limit is to create another spreadsheet and use importrange to import the whole first spreadsheet in, giving you another 49 calls to work with.   Very messy though.

purple:
I'm not so savvy on xpath syntax is there supposed to be a space between or and @ for the second stationID?   Seems like you are doing something like a pivot table, but inside the call.  Neat.    I assume that's for api.eveonline.com/corp/marketorders.xml.aspx?  and it calls for specific corp orders that haven't expired at two specific stations?  Presumably Z-RE and 3KB?   I deduce from there that you intend to compare LDIS's sell order value to the total sell order value of those two stations as a way of showing how much of it's due to the work of your guys?     Lyn might have blown your efforts off, but I noticed Z-R is the 12th largest market in Provi.  Nice work.

Also, I'll show you mine if you show me yours.

orange:
Well since we are targeting 4TH's stations, I actually call their IDs from the Outpost API and check for orders in all of them.

I have not yet started to worry about how much of 3KB's sales volume is us.   I know Z-R is not LDIS.

The @ on the second station was needed to make it work for me.

Korsavius:


Forreal doe, I have no idea what is going on.

Navigation

[0] Message Index

[#] Next page