I need help to write a VBA script that can download all order data (JSON file) between two dates from Shopify and list the data on a new sheet in the Excel file.
The API and data is accessed via Shopify Admin API:
1. [login to view URL]
2. [login to view URL]
I will not provide API key etc.
I think the row max limit for one API call is 250 so the script might need to loop until all orders is downloaded.
I've googled and there are similar solutions out there, e.g.:
[login to view URL]