Functions/ImportJson.ps1
|
function Import-Json { <# .Synopsis Import the integration services catalog publish json file .Description Internal function used to import the json file that stores the integration services catalog properties and variables. .Parameter jsonPath File path of json file. .Parameter ispacPath File path of ispac file. .Parameter localVariables Switch to determine whether we need to validate that variables with the name of the variableName exists or not in current session. .Parameter variableType Existence checks for variables can be either for Powershell variables (e.g. $Foo) or Environment variables (e.g. $Env:Foo). Deployment tools store values in different ways. This give some control as to where the variables should be checked. .Example $ssisJson = Import-Json -jsonPath "C:\Users\SQLTraining\Documents\iscPublish.json" -ispacPath "C:\Users\SQLTraining\Documents\iscPublish.ispac" #> param ( [Parameter(Position = 0, mandatory = $true)] [String] $jsonPath, [Parameter(Position = 1, mandatory = $true)] [String] $ispacPath, [Parameter(Position = 2, mandatory = $false)] [Switch] $localVariables, [Parameter(Position = 3, mandatory = $false)] [ValidateSet('Env','PS')] [string] $variableType = 'PS' ) try { Write-Verbose "Importing json..." -Verbose $json = Get-Content -Raw -Path $jsonPath -Encoding UTF8 | ConvertFrom-Json $jsonTested = Test-Json -jsonToTest $json } catch { throw $_.Exception } if (!$localVariables) { try { Write-Verbose ("Testing the {0} PowerShell variables exist to update values in json file... " -f $variableType) -Verbose Test-VariablesForPublishProfile -jsonPsCustomObject $jsonTested -variableType $variableType } catch { throw $_.Exception } } else{ try { Write-Verbose "Testing the environment variables in json file have a value... " -Verbose Test-VariablesForPublishProfile -jsonPsCustomObject $jsonTested -localVariables -variableType $variableType } catch { throw $_.Exception } } return $jsonTested } |