The underlying methodology was unable to price all assets. The Currencies Ticker is able to price many more assets and provide more data. If you’d like to minimize the amount of data returned, you can set interval=false.
The call seems to work but Google Sheets wants me to add 2080 more columns, not gonna happen. If I add “&ids=BTC” and test again I get the sheet populated for BTC data in a JSON format, not csv, though it is specified as such.
I just need a plain list of two columns, tickers on the left and prices on the right - in .csv format. I’m using Google Sheet for a public portfolio tracker and promoting the nomics API.
I could wrangle with the API to produce what I want in RStudio but that’s a personal project and people should be able to do it themselves after they purchase your 1$ API.
Thanks a lot in advance, would appreciate the assistance as I already had some people message me it didn’t work with their new key
Unfortunately we don’t support CSV on the currency ticker because of the added complexity of its functionality and response types. I don’t think we have a simple CSV prices endpoint that could work for you. We understand folks want to be able to use Google Sheets with Nomics data directly, but unfortunately Google Sheets has also been reducing their dynamic data importing functionality over time and we saw less and less demand for this feature due to it.
My best suggestion would be to write a middleware application that would format our data in the structure you want to make it easier for folks to use the data with your portfolio tracker.
Writing custom integrations is available with our Enterprise plans but is not something we provide on the free plan. Our free plan support extends only to the published functionality of the API, so we also do not support custom scripts from other sources, nor can we afford to support software you have written to integrate with our API.
Custom features, integration support, and email support with SLAs are all available via our paid plans:
I appreciate the answers but all I’m saying is that I’m quite sure you also have a respectable amount of people who used your free API for one thing only. The deprecated prices endpoint. From all I’m seeing on the forums many of them are slightly disappointed with what’s been going on. Offering them a solution that works for their problem would increase customer retention and at the same time you would provide excellent customer service to your free user-base. I’m sure you’d want them to upgrade to paid plan organically.
Just writing a message where you (as the provider) would explain how to import a script to work with JSON would already be sufficient. Not asking for any custom integrations at all. Now we have to find out for ourselves.