Is there a way i can make a dynamic api which sele...
# sqls
STILLWATER;
05/13/2022, 11:00 AMIs there a way i can make a dynamic api which selects the data requested for the model instead of making get for each field??
STILLWATER;
05/13/2022, 11:02 AMlike how do i process it as supabase takes csv for select, can i do something like taking the column names in json some way and pass supabase csv of that so it gets all those fields mentioned
STILLWATER;
05/13/2022, 11:02 AMany suggestions would be helpful
g
garyaustin
05/13/2022, 2:43 PMNot really clear on your question. If in the same table you can specify any or all columns you want. If you mean select from several different tables the you would need to use an rpc function.
s
STILLWATER;
05/14/2022, 11:40 AMno the table is same just the column i want to be receiving from frontend
STILLWATER;
05/14/2022, 11:41 AMlike my table has columns A B C D E F
STILLWATER;
05/14/2022, 11:41 AMand i want just 1 api instead of 6 for all those columns which returns only those columns requested
STILLWATER;
05/14/2022, 11:41 AMso how should i take the payload and send it to the query