1. Download Orders from a shopify Site (code to support different sites) into a temporary table
[url removed, login to view]" & sinceId & "&status=any&limit=250"
2. push Tracking back to Shopify
My main challenge is the correct syntax for connecting to the API and iterating through the data to dump it into a table.
I'm new to working with API's in VBA so what I have is a hack. I need someone with expertise to show me the light!
My code for getting orders (the functional hack) is attached. I'm getting a windows security popup as well that I'd like to know how to get rid of (image attached).