STHS Forum

Code: Select all

function Get-NHLData{
Write-Host "Fethcing" $URL
$Data = Invoke-RestMethod -uri $URL
$Data.goalie | Add-Member -MemberType NoteProperty -Name Team -Value $Team
$Data.defensemen | Add-Member -MemberType NoteProperty -Name Team -Value $Team
$Data.forwards | Add-Member -MemberType NoteProperty -Name Team -Value $Team
$Data.goalie | Export-csv $File  -Append -NoTypeInformation -Force
$Data.defensemen | Export-csv $File  -Append -NoTypeInformation -Force
$Data.forwards | Export-csv $File  -Append -NoTypeInformation -Force
}

$File = "NHLData.csv"
If(Test-Path -Path $file){Remove-Item $File}
$NHLTeamArray = @("ANA","ARI","BOS","BUF","CAR","CBJ","CGY","CHI","COL","DAL","DET","EDM","FLA","LAK","MIN","MTL","NJD","NSH","NYI","NYR","OTT","PHI","PIT","SJS","STL","TBL","TOR","VAN","WPG","WSH")

ForEach($Team in $NHLTeamArray){
$URL = "http://nhlwc.cdnak.neulion.com/fs1/nhl/league/teamroster/"+$Team+"/iphone/clubroster.json"
Get-NHLData -url  $URL
}

Code: Select all

$File = "NHLData.csv"
If(Test-Path -Path $file){Remove-Item $File}
$JSON = Invoke-RestMethod -uri "https://statsapi.web.nhl.com/api/v1/teams?expand=team.roster&season=20172018&site=en_nhl"
$Team = $JSON.teams
ForEach($TeamData in $Team){
    $TeamAbre = $TeamData.abbreviation
    Write-host $TeamAbre -BackgroundColor Green
    ForEach($Person in $TeamData.roster.roster.person){        
        $Person | Add-Member -MemberType NoteProperty -Name Team -Value $TeamAbre
        $Person | Export-csv $File -Append -NoTypeInformation -Force
    }
}

Code: Select all

$Data = Invoke-RestMethod -uri http://nhlwc.cdnak.neulion.com/fs1/nhl/league/playerstatsline/20132014/2/ANA/iphone/playerstatsline.json
$Data.goalieData | Export-csv "GoaliesData.csv" -NoTypeInformation -Force
$Data.skaterData | Export-csv "SkatersData.csv" -NoTypeInformation -Force

Code: Select all

$JSON = Invoke-RestMethod -uri "https://statsapi.web.nhl.com/api/v1/schedule?season=20212022"
$Schedule = $JSON.Dates
$Day = 0
ForEach($ScheduleData in $Schedule){
    $Day++
    $Games = $ScheduleData.games
    ForEach($GamesData in $Games){        
        $RawData = new-object PSObject
        $RawData | Add-Member -MemberType NoteProperty -Name "Day" -Value $Day   
        $RawData | Add-Member -MemberType NoteProperty -Name "GameDate" -Value $GamesData.gameDate
        $RawData | Add-Member -MemberType NoteProperty -Name "GameType" -Value $GamesData.gameType
        $RawData | Add-Member -MemberType NoteProperty -Name "Visitor" $GamesData.teams.away.team.name
        $RawData | Add-Member -MemberType NoteProperty -Name "Home" $GamesData.teams.home.team.name
        $RawData | Export-csv "NHLData.csv" -Append -NoTypeInformation -Force -Encoding utf8
    }
}