Being able to filter or have more flexible URL loader is definitely on the radar. There are two approaches I’m considering:
Use some sort of JSON query language (there are several). When defining a “query” that loads data from a URL, you will provide the URL and optional JSON query. This will allow for filtering, but not roll ups.
Allow running SQL queries on top of the loaded data (or any other query result in Redash).
And there is of course the option to support both While #2 might sound complex, it’s not that hard to implement using approach similar to q – load the query result (or data from URL) into a temporary SQLite database, run the query and provide the result.
Login or sign up disabled while the site is in read only mode