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.
 

CREST/Excel/XML
Author
Previous Topic Next Topic
Malkys en Daire
Malkys INC.
#1 - 2015-03-24 09:58:17 UTC
Hey guys,

I searched for it, but found no solution that suits my need 100%.

I have an Excelsheet (2013) with different market stuff in it.
For example it pulls prices from EC in it's cells and calculates stuff.

Now I need market histor data for items and want to pull it in cell formulars. It seems like I can't do this, because CREST only answers with JSON.

Is there a plan to expand the CREST API to XML?
Anybody has a good solution to pull CREST data on cell basis?

Kind regards
malkys
Dragonaire
Here there be Dragons
#2 - 2015-03-24 15:04:10 UTC  |  Edited by: Dragonaire
From what CCP has said no CREST will never be done as XML only json. My suggestion is stop trying to get a speadsheet to do a DBs job. Some DBs now even have built-in support for importing json I think I saw some where. I haven't tried it mostly because I have no need and it was in a DB engine I don't normally use as I remember. Plus working with json in most programming languages is normally fairly easy I never worried about it either since that's how CREST was designed to be consumed. You might look around I believe someone has made a JS library which can probably be used to make a quick and dirty importer/converter to something like TSV or something that Excel can import directly. A better solution though is to use something like PHP, Python, etc and a real DB.

Finds camping stations from the inside much easier. Designer of Yapeal for the Eve API. Check out the Yapeal PHP API Library thread.
Aineko Macx
#3 - 2015-03-24 15:12:35 UTC  |  Edited by: Aineko Macx
The representation strings used in CREST suggest they could be used to request something other than JSON, but it doesn't offer anything else atm. While I use JSON in my projects I can certainly see the usefulness of XML...

Nevertheless, it shouldn't be too hard to write a CREST proxy that returns XML.

Dragonaire wrote:
My suggestion is stop trying to get a speadsheet to do a DBs job.

Normally I would agree, but not in this case. Loading XML in Excel is a perfectly reasonable use case. Some DBs can read JSON directly, but none would be able to interface with CREST directly anyway.

iveeCore 3.0: The PHP engine for industrial activities and CREST library
Malkys en Daire
Malkys INC.
#4 - 2015-03-24 19:43:43 UTC
Thanks for your replies!

Well, I see the good sides of JSON and of course writing a tool for it would be the best solution.
It's just that Excel is a good thing to quickly change stuff, work around with different calculations etc pp.

Maybe somebody comes along with "that perfect" idea regarding Excel. Otherwise I will have to write something for it ;)
Lelira Cirim
Doomheim
#5 - 2015-03-25 21:55:55 UTC
Just spotted in another thread:
https://www.cresthelper.com/
>All data is provided in both JSON and XML formats.

Do not actively tank my patience.
Malkys en Daire
Malkys INC.
#6 - 2015-03-26 07:22:24 UTC
Lelira Cirim wrote:
Just spotted in another thread:
https://www.cresthelper.com/
>All data is provided in both JSON and XML formats.


Thx!
Looks good, will have a test on this later :)