Shopify API call using VBA
Budget: $30 – $250 USD
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. https://shopify.dev/apps/auth/basic-http#basic-authentication
2. https://shopify.dev/api/admin/rest/reference/orders/order
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.:
https://www.access-programmers.co.uk/forums/threads/shopify-api-call.314680/
The API and data is accessed via Shopify Admin API:
1. https://shopify.dev/apps/auth/basic-http#basic-authentication
2. https://shopify.dev/api/admin/rest/reference/orders/order
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.:
https://www.access-programmers.co.uk/forums/threads/shopify-api-call.314680/