Hoping someone can help with this basic question of the best method to create an ETL process to extract my client's Order data to a Data Warehouse. It feels like their are 2 options
- Orders API
- Reports API
But I'm not sure which is the right option.
I'm curious to know, since posting this discussion question, if you have learnt anything around what API or other method is best to use when extracting data or creating an ETL process for Shopify to a data warehouse?