Use a variable in a nested JSON.parse API call

Question

I'm wondering if there is a way in Google script to use a variable to get data and write it on a cell from a nested API call. For example:

var symbol = "BTC";

  var responseAPI = UrlFetchApp.fetch(url+apikey+"&symbol="+symbol+"&convert=EUR");

  var parcedData = JSON.parse(responseAPI.getContentText());

  index.getRange(2,1).setValue([parcedData.data.BTC.symbol]);
  index.getRange(2,2).setValue([parcedData.data.BTC.quote.EUR.price]);

This is the code I use to retrieve BTC price from new Coinmarketcap API (documentation is here https://coinmarketcap.com/api/documentation/v1/#operation/getV1CryptocurrencyQuotesLatest). Since I already declare the BTC symbol in a variable, is there a way to substitute BTC in "setValue"? Something like:

index.getRange(2,1).setValue([parcedData.data.+symbol+.symbol]);
                                 variable here ^^^^^^

This is not working of course, is there a way to make it works? Thank you in advance

0Valt · Accepted Answer · 2019-06-07 11:44:30Z

3

Yes, there is, nothing stops you from accessing a variable property name here, just remember to use bracket notation - parcedData.data[symbol].symbol - so long as the symbol variable is reachable within the scope of setValue(), you should be good to go.

answered Jun 7, 2019 at 11:44

0Valt

10.5k9 gold badges41 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

0Valt Over a year ago

You are welcome! Btw, since ES6 came around, you can even use calculated properties (for example, parcedData.data[ doSomething() ], as long as doSomething returns a property name

Collectives™ on Stack Overflow

Use a variable in a nested JSON.parse API call

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related