MS ACCESS VBA - SHOPIFY (GET ORDERS, PUT TRACKING)

1. Download Orders from a shopify Site (code to support different sites) into a temporary table [login to view URL]" & 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).