How does UPS tracking work?
Modified3 years, 1 month ago. I am trying to use my Excel spreadsheet, which I use to keep track of my UPS shipments to update with the delivery timestamp.I had used the format of:http://wwwapps.ups.com/WebTracking/processInputRequest?HTMLVersion=5.0&loc=en_US&Requester=UPSHome&tracknum=[TRK_ID]&AgreeToTermsAndConditions=yes&ignore=&track.x=25&track.y=16. Where [TRK_ID] would reference the cell range of tracking numbers.With this I could click on the link in the cell and be taken to a page with the tracking information.
- I can't use the API, but want to just report back the delivery timestamp.
- Maybe through Power Query?Can I use Power Query to call the webpage and then extract the delivery confirmation timestamp?
Michael WoodsMichael Woods. It doesn't look there's a clean UPS api to give you the delivery timestamp, but Power Query can parse it out of the HTML:. 22 gold badges3939 silver badges3939 bronze badges. 3939 bronze badges. You can construct a hyperlink in the cell that will go to the relevant page with the HYPERLINK function. Example with a tracking number in A1:.