PipedreamHQ / pipedream

Connect APIs, remarkably fast. Free for developers.
https://pipedream.com
Other
8.32k stars 5.27k forks source link

[BUG] Supabase insert action fails to return any values #11602

Closed Golicraft closed 3 weeks ago

Golicraft commented 3 weeks ago

Describe the bug When tried to use and connect into supabase db using Supabase API from Pipedream, it does not connect to the db and failed to retrieve data from the given table.

To Reproduce Steps to reproduce the behavior:

  1. Go to https://pipedream.com/apps/supabase
  2. Click on Insert Row with Supabase API
  3. Connect to supabase db and enter all information
  4. Click test

Expected behavior Returns of list of object from the given supabase table

Screenshots

image image

Desktop (please complete the following information):

Additional context Searched on the forums, watched youtube vids. Also tried the Postgres integration, can't connect with that either. I'm positive that I've entered the auth details as described. Same issue as https://github.com/PipedreamHQ/pipedream/issues/5393

I've tried deploy it too, but it doesn't add any row to the supabase table.

vunguyenhung commented 3 weeks ago

Hey @Golicraft,

You'll need to use custom expression instead, for example {{ {"id": 2, "category": "teacher"} }}

image

So in your case, the data should be {{ {"incentiv": "348"} }}