Fetching all values from the API returns nothing, while executing the same SQL query in the SQL editor returns the correct values.

[VMM-MMV]

Bug report

Fetching all values from the API returns nothing, while executing the same SQL query in the SQL editor returns the correct values.

Describe the bug

When I execute a query to retrieve all records from a table, the API returns an empty response, even though the table contains data. However, when I run the same SQL command directly in the SQL editor, I get the expected results.

Expected behavior

Executing a SELECT * query should return all records from the table.

System information

• OS: Windows

Additional context

This is how my model looks:

using Supabase.Postgrest.Attributes;
using Supabase.Postgrest.Models;

namespace Aplication.DB.Model;

[Table("appointments")]
public class Appointments : BaseModel
{
    [PrimaryKey("id")]
    public int Id { get; set; }
    
    [Column("patient_id")]
    // [Reference(typeof(Patient))]
    public int PatientId { get; set; }
    
    [Column("doctor_id")]
    public int DoctorId { get; set; }
    
    [Column("appointment_date")]
    public DateTime AppointmentDate { get; set; }
    
    [Column("status")]
    public string Status { get; set; } = string.Empty;
}

This is how I am making the request

var response = await _supabase.From<Appointments>().Get();

In the purpose of debugging I print these values

        Console.Write(response.Content);
        Console.Write(response.ResponseMessage);
        Console.Write(response.ToString());
        Console.Write(response.ClientOptions);

And their response is

[]StatusCode: 200, ReasonPhrase: 'OK', Version: 1.1, Content: System.Net.Http.HttpConnectionResponseContent, Headers:
{
  Date: Sat, 01 Mar 2025 17:26:23 GMT
  Transfer-Encoding: chunked
  Connection: keep-alive
  CF-Ray: 919a5bebc899c9d1-OTP
  CF-Cache-Status: DYNAMIC
  Strict-Transport-Security: max-age=31536000
  Vary: Accept-Encoding
  content-profile: public
  sb-gateway-version: 1
  sb-project-ref: ozfnnyfhbefyndysdfvj
  X-Content-Type-Options: nosniff
  x-envoy-attempt-count: 1
  x-envoy-upstream-service-time: 77
  Server: cloudflare
  Alt-Svc: h3=":443"
  Content-Type: application/json; charset=utf-8
  Content-Range: */*
  Content-Location: /appointments
}Supabase.Postgrest.Responses.ModeledResponse`1[Aplication.DB.Model.Appointments]Supabase.Postgrest.ClientOptions

Here is how the table looks

I have RLS turned off

Is there some more info I could provide to better explain the problem?

Thank You in advance.