Hi everyone! I'm new to development so I appreciate all the help 🙂 I've started learning with Svelte.js and have grown to love it while using supabase as a backend for my simple blog site. I'm using just the fetch functions to get data from my sb db. The issue I was running into was building my blog post page. When requesting the information it would be returned as an array. Upon doing some research I found that it could be possible to get a single object back by changing the "Accept" header to "application/vnd.pgrst.object+json". It appeared to fix it but then I started getting a 401 which appears to be a CORS issue. Some guidance on this would be great since I've been stuck on this for 3+ days. Thanks!! 😄

Can you provide a bit more detail on your call, your actual network request with error response and any RLS you deal with. Too many variable in your description to start guessing.

Totally get it, sorry I'm new at this. This is what I'm playing with. The first is an image of my fetch request, second is the svelte error I get, the last is the response shown on my console.

So was this working and then it broke? You need need a bearer token (anon,service,user) in addition to apikey. I actually don't even see the apikey in your 3rd pic, but just skimming...

curl 'https://ugccqefilvseqbseypbq.supabase.co/rest/v1/test?select=id' \
-H "apikey: SUPABASE_KEY" \
-H "Authorization: Bearer SUPABASE_KEY"

So I got it working but the response continues to be an array 😛

Well obviously easy to deal with that in your handler.... but the accept header Accept: application/vnd.pgrst.object+json if added with everything else that is working is supposed to return without the array... BUT only if the select with filter returns a single row. Anything more and you get 406 error.