You'd need to build a specific wrapper for that API. For example, here[0] is the wrapper for Stripe (docs[1])
I think you're looking for something more generic, like pg_net[2]. This would allow you to do your crazy logic by parsing your API response:
select net.http_get('https://news.ycombinator.com') as request_id;
select body, status_code from net.http_collect_response(1, async:=false);
[0] Stripe src:
https://github.com/supabase/wrappers/tree/main/wrappers/src/...[1] Stripe docs: https://supabase.github.io/wrappers/stripe/
[2] pg_net: https://supabase.github.io/pg_net/api/
