Teams-repoaccess.ps1


Write-Output "    _____                     _______                                                          "
Write-Output "   |  __ \                   |__   __|                               /\                         "
Write-Output "   | |__) |___ _ __   ___       | | ___  __ _ _ __ ___  ___         /  \   ___ ___ ___  ___ ___  "
Write-Output "   |  _  // _ \ '_ \ / _ \      | |/ _ \/ _  | '_ ` _  \/ __|       / /\ \ / __/ __/ _ \/ __/ __|  "
Write-Output "   | | \ \  __/ |_) | (_) |     | |  __/ (_| | | | | | \__ \      / ____ \ (_| (_|  __/\__ \__ \ "
Write-Output "   |_|  \_\___| .__/ \___/      |_|\___|\__,_|_| |_| |_|___/     /_/    \_\___\___\___||___/___/ "
Write-Output "              | |                                                                               "
Write-Output "              |_|                                                                               "
Write-Host   

                             
                         

$PATToken = Read-Host -Prompt 'GitHub Token' -AsSecureString
$Organization = Read-Host -Prompt 'GitHub Organization'
$ExcelSourceDir = Read-Host -Prompt 'Excel Source'
$WorkSheetName = Read-Host -Prompt 'Specify the worksheet name'


$UserToken =[Runtime.InteropServices.Marshal]::PtrToStringAuto([Runtime.InteropServices.Marshal]::SecureStringToBSTR($PATToken))

$head = @{

	Authorization = 'Bearer ' + $UserToken
	Accept ="application/vnd.github.nebula-preview+json"
	
}

$excel = New-Object -com Excel.Application

$wbook = $excel.workbooks.open($ExcelSourceDir)


$worksheet = $wbook.Worksheets.Item($WorkSheetName)

$maxrows = ($worksheet.UsedRange.Rows).Count

$wbobject = New-Object -TypeName psobject
$wbobject | Add-Member -MemberType NoteProperty -Name Team -Value $null
$wbobject | Add-Member -MemberType NoteProperty -Name Repository -Value $null
$wbobject | Add-Member -MemberType NoteProperty -Name Permissions -Value $null



for ($i = 2; $i -le $maxrows; $i++)
    {
	    $wbobject.Team = $worksheet.Cells.item($i,1).Text.ToLower();
	    $wbobject.Repository = $worksheet.Cells.item($i,2).Text.ToLower();
	    $wbobject.Permissions = $worksheet.Cells.item($i,3).Text.ToLower();

	    $repo = $wbobject.Repository
	    $team = $wbobject.Team
	    $repopermission = $wbobject.Permissions

	    $repoparams=@{

           permission=$repopermission

           }

	    $newteamname = $team -replace ' ','-'
    
	    $body=$repoparams | ConvertTo-Json


		$teamsaccesstoreposrequest=@{

			    Uri = "https://api.github.com/orgs/$Organization/teams/$newteamname/repos/$Organization/$repo" 
			    Method = "PUT"
			    body = $body 
			    ContentType = "application/json"
			    Headers = $head

		    }	 
   
     try {

		    $gitObject= Invoke-RestMethod @teamsaccesstoreposrequest

		    $repo_newname= $repo.ToUpper()
		    $team_newname= $team.ToUpper()

		    Write-Host
		    Write-Host "$team_newname Team has been given $repopermission permissions to $repo_newname"

        } catch{
	
		 Write-Host "Error:" $_.Exception.Response.StatusDescription  -ForegroundColor Red
	
	}

}