Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Malkys en Daire
Terra Nanotech Yulai Federation
2
|
Posted - 2015.03.24 09:58:17 -
[1] - Quote
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
73
|
Posted - 2015.03.24 15:04:10 -
[2] - Quote
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
344
|
Posted - 2015.03.24 15:12:35 -
[3] - Quote
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.
iveeCrest: A PHP library for CREST || iveeCore: The PHP library for industrial activities
|
Malkys en Daire
Terra Nanotech Yulai Federation
2
|
Posted - 2015.03.24 19:43:43 -
[4] - Quote
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
The Graduates Forged of Fire
225
|
Posted - 2015.03.25 21:55:55 -
[5] - Quote
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. || EVE University Wiki Team
|
Malkys en Daire
Terra Nanotech Yulai Federation
2
|
Posted - 2015.03.26 07:22:24 -
[6] - Quote
Thx! Looks good, will have a test on this later :) |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |