Tracking Status of UPS shipments

[snuffnchess]

Hello All.

100% complete newby to PQ here.  VBA I am great with, but this is a whole new animal to me.  

I have a listing in Excel of about 4,100 UPS Tracking Numbers that I am wanting to pull tracking status for.  

Tracking numbers exist in a file and have column Header "Tracking"

The UPS Tracking URL is: https://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=[TRACKING]&requester=ST/trackdetails and the data that I am wanting to pull what currently shows as "Estimated delivery" and then the next line that shows the date.  

https://wwwapps.ups.com/WebTracking/track?track=yes&trackNums=1ZAV58360341868122&requester=ST/trackd...

Looking at the Page Source it is data that exists within the following tags:

<span _ngcontent-epr-c62="" id="st_App_EstDelLabel" class="ng-star-inserted">Estimated delivery</span>

<p _ngcontent-epr-c62="" id="st_App_chkLaterForEstDel" class="ups-txt_size_xl ups-txt_teal ups-txt_bold ng-star-inserted">
The delivery date will be provided as soon as possible.
</p>

A similar post located at https://community.powerbi.com/t5/Power-Query/UPS-tracking-with-HTML-viewer/m-p/1991189#M58665 seems to maybe address some of this, and I tried to emulate what was 

[Anonymous]

Hi @snuffnchess ,

I did some crawling and testing and wasn't able to get the fields I needed. I suggest you contact the support of this site and ask if they are willing to provide the Api for the query.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum