RPC function not returning all data in Javascript app?

[old-rob]

For context, my database has three important things: items, categories, and clicks. My end goal is for my javascript to be able to call my database with a parameter for categories to include, and a parameter for start and end dates to consider clicks from. This would return a list of any item with a category that matches the first parameter, and the clicks for that item would be a count of every click that was created between the two provided dates.

The problem is that my RPC function refuses to send the categories along to my javascript. Here are some screenshots to show the issue. I've tried so many things to get it to work, but I need some advice. I'm very new to supabase and database design.

This is how I'm calling the function:
const { data, error } = await supabase.rpc('rpc_test', { "json_params": { "categories": '{"colors", "test"}', "start_date": "2024-04-09 00:22:35.837547+00" } })

I've seen various levels of success, but I've never been able to get it all to work together.

[GaryAustin1]

Do you have RLS enabled for all the tables for the user to access?
Does it work if you run it in the SQL editor (there is also impersonation option there to test different user access).

[silentworks]

I can't see some of your SQL here but the table you are getting the categories from is likely to have row level security (RLS) turned on and you are trying to make a request to that table without sufficient permission. A easy way to test this is inside of your SQL editor click on role postgres and change to authenticated and then select a user you want to run this query. Also try anon role too and see if the results match your .rpc function call.