© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
SupabaseS
Supabase•4y ago•
3 replies
nickreed9888

http_post not working while http_get is fine

Queries using http_get work:
  select content::json->>'allowed'
  from http_get('https://jsonplaceholder.typicode.com/todos/1');
  select content::json->>'allowed'
  from http_get('https://jsonplaceholder.typicode.com/todos/1');


but http_post fails:
  select content::json->>'allowed'
  from http_post('https://jsonplaceholder.typicode.com/todos/1',
    jsonb_build_object('test', 'test')
  );
  select content::json->>'allowed'
  from http_post('https://jsonplaceholder.typicode.com/todos/1',
    jsonb_build_object('test', 'test')
  );


with errors:
hint: "No function matches the given name and argument types. You might need to add explicit type casts."

message: "function http_post(unknown, jsonb) does not exist"
hint: "No function matches the given name and argument types. You might need to add explicit type casts."

message: "function http_post(unknown, jsonb) does not exist"


I don't understand why/how casting is failing, and why get works but not post?
Supabase banner
SupabaseJoin
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.
45,816Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

pgsql-http to GET and POST an image
SupabaseSSupabase / help-and-questions
4y ago
http_get
SupabaseSSupabase / help-and-questions
4y ago
Get Current Project URL in PG_NET http_post?
SupabaseSSupabase / help-and-questions
3y ago
Add Authorization Header to http_post
SupabaseSSupabase / help-and-questions
4y ago