PowerShell - HTML parsing: get information from a website

Question

Update, Script is working with PowerShell V3.0, Thanks @ Doug

I want to use the following PowerShell script to get flight status information from Lufthansa. I can see flight status information in the browser, but I haven't found any way to access this information with my script.

I want to get the following information from the website:

flight status
time (departure, arrival)
airport (departure, arrival)
Flight Number (Only Lufthansa)

Script:

$flight = " LH3396"
$url = "http://bing.com?q=flight status for $flight"
$result = Invoke-WebRequest $url
$elements = $result.AllElements | Where Class -eq "ans" | Select -First 1 -ExpandProperty innerText 

#[string[]]$resultArray

$resultArray = @()

foreach($element in $elements.Split("`n")){
    if($element.Length -gt "2")
    {$resultArray += $element}
}

doubleDown · Accepted Answer · 2015-10-15 05:54:19Z

37

Here is a way to query Bing in PowerShell v3

function Get-FlightStatus {
    param($query)

    $url = "http://bing.com?q=flight status for $query"

    $result = Invoke-WebRequest $url

    $result.AllElements | 
        Where Class -eq "ans" |
        Select -First 1 -ExpandProperty innerText    
}

Get-FlightStatus LH3102

Flight status for Lufthansa 3102

To depart · Jan 30, 2012

From: Hamburg (HAM) 05:35 PM terminal 2

To: Vienna (VIE) 07:05 PM


Bing Travel   Source: www.flightstats.com, 1 minute ago

edited Oct 15, 2015 at 5:54

doubleDown

8,4581 gold badge36 silver badges50 bronze badges

answered Jan 30, 2012 at 4:01

Doug Finke

6,8432 gold badges34 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

LaPhi Over a year ago

Is there an easy way to convert the output to a array?

Doug Finke Over a year ago

try Get-FlightStatus LH3102 -split "rn"

juFo Over a year ago

in case it doesn't work: if you just use bing.com in Belgium it will change the url to be.bing.com and the flight status will not work (because bing is still in beta in Belgium). To fix this just add ?cc=us to the url: "bing.com?cc=us&q=flight status for $query"

Mowgli Over a year ago

Can you please update the script so I can use and learn from it thanks.

TrueWill · Accepted Answer · 2012-01-29 16:58:05Z

11

You could use the Html Agility Pack.

Here's an article on using it with PowerShell: HTML Agility Pack Rocks Your Screen Scraping World

answered Jan 29, 2012 at 16:58

TrueWill

25.7k11 gold badges105 silver badges156 bronze badges

Collectives™ on Stack Overflow

PowerShell - HTML parsing: get information from a website

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related