Microsoft Azure – Creating JSON Snippet For Policy Initiative Creation using CSV File
Here in this article, we are going to create a custom JSON script by using the data filled in the CSV file for automation.
What we are going to do is first we’ll convert a list of given Policy IDs from CSV to JSON Code Snippet as a prerequisite for creating a custom policy initiative definition for automation.
Implementation:
Follow the below steps to create a JSON snippet for policy initiative creation using a CSV file:
Step 1: Create a new with .csv extension and policies id’s to it and format should look like this. ‘PolicyID’ as Header and Add required Policy Definition Id(s) as Values one after the other.
Step 2: After creating the csv, Login to Azure Portal
Step 3: From Azure Portal Access the cloud shell and select PowerShell
Step 4: Now Upload the created CSV File to cloud shell storage
Open Cloud Shell and Click on Upload/Download files >> Select Upload >> Choose your created CSV file from your local disk and select.
Step 5: Now, create a new PowerShell file with .ps1 extension.
Syntax:
touch <filename>.ps1
code <filename>.ps1
Example:
touch policygen.ps1
Code policygen.ps1
Open the <filename>.ps1 and Copy paste the following code and save the file
$PolicyIDs = Import-CSV .\PolicyID.csv
Write-Output "["
foreach ($PolicyID in $PolicyIDs)
{
Write-Output " {"
Write-Output (" " + " ""policyDefinitionId""" + " : " + """/providers/Microsoft.Authorization/policyDefinitions/" + $Policy.PolicyID + """,")
Write-Output " },"
}
Write-Output "]"
Step 6: Run the <filename>.ps1 file
./<filename>.ps1
Example:
./policygen.ps1
Output:
Step 7: Save console output to a file with .json extension.
./<filename>.ps1 | Out-File ./<filename>.json
Example:
./policygen.ps1 | Out-File ./sample.json
Output:
Now, this sample.json script can be used in CI/CD Pipelines Automation for Created or Updating the Custom Initiative Definitions and Policy Definitions or it can also be used with Azure PowerShell Cmdlets.
