Attempting to get a table of data using rpc in python fails

[nick-gorman]

Describe the bug Attempting to get a table of data using rpc in python fails

To Reproduce

1. Create a simple database function like below:

   create or replace function add_planet(name text)
   returns TABLE(INTERVAL_DATETIME timestamp, DUID text)
   language plpgsql
   as $$
   begin
   return query
   select "INTERVAL_DATETIME", "DUID" from bidding_data limit 10;
   end;
   $$;

2. Call function in python

   url = os.environ.get("SUPABASE_URL")
   key = os.environ.get("SUPABASE_KEY")
   supabase = create_client(url, key)
   data = supabase.rpc('add_planet', {'name': 'pop'}).execute()
   print(data)
   # data=[] count=None

Expected behavior Should return data.

Screenshots Calling the function works via the supabase sql editor

Desktop (please complete the following information):

• OS: Windows 10 Pro for Workstations
• supabase: 0.7.1
• python: 3.9.2

[nick-gorman]

Found the problem, row level security was preventing data from being returned, adding an access policy solved the issue.