|
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: let PackageDelivery = (tracknum as text) as text => let WebText = Text.FromBinary(Web.Contents("http://wwwapps.ups.com/WebTracking/processInputRequest", [Query = [tracknum = tracknum]])), FromDeliveredOn = Text.Range(WebText, Text.PositionOf(WebText, "Delivered On:")), NextDD = Text.Range(FromDeliveredOn, Text.PositionOf(FromDeliveredOn, "<dd>") + 4, Text.PositionOf(FromDeliveredOn, "</dd>") - Text.PositionOf(FromDeliveredOn, "<dd>") - 4), Cleaned = Text.Clean(Text.Replace(Text.Replace(NextDD, " ", " "), "#(lf)", " ")) in Cleaned, Invoked = PackageDelivery("1ZE1W7530369979412") //Replace with your tracking ID in Invoked (责任编辑：) |