# Revision history [back]

Hello,

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.

Hello,

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/')
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.

Hello,

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/')
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.