Metabase is pretty awesome, and selfhosted/opensource to boot.
I’ve been integrating with their api using the http request node, but it sure would nice if there were a native node.
My workflow has been POSTing their api/card/1/query/csv endpoint to run a query that returns csv. I then spit that out in a form that microsoft excel can use as a refreshable web datasource.
Excel can’t easily POST (instead it GETs) Metabase needs a POST to initiate a fresh query. And I don’t trust Excel to get and manage api keys etc. I do trust n8n though to handle all that.
Once wired up, we give that Excel file to our client’s so they can get updated data on demand.
I’m also interested in this, and hope to have some time to devote to building it… eventually. If anyone can get to it quicker, I can help with testing.
I’m hoping to integrate n8n into my processes! Hoping this Metabase node releases soon so I can do a metabase to salesforce pipeline. It’ll save me 2 hours daily manually uploading!