Refunds through stripe

Anyone using Stripe with Knack? If so, have you tried to automate refunds at all?Knack records an ID for payments made through Stripe - ( format pi_xxxxxxxxx…). I thought these would be the IDs I needed to be able to create a refund screen and have Integromat send a refund API call. Unfortunately, this is not the case - Stripe is looking for a different ID (starting ch_ ) - the pi one is called a payment intent and the ch a charge id.
My client has several HUNDRED refunds to process and manually searching Stripe to find the payment ( there are about 500 a day) is very time consuming.
Has anyone found a way around this?