We are using Refund API to extract refunds related data into BigQuery and build custom reports. We are using processed_at field in order to report on the refunds across different days. However, if the order has refunds happening across different days/timestamps, processed_at is not giving the correct refund amount for that order. The only other date related fields we could find in the API are transaction_processed_at, created_at and transaction_created_at. Any help would be appreciated.
While most of the data seems right, we are facing some issues with few refunds. I have noticed that if an order has several line items refunded across different timestamps, the