Help with Supabase PATCH request in Make – “Empty or invalid JSON” error

How To
1

Hi everyone,

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://<my-project>.supabase.co/rest/v1/client_documents

  • Method: PATCH

  • Headers:

    • apikey: <anon key>

    • Authorization: Bearer <anon key>

    • Content-Type: application/json

    • Prefer: return=representation

  • Query string parameters:

    • storage_path=eq.client-123/bank-statements/<filename> (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!