search

bradjasper / ImportJSON

Import JSON into Google Sheets, this library adds various ImportJSON functions to your spreadsheet
GNU Lesser General Public License v3.0
2.09k stars 1.06k forks source link

Data from Json is imported in one Google sheets' cell #99

Open LorkusJurkus opened 6 years ago

LorkusJurkus commented 6 years ago

Hello,

I am trying to import historic data from Bitfinex to Google sheet using your function ImportJSON, but all information is imported into one cell. I've successfully imported information using your function ImportJSON to Google sheets from other exchanges, but with this exchange it does not work. Probably one of reasons could be that data does not have any headers.

Could you please check import of historic data from Bitfinex for example using link below: https://api.bitfinex.com/v2/candles/trade:15m:tETHUSD/hist?limit=385&start=1535122800000&end=1535468400000&sort=1

And here is if you need it link to Bitfinex API: https://docs.bitfinex.com/v2/reference#rest-public-candles

Thank you!

imdkbj commented 5 years ago

I am facing too a same type of issue where attached JSON is not properly imported. 15minute.zip

jandye commented 4 years ago

I have the exact same thing.

dandaka commented 4 years ago

Same here. Anyone knows a fix?

dandaka commented 4 years ago

I have installed https://cryptofinance.ai/ for this purpose :)