Supabase Node :RPC: Error loading parameter

[Prince_Mathew]

Describe the problem/error/question

I am trying to call a function using Supabase node. I am getting error in the Add condition. “Error fetching options from Supabase tools” and here is the detailed error . Attached the screen shot.

My Supabase connection is authenticated as i am able to fetch the list of tables and RPC.
I have also granted permission to the RPC in supabase
GRANT EXECUTE ON FUNCTION public.get_prospect_onboarding_progress(UUID) TO authenticated;

What is the error message (if any)?

Issues:

• There was a problem loading the parameter options from server: “Cannot read properties of undefined (reading ‘properties’)”

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

• n8n version: : Using cloud
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): Cloud
• Operating system: Ubuntu

[Yo_its_prakash]

This error occurs because the n8n Supabase node can’t properly interpret your function’s parameter schema. Try these fixes:

1. Use HTTP Request node instead:

• Method: POST
• URL: https://[your-project].supabase.co/rest/v1/rpc/get_prospect_onboarding_progress
• Headers:
  • apikey: your-supabase-key
  • Authorization: Bearer your-supabase-key
  • Content-Type: application/json
• Body: {"id": "your-uuid-here"}

2. Fix your function definition in Supabase:

sql

CREATE OR REPLACE FUNCTION public.get_prospect_onboarding_progress(id UUID)
RETURNS json
LANGUAGE plpgsql
SECURITY DEFINER
AS $
BEGIN
  -- Your function code
END;
$;

3. Specify parameter manually in the Supabase node:

• Add UUID parameter without using the dropdown
• Enter the parameter name and value directly

The n8n Supabase node sometimes has trouble with function parameters that use custom types or have complex definitions.

If my solution helps solve your issue, please consider marking it as the answer! A like would make my day if you found it useful!

[Prince_Mathew]

@Yo_its_prakash . Thank you for your reply. HTTP node is what i thought as an alternative. But will try what you have suggested.

[Prince_Mathew]

@Yo_its_prakash Will this issue be fixed by n8n teams.