Support

Troubleshooting

IssueCauseSolution
Empty resultsNo matching dataVerify filter values match existing data
401 UnauthorizedInvalid API keyCheck API key is correct
Permission deniedRLS blocking accessUse service_role key or check RLS policies
Invalid column errorWrong column nameColumn names are case-sensitive
Key not found: bodyPayloadWrong formatUse JSON string with escaped quotes
No unique constraint (Upsert)Missing constraintAdd unique constraint to onConflict column
Timeout errorsToo much dataAdd filters, reduce limit
Garbled responseCompressionEnsure Accept-Encoding: identity header


 

Best Practices

Performance

  • Select only needed columns instead of *
  • Set appropriate limits
  • Filter at database level, not in Flows
  • Index frequently filtered columns

 

Security

  • Use Row Level Security (RLS) in Supabase
  • Never expose service_role key in public flows
  • Validate inputs when using dynamic values

 

Safety

  • Use specific filters (unique IDs) for Update/Delete
  • Test filters with Query Rows before Update/Delete
  • Consider soft-deletes instead of hard deletes

 

Support

If you encounter issues or have questions:

  • Check the Supabase documentation at docs.supabase.com
  • Review the Flows help documentation
  • Contact support at [email protected]

 

 

Version 1.0 | December 2024

Was this article helpful?