[BUG] Metabase Run Query component using incorrect endpoint

[adrian-gtintel]

Describe the bug

pipedream/components/metabase/metabase.app.mjs

Line 139 in 2db2518

path: `/card/pivot/${cardId}/query`,

The current API endpoint in use only returns metadata about the query and not the query results content.

I believe the API endpoint for run query should be card/{card-id}/query, which does return the query results content.

To Reproduce
Steps to reproduce the behavior:

1. Add a new workflow step for Metabase --> Run Query
2. Add a new connection for Metabase(API Auth Token)
3. Set your Card ID.
4. Check response result and the fact that it does not contain query content, only metadata.

Expected behavior
Return then query results for the chosen Metabase card.

[vunguyenhung]

Hi everyone, all test cases are passed! Ready for release!

Test report
https://vunguyenhung.notion.site/BUG-Metabase-Run-Query-component-using-incorrect-endpoint-237bf548bb5e8168a513cd3617fcaa70