Shopify integration with Azure Data Factory

[AJWatson]

I'm trying to bring my data from Shopify into an Azure Database. 
- Orders

- Shipping lines

- Products

All work fine. I'm trying to bring in refunds to no avail. Has anyone successed? The API has premissions to read all endpoints. 

After 8 and a half minutes, the Azure trasnfer was still showing no data read. It does appear when I preview data and test the connection. 

Any ideas?

[Harris3]

Hi,

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.

Hope it will be useful.