How to obtain most recent purchase from Stripe API Call and create an Airtable record?

Hi Everyone!
We have created a Make scenario integrated with Stripe and Airtable (image below). We have 90% of this working but are experiencing an issue. The Stripe API Call (module 28) outputs one bundle (collection) containing body (collection) and data (array). This is currently listing all the Stripe products available for client purchase, which is great! The Data is in an array but when the above scenario runs, the output of Stripe (module 28) takes the first iteration of the array and displays this, which is not always the correct product depending on which product the client purchases. The Airtable - Marketplace (module 3) is pulling the correct data but when we go to filter this between module 3 and 5, it is apparent that the issue is in selecting the correct array value from module 28. We have not created an invoices within Stripe…etc as we are trying to build this out piece by piece with testing along the way. Any suggestions and thoughts or recommendations is welcome! We will not be offended by your comments or suggestions, just looking to build our knowledge and correct this scenario in Make. Thanks in advance!

One other question, is how can we obtain only the metadata value (FA-MKT5) from the Stripe API Call (module 28)? Currently it is pulling and displaying the metadata key and value in airtable. Is there a way to remove or parse only the metadata value (FA-MKT5)? Below is record from Airtable.

Make Assistance - Metadata

1 Like