This is an insulting suggestion if it's not the case but this is often the issue in this situation: does the table have RLS on (probably yes) and if so have you created insert and select policies?