SSIS deploy ISPAC With Environment

To use this template in Octopus Deploy, copy the JSON below and paste it into the Library → Step templates → Import dialog.

{
  "Id": "b791c0c2-03ce-40ef-9446-78beb585c0b8",
  "Name": "SSIS deploy ISPAC With Environment",
  "Description": "A Template which will deploy any .ISPAC files from the published package step selected to the SQL Server catalog database. \n\nThe template will create a environment config and use variables that are wrapped in SSIS[<SSIS Parameter Path>] extracting the SSIS Parameter Path using that as the name and value linked the Octopus Variable and then assign parameter in the SSIS project to the name environment configuration.  \n\nWhen the SSIS Parameter Path is at the Package level then SSIS Parameter will need to have the Package Name (without .dtsx) added to front of the SSIS Parameter path.\n\nTo remove and environment config delete the variable or remove the SSIS[].\n",
  "Version": 18,
  "ExportedAt": "2019-10-29T18:58:17.799Z",
  "ActionType": "Octopus.Script",
  "Author": "Zogamorph",
  "Packages": [],
  "Parameters": [
    {
      "Id": "4d49a1f7-f7bf-40e2-b845-8c9c8e4deda9",
      "Name": "NugetPackageStepName",
      "Label": "NuGet package step",
      "HelpText": "The step that uploaded the NuGet package to the server.",
      "DefaultValue": "",
      "DisplaySettings": {
        "Octopus.ControlType": "StepName"
      }
    },
    {
      "Id": "6e97bd67-aeb5-4a92-b4d8-9e5b9a13ad93",
      "Name": "ServerName",
      "Label": "SSIS SQL Server Name",
      "HelpText": "The name of SSIS SQL Server ",
      "DefaultValue": "",
      "DisplaySettings": {
        "Octopus.ControlType": "SingleLineText"
      }
    },
    {
      "Id": "6b0007eb-81eb-459f-b8c6-2f8c9465beb2",
      "Name": "CatalogName",
      "Label": "SSISDB Catlog Name",
      "HelpText": "The name of the SSISDB Catlog",
      "DefaultValue": "SSISDB",
      "DisplaySettings": {
        "Octopus.ControlType": "SingleLineText"
      }
    },
    {
      "Id": "00cadc4e-17bd-41bb-b4bd-87ca01b483eb",
      "Name": "FolderName",
      "Label": "SSIS Folder",
      "HelpText": "The SSIS folder to deploy to project to",
      "DefaultValue": "",
      "DisplaySettings": {
        "Octopus.ControlType": "SingleLineText"
      }
    },
    {
      "Id": "5e88fe40-d502-4e2e-8c96-c7ed8f2d82c4",
      "Name": "EnvironmentTag",
      "Label": "Environment Tag",
      "HelpText": "The text to add at the end Environment configuration name.  Currently default to append the Environment Value begin deploy to.",
      "DefaultValue": "#{Octopus.Environment.Name}",
      "DisplaySettings": {
        "Octopus.ControlType": "SingleLineText"
      }
    }
  ],
  "Properties": {
    "Octopus.Action.Script.ScriptSource": "Inline",
    "Octopus.Action.Script.Syntax": "PowerShell",
    "Octopus.Action.Script.ScriptBody": "# Define PowerShell Modules path\n$LocalModules = (New-Item \"$PSScriptRoot\\Modules\" -ItemType Directory -Force).FullName\n$env:PSModulePath = \"$LocalModules;$env:PSModulePath\"\n\n#region Functions\n\n#region SQLPS functions \nfunction Get-NugetPackageProviderNotInstalled {\n    # See if the nuget package provider has been installed\n    return ($null -eq (Get-PackageProvider -ListAvailable -Name Nuget -ErrorAction SilentlyContinue))\n}\n\nfunction Get-SqlModuleInstalled {\n    # Define parameters\n    param(\n        $PowerShellModuleName\n    )\n\n    # Check to see if the module is installed\n    if ($null -ne (Get-Module -ListAvailable -Name $PowerShellModuleName)) {\n        # It is installed\n        return $true\n    }\n    else {\n        # Module not installed\n        return $false\n    }\n}\n\nfunction Install-SqlServerPowerShellModule {\n    # Define parameters\n    param(\n        $PowerShellModuleName,\n        $LocalModulesPath\n    )\n\n    # Check to see if the package provider has been installed\n    if ((Get-NugetPackageProviderNotInstalled) -ne $false) {\n        # Display that we need the nuget package provider\n        Write-Host \"Nuget package provider not found, installing ...\"\n        \n        # Install Nuget package provider\n        Install-PackageProvider -Name Nuget -Force\n    }\n\n    # Save the module in the temporary location\n    Save-Module -Name $PowerShellModuleName -Path $LocalModulesPath -Force\n\n    # Display\n    Write-Output \"Importing module $PowerShellModuleName ...\"\n\n    # Import the module\n    Import-Module -Name $PowerShellModuleName\n}\n\nFunction Get-SqlServerAssmblies {\n    # Declare parameters\n    \n    # Get the folder where the SqlServer module ended up in\n    $sqlServerModulePath = [System.IO.Path]::GetDirectoryName((Get-Module -ListAvailable -Name \"SqlServer\").Path)\n    \n    # Loop through the assemblies\n    foreach ($assemblyFile in (Get-ChildItem -Path $sqlServerModulePath -Exclude msv*.dll | Where-Object { $_.Extension -eq \".dll\" })) {\n        # Load the assembly\n        [Reflection.Assembly]::LoadFile($assemblyFile.FullName) | Out-Null\n    }    \n}\n\n#endregion SQLPS functions \n\n#region SQL Server functions \nfunction Get-ConnectionObject {\n    param\n    (\n        [parameter(ParameterSetName = 'Default', HelpMessage = 'Name of the server', Mandatory = $true)]\n        [parameter(ParameterSetName = 'SQLAuth', HelpMessage = 'Name of the server', Mandatory = $true)]\n        [string]\n        $SQLServerName,\n        [parameter(ParameterSetName = 'SQLAuth')]\n        [switch] $UseSQLAuth,\n        [parameter(ParameterSetName = 'SQLAuth', HelpMessage = 'SQL Server Login', Mandatory = $true)]\n        [string] $SQLLogin,\n        [parameter(ParameterSetName = 'SQLAuth', HelpMessage = 'SQL Server Password', Mandatory = $true)]\n        [string] $Password\n          \n    ) \n    # Create a connection to the server\n    $sqlConnectionString = \"Data Source=$ServerName;Initial Catalog=SSISDB;\"\n    \n    if ($UseSQLAuth) {\n        # Add username and password to connection string\n        $sqlConnectionString += \"User ID=$SQLLogin; Password=$Password;\"\n    }\n    else {\n        # Use integrated\n        $sqlConnectionString += \"Integrated Security=SSPI;\"\n    }\n     \n    # Create new connection object with connection string\n    return (New-Object System.Data.SqlClient.SqlConnection $sqlConnectionString)\n}\n#endregion SQL Server functions \n\n#region SQL SSIS functions\nFunction Get-Catalog {\n    # define parameters\n    Param ($CatalogName)\n    \n    # define working varaibles\n    $Catalog = $null\n    # check to see if there are any catalogs\n    if ($integrationServices.Catalogs.Count -eq 0 -or -not $integrationServices.Catalogs[$CatalogName]) {\n        throw \"SSIS Catalog not found $CatalogName\"\n        # get reference to catalog\n    }\n\n    $Catalog = $integrationServices.Catalogs[$CatalogName]\n    \n    # return the catalog\n    return $Catalog\n}\n\nFunction Get-Folder {\n    # parameters\n    Param($FolderName, $Catalog)\n    \n    $Folder = $null\n    # try to get reference to folder\n    \n    if (!($null -eq $Catalog.Folders)) {\n        $Folder = $Catalog.Folders[$FolderName]\n    }\n    \n    # check to see if $Folder has a value\n    if ($null -eq $Folder) {\n        # display\n        Write-Host \"Folder $FolderName doesn't exist, creating folder...\"\n    \n        # create the folder\n        $Folder = New-Object \"$ISNamespace.CatalogFolder\" ($Catalog, $FolderName, $FolderName) \n        $Folder.Create() \n    }\n    \n    # return the folde reference\n    return $Folder\n}\n\nFunction Get-Environment {\n    # define parameters\n    Param($Folder, $EnvironmentName)\n    \n    $Environment = $null\n    # get reference to Environment\n    if (!($null -eq $Folder.Environments) -and $Folder.Environments.Count -gt 0) {\n        $Environment = $Folder.Environments[$EnvironmentName]\n    }\n    \n    # check to see if it's a null reference\n    if ($null -eq $Environment) {\n        # display\n        Write-Host \"Environment $EnvironmentName doesn't exist, creating environment...\"\n    \n        # create environment\n        $Environment = New-Object \"$ISNamespace.EnvironmentInfo\" ($Folder, $EnvironmentName, $EnvironmentName)\n        $Environment.Create() \n    }\n    \n    # return the environment\n    return $Environment\n}\nFunction Set-PojectEnvironmentReference {\n    # define parameters\n    Param($Project, $Environment, $Folder)\n    \n    # get reference\n    $Reference = $null\n    \n    if (!($null -eq $Project.References)) {\n        $Reference = $Project.References[$Environment.Name, $Folder.Name]\n    \n    }\n\n    # check to see if it's a null reference\n    if ($null -eq $Reference) {\n        # display\n        Write-Host \"Removeing old Project reference environment creating reference...\"\n        foreach ( $Reference in  $Project.References) {\n            $Project.References.Remove($Reference.Name, $Reference.EnvironmentFolderName)\n        }\n        Write-Host \"Project does not reference environment $($Environment.Name), creating reference...\"\n        # create reference\n        $Project.References.Add($Environment.Name, $Folder.Name)\n        $Project.Alter() \n    }\n}\n\nFunction Add-EnvironmentVariable {\n    # define parameters\n    Param($Environment, $Parameter, $ParameterName, $EnvironmentValue )\n    \n    # display \n    Write-Host \"- Adding environment variable $($ParameterName)\"\n        \n    # add variable with an initial value\n    $Environment.Variables.Add($ParameterName, $Parameter.DataType, $EnvironmentValue, $Parameter.Sensitive, $Parameter.Description)\n    $Parameter.Set([Microsoft.SqlServer.Management.IntegrationServices.ParameterInfo+ParameterValueType]::Referenced, $ParameterName)\n}\n\nFunction Remove-ReferencedValue {\n    Param($Project\n        , $ParameterName\n    )\n  \n    if ($ParameterName -match \"\\|\") {\n        $ParameterPath = $ParameterName.Split(\"|\")\n        $Project.Packages[$ParameterPath[0]].Parameters[$ParameterPath[1]].Clear()\n        $Project.Packages[$ParameterPath[0]].Alter()\n    }\n    else {\n        $Project.Parameters[$ParameterName].Clear()  \n    }\n}\n\nFunction Sync-EnvironmentVariables {\n    # define parameters\n    Param($Environment\n        , $Project\n        , $ReferencedVariables\n        , $OctopusParameters\n        , $OctopusSSISParameterKey )\n\n    foreach ($VariableToEvaluate in $Environment.Variables) {\n        $OctopusParameterKey = $OctopusSSISParameterKey -f $VariableToEvaluate.Name\n`       if (-not $OctopusParameters.Keys.Contains($OctopusParameterKey)) {\n            Write-Host \"- Removing environment variable: $($VariableToEvaluate.Name)\"    \n            $Environment.Variables.Remove($VariableToEvaluate) | Out-Null\n            if ($ReferencedVariables.Keys.Contains($VariableToEvaluate.Name)) {\n                Remove-ReferencedValue -Project $Project -ParameterName $ReferencedVariables[$VariableToEvaluate.Name]\n                $ReferencedVariables.Remove($VariableToEvaluate.Name)\n            }\n        }\n    }\n\n    foreach ($ReferencedKeyName in $ReferencedVariables.Keys) {\n`       if (-not $Environment.Variables.Contains($ReferencedKeyName)) {\n            Write-Host \"- Removing Prodect referenace  $($ReferencedVariables[$ReferencedKeyName] -replace \"\\|\", \" \")\"\n            Remove-ReferencedValue -Project $Project -ParameterName $ReferencedVariables[$ReferencedKeyName] \n        }\n    }\n\n    $Project.Alter()\n    # alter the environment\n    $Environment.Alter()\n}\n\nFunction Set-ProjectParametersToEnvironmentVariablesReference {\n    # define parameters\n    Param($Project\n        , $Environment\n        , $OctopusParameters\n        , $OctopusSSISParameterKey\n    )\n    \n    $ReferencedVariables = @{ }\n\n    if ($null -eq $Project.Parameters) {\n        Write-Host \"No project parameters exist\"\n        return\n    }\n\n    # loop through project parameters\n    foreach ($Parameter in $Project.Parameters) {\n        $OctopusParameterKey = $OctopusSSISParameterKey -f $Parameter.Name\n        # Add variable to list of variable\n        if ($OctopusParameters.Keys.Contains($OctopusParameterKey)) {\n            Write-Host $(\"Updating Project / Environment {0} Parameter Value ...\" -f $Parameter.Name)\n            $EnvironmentValue = $OctopusParameters[$OctopusParameterKey]\n            $Variable = $null\n            if (!($null -eq $Environment.Variables)) {\n                # get reference to variable\n                $Variable = $Environment.Variables[$Parameter.Name]\n            }\n            # check to see if variable exists\n            if ($null -eq $Variable) {\n                # add the environment variable\n                Add-EnvironmentVariable -Environment $Environment -Parameter $Parameter -ParameterName $Parameter.Name -EnvironmentValue $EnvironmentValue            \n            }\n            else {\n                $Variable.value = $EnvironmentValue\n            }            \n        }\n        if ($Parameter.ValueType -eq [Microsoft.SqlServer.Management.IntegrationServices.ParameterInfo+ParameterValueType]::Referenced) {\n            $ReferencedVariables.Add($Parameter.ReferencedVariableName, $Parameter.Name)\n        }\n    }\n    \n    # alter the environment\n    $Environment.Alter()\n    $Project.Alter()\n    return $ReferencedVariables\n}\n\nFunction Set-PackageVariablesToEnvironmentVariablesReference {\n    # define parameters\n    Param($Project\n        , $Environment        \n        , $OctopusParameters\n        , $OctopusSSISParameterKey)\n\n    $ReferencedVariables = @{ }\n\n    # loop through packages in project\n    foreach ($Package in $Project.Packages) {\n        # loop through parameters of package\n        foreach ($Parameter in $Package.Parameters) {\n            \n            $ParameterName = $Parameter.ObjectName.Replace(\".dtsx\", \"\") + \".\" + $Parameter.Name\n            $OctopusParameterKey = $OctopusSSISParameterKey -f $ParameterName\n        \n            # Add variable to list of variable\n            if ($OctopusParameters.Keys.Contains($OctopusParameterKey)) {\n                Write-Host $(\"Updating {0} Package / Environment {1} Parameter Value ...\" -f $Parameter.ObjectName, $ParameterName)\n                $EnvironmentValue = $OctopusParameters[$OctopusParameterKey]\n                $Variable = $null\n                if (!($null -eq $Environment.Variables)) {\n                    # get reference to variable\n                    $Variable = $Environment.Variables[$ParameterName]\n                }\n                # check to see if the parameter exists\n                if (!$Variable) {\n                    # add the environment variable\n                    Add-EnvironmentVariable -Environment $Environment -Parameter $Parameter -ParameterName $ParameterName -EnvironmentValue $EnvironmentValue\n                }          \n                else {\n                    $Variable.value = $EnvironmentValue\n                }            \n            }\n            if ($Parameter.ValueType -eq [Microsoft.SqlServer.Management.IntegrationServices.ParameterInfo+ParameterValueType]::Referenced) {\n                $ReferencedVariables.Add($Parameter.ReferencedVariableName, $(\"{0}|{1}\" -f $Package.Name, $Parameter.Name))\n            }  \n        }\n    \n        # alter the package\n        $Package.Alter()\n    }\n    \n    # alter the environment\n    $Environment.Alter()\n\n    return $ReferencedVariables\n}\n\n#endregion SQL SSIS functions\n\n#endregion Functions\n\n#region Script Main\n\n#region Get enviroment configured\nif ((Get-SqlModuleInstalled -PowerShellModuleName \"SqlServer\") -ne $true) {\n    # Display message\n    Write-Output \"PowerShell module SqlServer not present, downloading temporary copy ...\"\n    \n    # Download and install temporary copy\n    Install-SqlServerPowerShellModule -PowerShellModuleName \"SqlServer\" -LocalModulesPath $LocalModules\n}\n\n# Dependent assemblies\nGet-SqlServerAssmblies    \n\n\n# add snapins-- applies to sql server 2008 r2, newer version of SQL do not require this.\nAdd-PSSnapin SqlServerCmdletSnapin100 -ErrorAction SilentlyContinue\nAdd-PSSnapin SqlServerProviderSnapin100 -ErrorAction SilentlyContinue\n#endregion Get enviroment configured\n\n\n$ISNamespace = \"Microsoft.SqlServer.Management.IntegrationServices\"\n$OctopusSSISParameterKey = \"SSIS[{0}]\"\n$DeployedPath = $OctopusParameters[\"Octopus.Action[$NugetPackageStepName].Output.Package.InstallationDirectoryPath\"]\n\nWrite-Host \"Connecting to server ...\"\n\nif ([string]::IsNullOrEmpty($sqlAccountUsername) -and [string]::IsNullOrEmpty($sqlAccountPassword)) {\n    # Add username and password to connection string\n    $sqlConnection = Get-ConnectionObject -SQLServerName $ServerName \n}\nelse {\n    # Use integrated\n    $sqlConnection = Get-ConnectionObject -SQLServerName $ServerName -UseSQLAuth -SQLLogin $sqlAccountUsername -Password=$sqlAccountPassword\n}\n\n$integrationServices = New-Object \"$ISNamespace.IntegrationServices\" $sqlConnection\n\n\n$IsPacFiles = Get-ChildItem -Recurse -Path $DeployedPath | Where-Object { $_.Extension.ToLower() -eq \".ispac\" }\nWrite-Host \"$($IsPacFiles.Count) .ispac file(s) found.\"\n\n# get reference to the catalog\nWrite-Host \"Getting reference to catalog $CatalogName\"\n$Catalog = Get-Catalog -CatalogName $CatalogName\n$Folder = Get-Folder -FolderName $FolderName -Catalog $Catalog\n\n$ReferencedVariables = @{ }\nforeach ($IsPacFile in $IsPacFiles) {\n    $ProjectFile = [System.IO.File]::ReadAllBytes($IsPacFile.FullName)\n    $ProjectName = $IsPacFile.Name -replace $IsPacFile.Extension , \"\"\n    $EnvironmentName = \"{0}_{1}\" -f $ProjectName , $EnvironmentTag\n    # deploy project\n    Write-Host \"Deploying project $($IsPacFile.Name)...\"\n    $Folder.DeployProject($ProjectName, $ProjectFile) | Out-Null\n\n    # get reference to deployed project\n    $Project = $Folder.Projects[$ProjectName]\n    # get environment reference\n    $Environment = Get-Environment -Folder $Folder -EnvironmentName $EnvironmentName \n    Set-PojectEnvironmentReference -Project $Project -Environment $Environment -Folder $Folder \n    Write-Host \"Referencing Project Parameters to Environment Variables...\"\n    $ReferencedVariables += Set-ProjectParametersToEnvironmentVariablesReference -Project $Project -Environment $Environment -OctopusParameters $OctopusParameters -OctopusSSISParameterKey $OctopusSSISParameterKey\n    Write-Host \"Referencing Project Parameters to Environment Variables...\"\n    $ReferencedVariables += Set-PackageVariablesToEnvironmentVariablesReference -Project $Project -Environment $Environment -OctopusParameters $OctopusParameters -OctopusSSISParameterKey $OctopusSSISParameterKey\n    Write-Host \"Sync package environment variables...\"\n    Sync-EnvironmentVariables -Environment $Environment -Project $Project -ReferencedVariables $ReferencedVariables -OctopusParameters $OctopusParameters -OctopusSSISParameterKey $OctopusSSISParameterKey\n}   "
  },
  "Category": "SQL Server",
  "HistoryUrl": "https://github.com/OctopusDeploy/Library/commits/master/step-templates//opt/buildagent/work/75443764cd38076d/step-templates/ssis-deploy-ispac-with-enviroment.json",
  "Website": "/step-templates/b791c0c2-03ce-40ef-9446-78beb585c0b8",
  "Logo": "iVBORw0KGgoAAAANSUhEUgAAAMgAAADICAMAAACahl6sAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAD9QTFRFlZ+r3DAr6p+dy8/V4G9t////5efp9M7NrLS+wCYm8/T1vcPK1tnd10xK+fn6/PLyUU5O+eXk3+Hk7O3u7/DxS2XoPwAADb9JREFUeNrsnYl6nbgOgMEYDHghGN7/Wa8k70B6s3AOZD5o2umcSaf+0S4bUbX/kat6QB6QB+QBeUAekAfkAXlAHpAH5AF5QB6QB+QBeUAekAckXMv4XwBZVCPVnwcZlZSNXRrzp0HGTkqplrY1zfKHQboGMZwoGvVXQUbVy152QaPUu3XrJJCl6Xsp1/SBfbdunQJiZd/3zVqqmfprIEb1iLHRpLF5s279FsQ0iCH3etQ03R8CQYyq74/MwTbN3wGxQFGRRJTaJiVL815z/wXIIiviQEunq2lsNyZhvdfcfw6iCMPavl9H20jkgV8gP1F2NRRJmvEvgIA4gAS0B8xkpexEYWB3F0ijAyOxfwAkcsBvHQk53QWW71HwGm8PIhJHazIS98HYdUqBar1TJD8EYQOABGNe+w0J0dj3iuSHIOMw6PRHOyDpdhggE2XvDmLYAChsDh4MSPI1g92DWkGaosbbey0kARbOyFCaTCYgDemioQWp3D+O9EO4NGNCRpIFMKQzjlG9TyS/iOwoE64jjeaVwICOzjeoGfgue38QshPRMV57lhpVjbNemZTMK7X+gaQRSRgQzaz2JDX9CjRiDvWV+gMgRniSltWMMV0TSo1fcIEjEAKUa7k/CDiomkjaeeAU8JEmoRAOuoLp/hWidTJp9RBiipkF07our9fj/Lpmn51MeM2TnAx5gnp/cRZj6P2aD6BdWoBu1QUeiESwWoCu8a10OBfzHUFaATIxoFssfjIxUKbZiJobkg/ibFSNny2aM/pa4Lt0y4eoWwJkQP9S11NQNoOmw18Ic0qDDsIIg59TiC517aTDa5a7OBDPLDjRBMemmbgTCIhjEINbNVpHLXzozzxAhI4mg9ETv7i4DwhYiHa6JfA2T9F6dPltaDwgBQifwgG5ZOAMlpNAZlrShEpW8ykG/mgkCaMmX40LXwX3uUBR21wLgoYxoMOtc22agpJlGBM5AYF5pcFUwOkXXr8Ty2n7IxrWgze4sIo6WrvD4LNx6pc8QDtzHVA0uwGIcJ6otO4IQhahfZLCtqYjYiUwsOlqEMMp8S31w4MIHrUKv1PvnZlhsUJjF4NAWHQ5PCRUIoGA5XutEpMJsquPFjvzX6GcB2I0Ybg45wWDpi/Iz7K07QPiOfZQEwtls7gShCL6kGe6U4tBg8Bmk7syfSjRpF0glOVCEDT3Mp0KQZyV+cxeswKEjur1baGcuc8O66bQsM10C0Wa6jy4oG2E7gXkXeAxdOdhmLkMBPxWSLJyFj5vBKJLURAGJ58m0NKNcuLh01UgLLvXU87CWSEQVlDUSOHu/gQp2xgaTSAidRFISICjl83UiyVYl3/NIdHiKQZy73pNEIq4BqTNzZht2w8sCISjXWjnqYtcEZtLwTBM9c2Qci5I+ouDYs2sQMGPZxH+Y5kGiFIE6nskp4LwEPcmTpaBd99MqZTiLHPK2wwRDAQq5sxVjeS+enMBSGhAzMRhQsTIUOK1Lz9w2cWHZqy+YSevkMiknWvSMRfZoGg2mX1ecBA6yHupCyRCEqDkasaqMYsYc/LGRwWUmdHd7j4dG/x4ukIiE3HQ382KVDF546NAN9XHSmQsWo65wkbmuFSdxcdCtQ7yKP2ZgzLdx9dc19kSEbFqF0mzdsYuDgydf/I/RW8m324jPGUgPPgsoTPz0Af5MNn0p5ZgZpDJ9F6QfI2ztxQf/TT3DS+2J8Hm8b/sYAJxmXeCzJukikdnpcUUG5BeKKzQnfpf0UJUX4gmpyaNdVoQJlWzYSGGG9I5Fz0mXtoJGEh9sPc70ZZErBrN+0AMyyTCkkEwr1BJe1hOwnfysEiQyl5dMWneqlp8iGGCstyI4YLIVKT4gwfDJmvMTHDrIUP44FWz4JbEe93vnIUJXlSHyUDi92rnps1c+/LcgBiG7OIghqu6KHHXYxZlMsLLfpAzlAGTfjB0ICzlgLq0jqO5rGbnIAudtU+KqpAfKiI25XghCM3cuYlvn34+D2Qil5rqKDZlWRY/BA97CkM4aWRb89Pz2+eBsIHMedab1smks62fogs0+JMSDmL+3RH080B8a9qDCJMVvXrehgiu6yiP+pRN0epEgQi3SeUkkgeXXUOuDmdWBn7Wbuh5Gz2U67JtgsvqomUdtw4RQnNx3hMNJ269QS2iXRN7DrmUmXXGIYr+48knBqoTLUR4xztTXzRU73OgSPvSmov27OscELCEQWBgQM1hrjqc2tR+EPx1ojgVZMJTc+hzQzXl2sCc0pVMFkDRLa85iHbWyQe0Xoau1rkrg0AMk5VU5pJCmeXOILR9CMGCJ7cL5TuDJCVReDe7Aoi5K8hUUwKYc4A0MoXCLRy/+vHOIKBYPnXnbVk7BY1KS78zCKPNJShmY/9pjo0ToJjW/PErtJHxniCCjjtAxMBds9LXcrYCIZjFau4PAqURxwg+bDvvuJ/WdeiiEGW8PYge9GSEL7yjMNxOlLGd87XjGi3jriC4k4tHY8H5Gn94GUtc56QiCBn5eGcQMHRB9epEe2yDE0boe4y2i0f8jUcBkPV2IHg2nmHDkwk+uAqD573Q1dps0WAqYPTLi0L7r0CAAXs4NR3vxy8mi+fDAKRQI0AZ7wgyD7j8AQ/O0bMjrDFL8cjeYu0m+KEDux2IyLo4qFM0Q6R4GKnbgbQ3BDE6UdRsXpxWdblIrN00p0fiuBfIpCMGbtIafHwS8UAkYaHG2uLpRHBcKzqvW4GM6Skxhs62a6R7fh0fPgyZripARnK8NwOJ8gh9UXz00K0fn5p2v1uUXXZp771AhN6cc8PZLt4ejFJ+3INV8fm3cQkl7nqngOj9le7jJ8ARAwgqF0HFhxDHDq775Vp0SgGb/308XEEjg5KLbUgmo1Kdx8hSlRuBOHlU2bPfBp8GzSIGPn1o246e3BvBB9usKLwPCHPHqPAx42C1thAIkTQKn80fF6tsNtHiTiB0imelAQlBIluBOJmAVPBRXWXL6QM3ATGYslPhKpNEmq1AnJ04kI2vvQnIxAftXWofQRYUyGZxOJMDOXZjd+4BYnU6mZdApOw3AulwcAWR2O2ib9EOEoNOSSCqFi1f4ViXbL2Lokki3ka2MrkDiKryg5IIgqePRpxRozYUjmQxi9o+Pb1e3/tVVTG1yaJuGZz2IHt/nGoEN9zQbBe1di53NOCEi3p3vbwbX8oD7n1PkzfwH5RljX7iDs7fMDQ5yHrrtrmpLFeDyKraqDbpFk6pkRKsO04NckYBJW8a5bZCpWh9s7HrXpMzfhVEVdX2RtLENhpJJSWNcUKMkBqqppgTBmKBPGVEVeu68UIQ4NjPLwtjtUg08KOx2dCK3eQ2SOQtSAMkciHIUlX9/tMmkRQUXiB7JwtlbpbPXwBiqqra3cZVxUlnSaPCHwCLPzo/jYp1JUi/U6yuwZltNH6uPxh8YuXRHKcRdMsCSHsViK0KjzUqWSWMvt8bj5EHY3LR3MfWdt1yGUiVCQRFUdGXBNWqjklU6KhkOmUpD4Yqq1uvAmkAZHVdBZrXBhQ0CXcBDmcm2y4c+uHCnGxIVJZNlfVWkIpcVgf330HY0e19UIqyODMpyUGzlkwYWb4FkfFFtv7/QSwtP0CYTFCUxq877VpzgWASmWXAdtN7fCdIUKcyUEBo6StSKU9i8s6Q7Lyboiw4a9JhfL8KpE/j/3Lr7WMzyJHEiqTzAjEuoy+cs/Nc14CYqjoK62AxMnnbPqTAVC+iQHBQOUbFctnYUjFXSYQU6yD36vNAntTL0sCzhvL57d03arfP8GaJVJu/fu03xUnn1KtznSGXCO/vPVYmS3uljWx1q/eRJQ/mfr6sT+ibIy+LFZZpr/VayyZE7lPCzk2XpQmznwxffulova/FkUIk3VFxAiWIT+jlZwOL15eOcftSZK+KpR94MaNkVmF9MggQQ7y5EERVpXKBoZfeyNhYmXjVOjYRTFXaC0G8SIKb2lbvnYzlFU2PX7y977TotZr1FZDFk7ipnoWhLzJUJqBO1BmiXpYfxVyuGzdNzKUglMgHmWQRfWloSDmkYW6BaZwppryeJenYi8eBfqn50ESZNMFARuUyYhnbV2qbBVuXpjQuczdF+nhVO6j3JIszENO4MCkzmx59C3VbpvuWtrUvHr/+9QZdcMPGyUJu2gtyN4U5erV1wZHlLx7H/NWWaRNAKK3fh2572IaIFkNiMXcACb4LKI5KCih8q+PH7QxVV0v36pHlX99WMLLaBfmi8D2I5ytOlZYY6ZtXv2rhOztWNghlp1gdvpxgr1ApnR9f/qaFb+0hRqFsh6tjMNmJIo+J9uWvI/nm9vQaUfIb3JQG0imXz2fRsHn5C2K+e2DArH1QsNhvGKuUR462OWhsr/Llbyf4yaEaGR2Yu83gsVaftLgMUtqN4b/hFR4/O69lk1iUsVTTG+VFofbbz+YN73776VFAH99dG1Iu7l09Uh1bdCdf/wqlXxyXHRML5sD/GBD/jpfx/fJsvOttu589vnXv2KhAIBgYQQNfNg//hBdyQcio+vCjxxpks1gLApmqj+rjox0/5G1BgteVfbaPhTjR6Okwl/kAFtl/9PcGyWqpPutEYFW1dM5CAARkcneJlDwLlVP+dVDhMNdHW8mP45TzriBZ7k+Xi4W9kbMS0v5JkDdeD8gD8oA8IA/IA/KAPCAPyAPygDwgD8gD8oA8IA/IA/IXr/8JMAAhf0RDrOWy2QAAAABJRU5ErkJggg==",
  "$Meta": {
    "Type": "ActionTemplate"
  }
}

History