Russell
BBuildShip
•Created by BBAzn on 3/15/2024 in #❓・buildship-help
how do i make an API call to a supabase function? I have the variable to pass its just one variable.
Thanks @Gaurav Chadha ... I found that after about a day of struggle searching... I think the issue is in the complications of two different systems and I happen to be learning both BuildShip and Supabase (came from C#/Java and MSSQL/MySQL background; just not caught up on the nuances yet). I don't know if my PostgreSQL function should accept text or json or jsonb... I don't know how I should prepare the send from the BuildShip side. I just wish the documentation was expanded a bit to explain how to call a Supabase RPC; I need the benefit of database transactions (if one part of the database calls fail they all roll back), so the nodes won't accomplish what I need. I'll continue working hard on this... I'm so close to feeling like BuildShip is the backend I need to deploy more quickly. I'm hopeful that the Blank Script (haven't had a chance to read it thoroughly) might be better identified as a "code node" where users can do just about anything (including add packages and SDKs)? 🙂
14 replies
BBuildShip
•Created by BBAzn on 3/15/2024 in #❓・buildship-help
how do i make an API call to a supabase function? I have the variable to pass its just one variable.
Been working on this for almost two days - super frustrating... there is ZERO documentation on the Supabase RPC node as built... no idea how to make this work.
14 replies
BBuildShip
•Created by BBAzn on 3/15/2024 in #❓・buildship-help
how do i make an API call to a supabase function? I have the variable to pass its just one variable.
Now I've got "Could not find the function public.save_questions without parameters in the schema cache." Still don't know how to pass a parameter to Supabase RPC - which feels like it should be pretty easy to get from documentation - but I can't find a single example.
14 replies
BBuildShip
•Created by BBAzn on 3/15/2024 in #❓・buildship-help
how do i make an API call to a supabase function? I have the variable to pass its just one variable.
Just dropped the node and rebuilt it.
14 replies
BBuildShip
•Created by BBAzn on 3/15/2024 in #❓・buildship-help
how do i make an API call to a supabase function? I have the variable to pass its just one variable.
Somehow my Node now has a field called "Replace String" which I think it somehow got from the prior node... 😦 No idea if it needs to be renamed.
14 replies
BBuildShip
•Created by BBAzn on 3/15/2024 in #❓・buildship-help
how do i make an API call to a supabase function? I have the variable to pass its just one variable.
Read through all of that... I'm trying this:
'_question_list' : ${['ctx["root"]["0836c6ac-ebb9-46fb-9af6-17d27a28fd68"]']};
and getting an "Unexpected token '{'" reply.14 replies
BBuildShip
•Created by BBAzn on 3/15/2024 in #❓・buildship-help
how do i make an API call to a supabase function? I have the variable to pass its just one variable.
Thank you... I think I'm doing something really simple... I have a series of nodes that gets some data for me and then I want to call a Postgres function on Supabase:
SELECT public.save_questions('
{
"content": "<string from Replace String node>"
}');
To do this from BuildShip I am using the Supabase RPC node - I've got the URL, Key, and Function Name working - but I have no clue how to pass the string coming from the Replace String node higher in the workflow... No matter what I do I get some kind of error - been working on it for four hours - just the darn syntax of how to pass a single unnamed parameter to the RPC function... or named... here's the function declaration incase that helps: CREATE OR REPLACE FUNCTION public.save_questions(_question_list text)
14 replies
BBuildShip
•Created by BBAzn on 3/15/2024 in #❓・buildship-help
how do i make an API call to a supabase function? I have the variable to pass its just one variable.
This is exactly what I came to discord for. Disappointed there's no answer in a month. 😦
14 replies