EVE Technology Lab

 
2 Pages12Next page
 

[0.3.6.0] GESI - Google Sheets ESI Library

Author
#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.
#2 - 2017-03-19 07:56:27 UTC
Your client ID and client secret...you sure you want to share them with the world?
#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.
#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
#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?
#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
#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.
#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
#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
#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!

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 !



#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.
#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.
#14 - 2017-04-28 04:42:37 UTC
0.3.2.1 - April 27, 2017

Fix bug with SSO login
#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.
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 !
#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.
#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.
Pandemic Horde
#19 - 2017-05-13 13:30:11 UTC
Hi,

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

Great stuff so far!

Thanks!
#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.
2 Pages12Next page
Forum Jump