Send quantity and dynamic succes url to Stripe

[Emiel]

Following up on Teodor's tutorial on Stripe checkout with custom products:

@Teodor

Stripe checkout expects 4 values to be sent to it:
title (mandatory) - The name of the product
amount (mandatory) - The price of the product
currency (optional) - The currency. If not provided it defaults to usd
quantity (optional) - The quantity that should be added to the cart. If not provided, it defaults to 1

How can I send the right quantity to Stripe? I tried to get it through the query, although I am quite sure that doesn't make sense because it's stored in the data store instead of the products db table:

How can I get the quantity value from the lineItems array per line and pass it on to stripe?

Also I would like to know how to set the success_url (if set in AC Stripe element as dynamic attribute)
as a dynamic value to the SC Create Checkout Session? I tried using a variable calles succes_url (see screenshots below), but that didn't work. What's the right variable name to use in the SC for this dynamic attribute?

Thanks for any help in advance.

[Emiel]

@Teodor could you give some guidance on this topic? Thanks.

[Teodor]

Please check:

Join Results of 2 Data Collections

Intro Using the Data Transformations options you can easily join the results of two different data sources such as - a database query and an API response, the results of 2 database queries from 2 different databases, or any other array data. In our example we will show you how to join the results of 2 database queries from 2 different databases. Data Transformation We have two database queries using two different database connections, so we can’t join them using the query builder. We can joi…

Now you can join the query results and the data store results and use the joined set as line items.

[Emiel]

Thanks @teodor, although I used the currently available custom checkout form in the end, which suits even better in this case and makes the use of this suggested method unnecessary. Thanks anyway