Syncing Shopify data to an Azure Database can sometimes present challenges, especially when dealing with refunds.
I would recommend you check the refunds endpoint in the Shopify API. Refunds are part of the Shopify Orders API and are linked to specific orders. Ensure that the refund endpoint is being queried correctly or the orders you’re querying actually contain refund data, as refunds won’t exist for orders without refund events.
If it doesn’t work, try using third-party tools. I’m not sure, but maybe Skyvia can do that. You can check it here.