Importdata function for prices doesn't work new API Google Sheets

=importdata(“https://api.nomics.com/v1/prices?key=YOURKEY&format=csv”)

This provides me with a N/A error in my Google Sheet for a portfolio tracker setup.

I recently switched to the paid API key for 1$ and received a new key starting with:

“m_f51…”

My other (old & free) API key worked just fine.

Am I missing something here?

I could provide more details if required.

Kind regards,

Max

/prices is a deprecated endpoint and only available to plans purchased when it was not deprecated.

Alright, clear. I’m looking to achieve the same result in a simple list without obtaining a whole dataframe.

Why depreciate an endpoint that worked wonders for a simple purpose like a portfolio tracker.

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.

Hello Nick , thanks for the update.

Since I’m not a true dev, could you help me getting the call right.

=importdata(“https://api.nomics.com/v1/currencies/ticker?key=MYKEY&interval=false&status=active&format=csv”)

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 :stuck_out_tongue:

kind regards,

Max

Hi Max,

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.

Hello there!

[edited s18-03-2022] since I solved my own problem]

Many of us free users are not into dev. work and it’s hard for us to figure out workarounds on our own.

I have imported a free script from GitHub that converts the JSON format into CSV and it works.

Latest version of the sheet for others to use or improve.

A reference to a script like this in addition to the priced plan response would really help newbies out.

Max

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.