jsonb formating problem with supabase stripe wrapper

[janic1994]

Hi,
I want to get the information from stripe into a supabase table, once a user has bought my product from my webpage.
The wrapper already works but i only get the jsonb format for the important information:

How can I copy some information from the jsonb field and insert it into a new row, so that the necessary information is better usable?

Are there any working arounds?

Thank you so much for your help - i tried so many hours and I'm quite lost...

[GaryAustin1]

Can you use a view to map the jsonb individual keys to columns?

[janic1994]

i dont know how that works? can you dgive me some details about your idea :)?

[GaryAustin1]

Supabase docs just have this on views: https://supabase.com/docs/guides/database/tables?queryGroups=language&language=sql#views

But views are a Postgres thing and there should be lots of info or even the Supabase assistant or an AI might help set up a view to remap your jsonb column data to individual columns in the view.

[janic1994]

I cant code... so I may be lost here :/?...

[GaryAustin1]

Yeah you would have to do SQL code to do a view, trust an AI or find someone to write code for you.

[janic1994]

Perplexity was able to help me:
Code works!

CREATE VIEW checkout_view AS
SELECT
*,
attrs->>'customer_details' as customer_details,
(attrs->'customer_details'->>'name')::text as customer_name,
(attrs->'customer_details'->>'email')::text as customer_email
FROM
checkout;

[janic1994]

Thank you so much for your help! :)