Have a sharepoint list with shipping carrier tracking numbers (FEDEX, UPS, USPS). List includes ID, Tracking number, Status (No shipped, In Route, Delivered, Exception), Date Delivered, Received by, Last Check.
Looking for an automation to scan the list for all entries not showing as delivered yet, and update the tracking info, including [login to view URL] Last Check. If the tracking status is showing as delivered, then date delivered and received by would be updated also.
Automation to be ran on schedule. Depending on impact -- daily or as frequent as ever 15 minutes/hourly.
Needs to work with 3 common carries (Fedex, usps, ups). NOt sure if best to scrap info from web, or try to integrate to sites with API. I'm not familiar with process of either.