Supabase•3y ago

Not getting any data from my table

Just started following the guides on the supabase website and got to the part where it shows how to get my data from my tables, but my data variable is empty and error is null. Any ideas what is going on?

import { createClient } from '@supabase/supabase-js';
import { config } from 'dotenv';
config();

const supabaseUrl = process.env.SUPABASE_URL;
const supabaseKey = process.env.SUPABASE_KEY;
const supabase = createClient(supabaseUrl, supabaseKey);

const { data, error } = await supabase.from('test').select();

if (data) console.log('data: \n' + data + '\n');
if (error) console.warn('error: \n' + error + '\n');

import { createClient } from '@supabase/supabase-js';
import { config } from 'dotenv';
config();

const supabaseUrl = process.env.SUPABASE_URL;
const supabaseKey = process.env.SUPABASE_KEY;
const supabase = createClient(supabaseUrl, supabaseKey);

const { data, error } = await supabase.from('test').select();

if (data) console.log('data: \n' + data + '\n');
if (error) console.warn('error: \n' + error + '\n');

Output:

(node:5584) ExperimentalWarning: The Fetch API is an experimental feature. This feature could change at any time
(Use `node --trace-warnings ...` to show where the warning was created)
data:

(node:5584) ExperimentalWarning: The Fetch API is an experimental feature. This feature could change at any time
(Use `node --trace-warnings ...` to show where the warning was created)
data:

4 Replies

𝐿𝒶𝒸𝒽𝒾𝑒•3y ago

It may be worth checking you don't have RLS enabled for the test column 🙂

say turn•3y ago

hi, what version of node are you using? might be worth selecting something?

await supabase.from('test').select(*)

await supabase.from('test').select(*)

say turn•3y ago

you are not selecting anything.

★𝒄𝒍𝒂𝒊𝒓𝒆★OP•3y ago

ahhh that was it! guess i missed it somewhere while trying to figure this stuff out lol. had the thought of it being some type of permission error when i got off for the night

Gaming

Programming

Not getting any data from my table

Did you find this page helpful?