JSON object requested, multiple (or no) rows returned

[zakaria-chahboun]

This is a part of my code:

const {data, error} = await supabase
			.from('test')
			.select('question(question_title, answer(*))')
			.eq('test_id', ID)
			.single();

When i select a non existent value it's gives me this error message:

{
  "message": "JSON object requested, multiple (or no) rows returned",
  "details": "Results contain 0 rows, application/vnd.pgrst.object+json requires 1 row"
}

Whiteout any error number or just return a Null value!

What is the solution? Thanks 💟

[zakaria-chahboun]

I know this is happens cuze of .single() behaviour. For the moment i replaced .single() with .limit(1).

[soedirgo]

Yup, .single() only works if you select exactly 1 row, so you want to use it with .limit(1). If you expect to get 0 rows though you might want to use .maybeSingle() instead.

[zakaria-chahboun]

@soedirgo Thanks!