supabase-py: rpc() - value is not a valid list

change result = supabase.rpc("get_headphones_products", {}) TO result = await supabase.rpc("get_headphones_products", {}).execute()

Hey,

Wanted to echo the sentiment above ^ we’ll push out a fix shortly

A PR has been opened to fix this issue and we will get it merged in soon https://github.com/supabase-community/postgrest-py/pull/309

This should now be available in the latest v1.1.0 of the supabase-py library.

@ShantanuNair we have seen this issue and are currently looking into it.

I still have the issue, when trying this ans=supabase_client.rpc(“count_duplicate_emails”,{}) I get <postgrest._sync.request_builder.SyncFilterRequestBuilder object at 0x10fe32ee0> and when trying ans=await supabase_client.rpc(“count_duplicate_emails”, {}).execute() it returns AttributeError: ‘int’ object has no attribute ‘get’, it works when calling with a Post request, but not with the Supabase python library

I have the same issue when calling a function. the same code worked well in javascript

async def test_func():
    result = supabase.rpc("get_headphones_products", {})
    return result

data = None

resp = await test_func()
data = resp

the response is: <postgrest._sync.request_builder.SyncFilterRequestBuilder object at 0x10fe32ee0>

@louis030195 @modyabhi @e-gons I had the same issue. Was able to make it work with the Table return type in the function. For example following function is working: CREATE OR REPLACE FUNCTION get_ids(id text) RETURNS TABLE (id text[]) AS $$ BEGIN RETURN QUERY ( SELECT array_agg(id::text) FROM ( SELECT id FROM table1 LIMIT 20 ) subquery ); END; $$ LANGUAGE plpgsql;

And I get the same error if I get any other return type i.e. json, text , array etc.

Bumping this, same issue here when the function returns a value on version 1.0.3.

FUNCTION CODE:

CREATE OR REPLACE FUNCTION insert_subscription(
    usr text,
    id text,
    code text,
    expiry date DEFAULT NULL
)
RETURNS text AS $$
DECLARE
  result text;
BEGIN
  -- Check if the subscription already exists
  IF EXISTS (
      SELECT 1 FROM subscription
      WHERE discord_id = insert_subscription.id
        AND asx_code = insert_subscription.code
  ) THEN
      result := 'Error: Subscription already exists.';
  ELSE
      -- Insert a new row into the subscription table
      INSERT INTO subscription (discord_user, discord_id, asx_code, subscription_expiry)
      VALUES (usr, id, code, expiry);
      result := 'Success: Subscription inserted.';
  END IF;
  
  RETURN result;
END;
$$ LANGUAGE plpgsql;

PYTHON MODULE:

from dotenv import load_dotenv
import os
from supabase import create_client, Client
SUPABASE_URL = os.environ.get("SUPABASE_URL")
SUPABASE_KEY = os.environ.get("SUPABASE_SECRET_KEY")
supabase = create_client(SUPABASE_URL, SUPABASE_KEY)
payload = {'usr': 'abcd', 'id': 1234, 'code': 'WPC'}
res = supabase.rpc('insert_subscription',payload).execute()

ERROR:

ValidationError                           Traceback (most recent call last)
File [~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/postgrest/_sync/request_builder.py:66](https://file+.vscode-resource.vscode-cdn.net/Users/amody/Downloads/pyasx-master/pyasx/~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/postgrest/_sync/request_builder.py:66), in SyncQueryRequestBuilder.execute(self)
     63 if (
     64     200 <= r.status_code <= 299
     65 ):  # Response.ok from JS (https://developer.mozilla.org/en-US/docs/Web/API/Response/ok)
---> 66     return APIResponse.from_http_request_response(r)
     67 else:

File [~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/postgrest/base_request_builder.py:162](https://file+.vscode-resource.vscode-cdn.net/Users/amody/Downloads/pyasx-master/pyasx/~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/postgrest/base_request_builder.py:162), in APIResponse.from_http_request_response(cls, request_response)
    161 count = cls._get_count_from_http_request_response(request_response)
--> 162 return cls(data=data, count=count)

File [~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/pydantic/main.py:342](https://file+.vscode-resource.vscode-cdn.net/Users/amody/Downloads/pyasx-master/pyasx/~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/pydantic/main.py:342), in pydantic.main.BaseModel.__init__()

ValidationError: 1 validation error for APIResponse
data
  value is not a valid list (type=type_error.list)

During handling of the above exception, another exception occurred:

AttributeError                            Traceback (most recent call last)
Cell In[19], line 1
----> 1 res = supabase.rpc('insert_subscription',payload).execute()

File [~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/postgrest/_sync/request_builder.py:70](https://file+.vscode-resource.vscode-cdn.net/Users/amody/Downloads/pyasx-master/pyasx/~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/postgrest/_sync/request_builder.py:70), in SyncQueryRequestBuilder.execute(self)
     68         raise APIError(r.json())
     69 except ValidationError as e:
---> 70     raise APIError(r.json()) from e
     71 except JSONDecodeError as e:
     72     raise APIError(generate_default_error_message(r))

File [~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/postgrest/exceptions.py:21](https://file+.vscode-resource.vscode-cdn.net/Users/amody/Downloads/pyasx-master/pyasx/~/opt/anaconda3/envs/py10/lib/python3.10/site-packages/postgrest/exceptions.py:21), in APIError.__init__(self, error)
     19 def __init__(self, error: Dict[str, str]) -> None:
     20     self._raw_error = error
---> 21     self.message = error.get("message")
     22     self.code = error.get("code")
     23     self.hint = error.get("hint")

AttributeError: 'str' object has no attribute 'get'

Similar issue here where a stored function returns a NUMERIC