How can I parse this URL in google sheets to just show price?

How could I use the "importdata" function in google sheets with this URL to parse the data from the URL and just show the price in a cell?

Here is an example of what I am looking to do, just with the above URL

=VALUE(SUBSTITUTE(SUBSTITUTE(INDEX(IMPORTDATA("https://api.pro.coinbase.com/products/ETH-USD/ticker"),0,2), "price:",""), """", ""))

Upvotes: 0

Answers (2)

Reputation: 4038

You can also try using a combination of QUERY & REGEXEXTRACT:

=REGEXEXTRACT(QUERY(IMPORTDATA("https://api.pro.coinbase.com/products/ETH-USD/ticker"),"Select Col2"),"price:""(.*)""")

Upvotes: 1

Reputation: 1

try:

=REGEXEXTRACT(IMPORTDATA(A1), "\d+.\d+|\d+")*1

Upvotes: 1