I am new to API use. I urgently need to import data into a Google Sheets spreadsheet for personal use.
I have found no issues using =IMPORTDATA(“https://api.nomics.com/v1/prices?key=MY-API-HERE&format=csv”) command and receive price data, however when I replace “prices?” with “market_cap?” I get no data. I really need Market cap totals and a couple of other variables, so how do I get this to work? Also can I request more than one dataset using IMPORTDATA?
Please help, I am certain I can follow any steps you might suggest.