Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello,

Please see this question - How to Link An API into a Spreadsheet.

What you are dealing with is a JSON file. Have accessed this and similar successfully using a Python macro just for my own test.

Also, the link you provided is not a bug report. Bug reports can be found here - Bugzilla.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

Hello,

Please see this question - How to Link An API into a Spreadsheet.

What you are dealing with is a JSON file. Have accessed this and similar successfully using a Python macro just for my own test.

Bar minimum Python code to retrieve the data:

import json
from urllib.request import urlopen

url = urlopen('https://api.coinmarketcap.com/v1/ticker/')
obj = json.load(url)
if int(obj[0]['rank']) == 1:
    coin_name = obj[0]['name']
    coin_price = obj[0]['price_usd']
print(coin_name)
print(coin_price)

result (as of time this was executed):

Bitcoin
10880.7

Then the code needs modification to move whatever data is wanted in the desired place whether its' a spreadsheet, document, database table, etc.

Also, the link you provided is not a bug report. Bug reports can be found here - Bugzilla.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

Hello,

Please see this question - How to Link An API into a Spreadsheet.

What you are dealing with is a JSON file. Have accessed this and similar successfully using a Python macro just for my own test.

Bar Bare minimum Python code to retrieve the data:

import json
from urllib.request import urlopen

url = urlopen('https://api.coinmarketcap.com/v1/ticker/')
obj = json.load(url)
if int(obj[0]['rank']) == 1:
    coin_name = obj[0]['name']
    coin_price = obj[0]['price_usd']
print(coin_name)
print(coin_price)

result (as of time this was executed):

Bitcoin
10880.7

Then the code needs modification to move whatever data is wanted in the desired place whether its' a spreadsheet, document, database table, etc.

Also, the link you provided is not a bug report. Bug reports can be found here - Bugzilla.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.