EVE Technology Lab

Hello,

After reading and commenting this thread I thought I'd give it a go though I've never worked with the Google Script stuff.

Below is what I wrote after reading Google's documentation about calling external services. It sends my refresh token, gets the refreshed access token, and fetches the market orders from a citadel using the refreshed access token.

Basically I inserted this into the very popular importJSON Google script (modified to call the below function instead of calling UrlFetchApp).
Although it works OK and populates my spreadsheet with nice data, I'm worried about few things:

1. What is the best approach to prevent my sheet from spamming CCP's oauth server asking for a refreshed access token? (for example, if I refresh my sheet very quickly for some reasons)

2. Obviously I have registered to the dev site and have the authorisation code as well as the refresh token for one of my toons. But they were obtained through another method, not Google script.
My question is: is it OK to make authorisation requests from Google sheet, not from the callback URL domain saved in the app I registered with? ...Or... is it OK to make authorisation calls from Google sheet in the first place?

Thank you and fly safe!

Here's the Google script

function getESIData(structureID, page) {

//sends refresh token and gets a refreshed acess token
var refreshurl = 'https://login.eveonline.com/oauth/token?'
    + 'grant_type=refresh_token'
    + '&refresh_token=REFRESHTOKEN';

var headers = {
    'Authorization': 'Basic AUTHORIZATIONCODE] ',
    'Content-Type': 'application/x-www-form-urlencoded',
    };
var options = {
    'method': 'post',
    'headers': headers,
    };
var response = UrlFetchApp.fetch(refreshurl, options);

var refresh_raw = response.getContentText();
var refresh_parse = JSON.parse(refresh_raw);
var acess_token = refresh_parse['access_token'];


//getting the esi citadel market data with the refreshed access token
var esi_url = 'https://esi.tech.ccp.is/latest/markets/structures/'+structureID+'/?page='+page+'&datasource=tranquility';

var esi_headers = {
    'Authorization': 'Bearer '+auth_token,
    'Accept': 'application/json'
     };
var esi_options = {
    'method': 'GET',
    'headers': esi_headers,
    };

var esi_response = UrlFetchApp.fetch(esi_url, esi_options);
//var esi_raw = esi_response.getContentText();
//var esi_parse = JSON.parse(esi_raw);

return esi_response;

//after this I pump return into the popular importJSON script for filling the spreadsheet
}