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.
12Next page
 

[0.3.7.0] GESI - Google Sheets ESI Library
Author
Previous Topic Next Topic
Blacksmoke16
Resilience.
#1 - 2017-03-18 15:41:08 UTC  |  Edited by: Blacksmoke16
For all the spreadsheets in space people out there:

https://github.com/Blacksmoke16/GESI

Details are in the readme

Enjoy.
Professor JinMine
Project Fruit House
#2 - 2017-03-19 07:56:27 UTC
Your client ID and client secret...you sure you want to share them with the world?
Blacksmoke16
Resilience.
#3 - 2017-03-19 14:08:45 UTC
It's from a past project i did that has since been deleted. i.e. if you try it it will just error. I just put it there as an example so people know what to replace.
Professor JinMine
Project Fruit House
#4 - 2017-03-20 06:07:32 UTC
Blacksmoke16 wrote:
It's from a past project i did that has since been deleted. i.e. if you try it it will just error. I just put it there as an example so people know what to replace.


Now I'm relieved to hear that Smile
JitaPu
Random Strategies
#5 - 2017-03-22 01:13:45 UTC
Thanks Blacksmoke16, this is extremely useful. Really appreciate you sharing this with us.

One question, I do not seem to be able to get market orders for stations with =structureMarketOrders(structure_id). Is this function limited to structures/citadels or should normal stations such as Jita IV-4 work as well?
Blacksmoke16
Resilience.
#6 - 2017-03-22 01:22:54 UTC  |  Edited by: Blacksmoke16
Np.

Only for structures/citadels.

Are endpoints to get all market orders in a region. But I am not planning on increasing GESI's usability for market related data. It is meant to focus more on the Auth'd endpoints.

Nuadi already has a well made script for market related stuff anyway:

https://github.com/nuadi/googlecrestscript
Blacksmoke16
Resilience.
#7 - 2017-03-28 15:05:35 UTC
Updated itemTypes endpoint to version 3 to include the market_group_id in the response.

Planning on adding some more endpoints this weekend so stay tuned.
Blacksmoke16
Resilience.
#8 - 2017-03-28 21:28:06 UTC
Add endpoint to get character's assets
Add endpoint to get character's loyalty points
Add endpoint to get offers from a corporation's loyalty store

Update ReadMe with changes
Blacksmoke16
Resilience.
#9 - 2017-04-03 21:41:08 UTC  |  Edited by: Blacksmoke16
0.3.1.0 - April 3, 2017

Add in endpoint to get wallet data
Add in few extra scopes
Update readme with new functions and little blurb on using new functions
Haile Korhal
Professional Amateurs
#10 - 2017-04-11 22:36:35 UTC
If this is what I think it is, I will love you forever. Or maybe long time. Who knows. I'll have a look when I get home! ^.^

Egregious Spreadsheet Services - For Spreadsheets as a Service to businesses, corporations, and higher, look no further!
Elementatia
Vision Inc
Hole Control
#11 - 2017-04-22 19:37:09 UTC
o/
Wow ! The authentication-process seems real smart.
Is there a method to ask stuff for the same account, but for a different char with the same token ?


Would it be possible to add the pi endpoint too ? And to add the functions in an GESI Functions/Help Menü in gdocs ?

lovely !
Blacksmoke16
Resilience.
#12 - 2017-04-22 19:43:50 UTC
Elementatia wrote:
o/
Wow ! The authentication-process seems real smart.
Is there a method to ask stuff for the same account, but for a different char with the same token ?


Would it be possible to add the pi endpoint too ? And to add the functions in an GESI Functions/Help Menü in gdocs ?

lovely !



Thanks :)

A token will only work for 1 character. As of now it only supports 1 character being logged in. Was looking into authing multiple characters then adding in a param to specify what character should used for that function. But this will have to wait until after finals.

Yea I'll get the PI ones added this weekend and see what I can do for the help window.
Blacksmoke16
Resilience.
#13 - 2017-04-26 19:35:49 UTC
0.3.2.0 - April 26, 2017

Add in endpoint to get the list of a character's planets
Add in an extra scope for planet data
Update readme with new function

NOTE: the planetDetails endpoint will be released on a later date, need to figure out the best way to display the data on a spreadsheet.
Blacksmoke16
Resilience.
#14 - 2017-04-28 04:42:37 UTC
0.3.2.1 - April 27, 2017

Fix bug with SSO login
Blacksmoke16
Resilience.
#15 - 2017-05-02 01:55:22 UTC
0.3.3.0 - May 1, 2017

Add in endpoint to get information on a specific planet such as: pins, routes, and links.
Add in endpoint to get information on a specific schematic.
Update readme with new endpoints.
Elementatia
Vision Inc
Hole Control
#16 - 2017-05-09 18:02:34 UTC
Yeah..i will try to rework my PI stuff in the next weeks. Thank you for the developement !
Blacksmoke16
Resilience.
#17 - 2017-05-09 18:31:49 UTC
Elementatia wrote:
Yeah..i will try to rework my PI stuff in the next weeks. Thank you for the developement !


No problem.

New endpoints for blueprints, user market orders and industry jobs will come soon as CCP adds those new scopes to the dev site.
Blacksmoke16
Resilience.
#18 - 2017-05-11 05:19:30 UTC  |  Edited by: Blacksmoke16
0.3.4.0 - May 11, 2017

Add in endpoint to get a character's industry jobs, blueprints, and market orders.
Add in function to get information on each endpoint.
Update the each function's autocomplete information to be more standardized and useful.
Update readme with new endpoints.

NOTE: You will have to go back to your dev site application and add the three new scopes in order to use the new endpoints:

Arrow esi-industry.read_character_jobs.v1
Arrow esi-characters.read_blueprints.v1
Arrow esi-markets.read_character_orders.v1

Next use the 'Reset Auth' button in the GESI dropdown menu item. Then re-auth your character using the 'Authorize Sheet' button in the GESI dropdown menu item.
Somi Zulfi
Federal Navy Academy
Gallente Federation
#19 - 2017-05-13 13:30:11 UTC
Hi,

Can you pls add /markets/{region_id}/history/ ?

Great stuff so far!

Thanks!
Blacksmoke16
Resilience.
#20 - 2017-05-13 13:44:42 UTC
Nuadi already has a well made script for market related stuff. I am going to leave him to the market stuff and have GESI be for the auth'd endpoints and non market related stuff.

https://github.com/nuadi/googlecrestscript

You would be interested in his 'getHistoryAdv' function.
12Next page