Shopify - Refunds: Mapping required for refunded_amount

[SindhurRao]

We are trying to ingest Refunds data into Azure SQL DB and the "refunded_amount" is currently mapped to orders>refunds>transactions>receipt>amount. Can you please confirm if this mapping is accurate?

If not, please help us with the exact mapping.

[Josh]

Hello @SindhurRao , 

Your mapping is not incorrect, but I do think that there is an easier way to do this. 

Instead of looking at receipt, which is going to have an amount without decimals, you could use orders>refunds>transactions>amount and skip the receipt portion entirely. This will provide you with the exact amount including the decimal places so you won't have to alter the value provided to simplify the process a little bit.