Hello, here is my problem,
I am trying superbase with 2 tables:
profiles :
photos:
profile has many photos..
I have a "member" page where I want to fetcha specific profile by id (ex id=2)
and I want all his (2..) photos.
I would like to use a single request and not 2! with superbase I can have a great json response using the API http://myproject?supabase.co/rest/v1/profiles?select=name,birthdate,photos(url)&apikey=xxx
it returns this json which looks cool:
[{"name":"Fabien","birthdate":"2022-02-02","photos":[{"url": "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcTA3vZZroyGSl-DluLgtt888e31f44HmyiRYg&usqp=CAU"}, {"url": "https://lh3.googleusercontent.com/gps-proxy/AMy85WLw1Mcb4LSJr5zCSCJbVb2ehCHHiN3gIp8FXOHvpOUlvWqdOMJmeDcDwttMo88Gyumom9YRbQU65xxwA0KNcSpemwqY2Ox1YbLrlKiBjCvLEiTrviDnziNiGA8MK5SamORJihtS5K3xNRdlqc_TlVsKY3ZKVN36Ux-QXDf4Mkt9o4xmAgjWAph2=s294-w294-h220-n-k-no"}]}]
My questions is, how to call this api (and not use the superbase integration). How to pass the apikey it needs?
OR, is there a better way to have the information I want (view?)
Thank you in advance