What are you trying to achieve?
I’m trying to update a row in my Supabase table (client_documents) from Make using an HTTP module. The goal is to set the status field of a document to “processing” when a new file is uploaded.
Here’s my HTTP module setup:
URL: https://.supabase.co/rest/v1/client_documents
Method: PATCH
Headers:
apikey:
Authorization: Bearer
Content-Type: application/json
Prefer: return=representation
Query string parameters:
storage_path=eq.client-123/bank-statements/ (this comes from the Supabase Watch Event in Make)
Body:
{ “status”: “processing” }
When I run the scenario, I consistently get this error from Supabase:
Error 400: Bad Request
{“code”:“PGRST102”,“details”:null,“hint”:null,“message”:“Empty or invalid JSON”}
Things I’ve checked / tried:
The storage_path value is correct and matches the row in Supabase.
Running the same PATCH via curl in Terminal works fine and updates the row.
In Make, the module fails before updating anything.
I’ve also tried turning on the Map toggle and URL-encoding the path.
Has anyone successfully patched a row in Supabase from Make? Am I missing something simple with the way Make structures query strings or request bodies?
Thanks in advance for any guidance!