Using PowerShell & Invoke-Webrequest to get specific information

Question

My code is below, it's pretty much complete, however a tiny part I am stuck on.

Basically what the code does is, based on a Song, the script goes out to a couple of websites on the internet to bring back the song label, composer & year that the song was released.

Only thing is, with the particular song Alicia Keys - Girl On Fire, if you manually go to the website http://staff.australian-charts.com/showitem.asp?interpret=Alicia+Keys+feat%2E+Nicki+Minaj&titel=Girl+On+Fire&cat=s you will notice that there is more than one Composer listed under the Music/Lyrics section.

In the event the song has more than one composer, my script below in it's current state will grab the first composer listed only.

What I need is for the script to grab all the composers. If there's one composer, or if there are multiple composers, I need them captured in the format of "Composer1, Composer2, Composer3, Composer4" etc (Commas included)

I am thinking of changing the Invoke-Webrequest to get TABLES back and particular tables with rows etc, not sure....

$song = "Alicia Keys - Girl On Fire"
Write-Host $song
$SearchSong = $song -replace '\(' -replace '\)' -replace '&' -replace ' - ', ' ' -replace '\s','+'
$MatchSong = $song -replace ' - ', '&amp;titel=' -replace '\s','\+'

#Check iTunes for music Label information
$uri = "https://itunes.apple.com/search?term=$SearchSong&country=au&entity=song"
$x = Invoke-WebRequest -Uri $uri
$iTunesResults = ($x.Content | ConvertFrom-Json).results
$y = Invoke-WebRequest -Uri $iTunesResults[0].trackViewUrl
$iTunesSongCopyright = ($y.ParsedHtml.getElementsByTagName('li') | ? {$_.ClassName -eq 'copyright'}).innerText -replace '℗ '
$iTunesSongLabel = $iTunesSongCopyright -replace '.*\d\s'

#The check australian-charts for Composer & Year infomation
$domain = 'http://staff.australian-charts.com/'
$uri = $domain + "search.asp?search=$SearchSong&cat=s"
$x = Invoke-WebRequest -Uri $uri

$x.AllElements[462].outerHTML -match 'A.href="(.*)"';$resultURL = $domain + $Matches[1]
$resultURL = $resultURL -replace("&amp;","&") -replace('&quot;','"')

$y = Invoke-WebRequest -Uri $resultURL

$Element = ($y.AllElements | ? {$_.tagName -eq 'HTML'})

    if($Element.innerText -match 'Music\/Lyrics:(.*)')
    {
        $Element.innerText -match 'Music\/Lyrics:(.*)'
        $Composer = $Matches[1]
        Write-Host $Composer

    } else {

        $Composer = $null
    }

    if($Element.innerText -match 'Year:(.*)')
    {
        $Element.innerText -match 'Year:(.*)'
        $Year = $Matches[1]
        Write-Host $Year

    } else {

        $Year = $null
    }

    Write-Host $iTunesSongLabel

Hi Marc, there is no need to repeat the -match inside the if curly brackets - the $matches[1] are still valid. — user6811411
– user6811411, Commented Dec 3, 2016 at 10:14
If you dot source your script and take a look at $elements.innertext you will notice that it takes a different approac to grep multiline elements with a regex, maybe differentiate with the html dom — user6811411
– user6811411, Commented Dec 3, 2016 at 11:10

ClumsyPuffin · Accepted Answer · 2016-12-03 10:51:00Z

1

you can use this for getting composer list :

 if($Element.innerText -match 'Music\/Lyrics:(.*)')
    {
    $startpos = $Element.innertext.IndexOf("Lyrics:") + 7
    $endpos = $Element.innertext.IndexOf("Producer:") -1
    $composer=$Element.innertext.substring($startpos,($endpos - $startpos))
    #even the below line will give the same result as the above line if uncommented
    #$composer = $Element.innertext[$startpos..$endpos] -join ""
    Write-Host $Composer

    }

edited Dec 3, 2016 at 10:51

answered Dec 3, 2016 at 10:27

ClumsyPuffin

4,0791 gold badge19 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Using PowerShell & Invoke-Webrequest to get specific information

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related