Hacker News new | ask | show | jobs
by patife 1200 days ago
You can query Rows with QUERY(), with the new PARSE() that uses JsonPath schema. Pretty powerful.

Beyond that you can use the free Restful API.

What exactly are your needs from Excel Query Pivot Tables? What’s the best of it?