Retrieve transactions from order

Hello,

We’re developing an application that retrieves orders and sends them to an external system. We want to add order transactions to our application, but we’re hitting a roadblock while trying to retrieve transactions from Shopify.

For reference: we’re using the REST Admin API.

I’ve tried using the /orders/{order_id}/transactions.json endpoint, but this gives us transactions in the buyer’s currency. We need the transactions in the store’s currency (and we don’t want to mess around with exchange rates ourselves if possible).

The other option I’m seeing is using the /shopify_payments/balance/transactions.json endpoint. This does give us the transactions in the store’s currency but this gives us all the transactions of the store and by what I’m seeing, we cannot filter by source_order_id in the call parameters directly.

Is there a way for us to achieve this, or is the only option getting a list of all the store transactions and then manually filtering them by order_id?

Kind regards