Hi-

I’m trying to get the details of individual charges that make up a Stripe payout. I’m not even sure of the best method to do this, but my current step 1 is to trigger on a stripe payout.paid event. I’ve tried it using a Zapier action, and also by catching a webhook initiated from Stripe. In both cases, I can get the event with a unique payout id, but it has no detail on the individual charges that make up the total.

Step 2 should be to call Stripe with the payout id, hope that returns the itemized transactions, and then use a Zapier loop to see the detail on each transaction. Depending on whether or not Stripe returns the actual detail, or just the transaction id, I might have to call Stripe again for each transaction in the loop to get the transaction details. Note that our typical daily payout rarely has more than 10 transactions, so I’m not concerned about volume/performance.

There is no “get payout detail” built-in function in Zapier for Stripe, meaning I’d like need to use the Webhook.

My questions:

1. Is there a better way to do this than what I’ve described above?
2. Given the highly-sensitive nature of the Stripe production secret key, I’m not pasting that into my zap directly for the webhook authorization. The latest advice from Zapier seems to be to use the new functions beta product to store it, but I can’t find any info on how to actually implement the function as part of the process described above. Do I really have to learn Python just to store a single value?

Thanks,

Bill