Is there an azure firewall powershell script to import from CSV or converted json and deploy to Azure NetworkPolicyCollectiongroup. I have used powershell to export to CSV I am adding 10 rule collection which repeats through the rules on the row wherever there are multiple rules belonging to that rule it needs to create 10 rules collection and average of 8-10 rules per collection group I have one github repo which only works for rules in one collection group https://www.cloudcorner.gr/microsoft/azure/azure-firewall-policy-rules-to-csv/ Single collection rule script is not scalable in production. I tried nested loop using excel but that did not work Now I am trying by converting from the excel to json. Is there any resource in that context?

Azure firewall rule

prasantc 836

Is there an azure firewall powershell script to import from CSV or converted json and deploy to Azure NetworkPolicyCollectiongroup.

I have used powershell to export to CSV
I am adding 10 rule collection which repeats through the rules on the row wherever there are multiple rules belonging to that rule
it needs to create 10 rules collection and average of 8-10 rules per collection group
I have one github repo which only works for rules in one collection group https://www.cloudcorner.gr/microsoft/azure/azure-firewall-policy-rules-to-csv/
Single collection rule script is not scalable in production.
I tried nested loop using excel but that did not work
Now I am trying by converting from the excel to json. Is there any resource in that context?

KapilAnanth-MSFT 36,316 Reputation points Microsoft Employee

2024-05-09T09:35:32.95+00:00

@prasantc ,

Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.

I see you are using a 3rd party repository for importing Azure firewall rules from a CSV file to the Azure Firewall.

You can refer to this thread for exporting.

I wouldn't recommend using a CSV file to store Azure Firewall Rules as the Rules data structure is not exactly a table, instead a JSON.

I would suggest you store the rules as JSON either using Get-AzFirewallPolicyRuleCollectionGroup (as a loop) or by using the Export Template option via Portal.

During deployment, you can use ARM Template (JSON) to automate the flow

Cheers,

Kapil
prasantc 836 Reputation points

2024-05-09T15:05:04.46+00:00

Thanks. I have converted excel to JSOn and trying it out
KapilAnanth-MSFT 36,316 Reputation points Microsoft Employee

2024-05-10T05:40:04.3933333+00:00

@prasantc ,

Sure. Please keep us posted on how it goes.