Forum Discussion
UPS tracking with HTML viewer
hi guys,
Im using power query to use shipment data using the tracker from various shipping sites. Im having trouble with UPS as the HTLM viewer doesnt seem to view the table with actual shipment data
heres an example using the standard ups tracking site
M Code
let
Source = Web.BrowserContents("https://www.ups.com/track?loc=null&tracknum=[insert tracking number here]&requester=WT/trackdetails"),
#"Extracted Table From Html" = Html.Table(Source, {{"Column1", "DIV.ups-table.ups-progress_table.ups-data_table.ups-group > TABLE:nth-child(3) > * > TR > :nth-child(1)"}, {"Column2", "DIV.ups-table.ups-progress_table.ups-data_table.ups-group > TABLE:nth-child(3) > * > TR > :nth-child(2)"}}, [RowSelector="DIV.ups-table.ups-progress_table.ups-data_table.ups-group > TABLE:nth-child(3) > * > TR"])
in
#"Extracted Table From Html"
the same adresss does show more detailed data like date of shipment and recived date(as Shown below) , yet i cant get the viewer(html) to view
any ideas on what may be causing issue
- Anonymous5 years ago
NVM fixed using the HTML viewer, thanks for the help
3 Replies
- AnonymousNot applicable
NVM fixed using the HTML viewer, thanks for the help
- Pascal_KTeamResolver I
It sounds like you don't actually have a Power Query issue but need help displaying the result as SVG, is that correct?
- AnonymousNot applicable
Not sure what you mean by SVG,but yes what i need is a way to get the date information (picture below)
if posible this part as well