Stripe Component for Main and Sub Tables

Matillion ETL
1

Hello! We are attempting to use the Stripe Component to pull in Transfers and TransferReversals Tables. However, are unsuccessful in pulling in TransferReversals since it depends on receiving an Id that is present in the Transfers table. Has anyone had any experience with this?

2

Hi there @Rashmi​ and thanks for posting your question! I have something that might help. Try this in advanced mode in the query component:

SELECT * from TransferReversals

where Id in

(Select Id from Transfers)

Let us know how you get on!

Many thanks,

Claire

3

Thanks much Claire! This worked for us :)