You will be able to do something like this:
insert into stripe_products (name)
values ('Pizza'), ('Pasta');
This will insert a value into Stripe via the API. Then you can query your stripe products like this: select *
from stripe_products
limit 10;Can't wait until this is ready.
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/
I can't wait for somebody offering a generator, where you plug in your API, it pulls and parses the JSON, then you can select the fields you want and it generates the wrapper. (Alternatively, for put/post you could supply your own JSON).
Practically like some low/no code tools like Appsmith/Budibase and the likes already do today.
Sadly I lack the necessary skills and more important the time to dive into that.
> generator, where you plug in your API, it pulls and parses the JSON, then you can select the fields you want and it generates the wrapper
Probably on this one the wrapper could use an OpenAPI spec
I can now use this instead of creating my own workflow to get the data via an api which will be stored in the DB anyways?