After years in the mainframe cave, I am now tasked with coding a VBA FEDEX power query whose response populates adjacent cells in the same row. Simply put, I would like to supply a DocID to the FEDEX query and have in response the associated tracking ID, ship date, and ETA .
I have seen a few examples of this query that date back to 2016, but would like a more current template (assuming FEDEX has updated this API) to run with my Excel on 365. From a functional example where I can plug in my own distinct DocID's for test, I can customize the template to execute daily cell repopulations. My biggest concern is the processing latency for queued queries call from multiple rows... do I need to include a pause for each row to wait to returned query data before proceeding to the next row?
Any insights or pointers to FEDEX API guides is appreciated.
I have seen a few examples of this query that date back to 2016, but would like a more current template (assuming FEDEX has updated this API) to run with my Excel on 365. From a functional example where I can plug in my own distinct DocID's for test, I can customize the template to execute daily cell repopulations. My biggest concern is the processing latency for queued queries call from multiple rows... do I need to include a pause for each row to wait to returned query data before proceeding to the next row?
Any insights or pointers to FEDEX API guides is appreciated.