zenminimalist

Same issue when I import for e.g. =importJSON("https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=netSharePurchaseActivity") On every tab, new speadsheet I open - no matter what. But, here's the twist: If I open a new spreadsheet with...

@qeet I'm trying to switch from importJSON to this more powerful JSONAPI, but I'm only getting partial results back: `{"result":[{"netSharePurchaseActivity":{"maxAge":1...` like it's cut off... I used: `=IMPORTJSONAPI("https://query2.finance.yahoo.com/v10/finance/quoteSummary/AAPL?modules=netSharePurchaseActivity"; "$";"quoteSummary")` If I...

Thanks a lot. That's extremely helpful! So from my understanding, there's no way to tell it to pull everything below root? What string to I have to add and where...

@qeet Is there a way to have JSONAPI give back the headers/title column? I didn't see anything related to this in the doc. But maybe I oversaw that.

@akonyar @eemreyesil Is there a way I can change this code to get a sheet to only refresh/update when say cell A1 is TRUE (e.g. checkbox is ticked), so I...

This is still an issue. Any way CA could pull the system setting or a configuration option to change this? Ideally one could set the decimal and thousand seperator.

> There's no easy way to get that configuration, i haven't have the time to look at this as i'm currently busy but as soon as i've some free time...

Any word on this issue? Would be a great addition to v3.1 🙂

Guys, we need to start buying this dev some coffee to get this fix :)

Thanks, that's a shame. As a workaround: How would you approach this to change them in bulk?