Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

  • Anonymous's avatar
    Anonymous
    5 years ago

    NVM fixed using the HTML viewer, thanks for the help

     

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    NVM fixed using the HTML viewer, thanks for the help

     

  • It sounds like you don't actually have a Power Query issue but need help displaying the result as SVG, is that correct? 

    • Anonymous's avatar
      Anonymous
      Not 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