Ercenk

using System.Text;
using Azure.Identity;
using Azure.ResourceManager;
using Azure.ResourceManager.Storage;
using Azure.ResourceManager.Storage.Models;
using Azure.Storage.Blobs;
using Azure.Storage.Blobs.Models;

var resourceGroupName = "immutablestorage";

Ercenk

IAzure GetAzureClient()
{

    // az CLI app Id - DO NOT CHANGE THIS
    const string clientId = "04b07795-8ddb-461a-bbee-02f9e1bf7b46";

    // Change those for your specific Azure subscription. 
    // TenantId is the directory id of the account you log in to for access your subscription
    const string tenantId = "......";
    const string subscriptionId = "....";

Ercenk

name: Create a table
description: Creates a table.
host: EXCEL
api_set: {}
script:
  content: |
    $("#create-table").click(() => tryCatch(createTable));

    async function createTable() {
      await Excel.run(async (context) => {

Ercenk

Azure\Get-AzureStorageAccount

Ercenk

AzureResourceManager\Get-AzureStorageAccount

Ercenk

function Get-ScriptDirectory
{
    $Invocation = (Get-Variable MyInvocation -Scope 1).Value
    Split-Path $Invocation.MyCommand.Path
}

# Trick to load in the Azure module
$preference = $ErrorActionPreference
$ErrorActionPreference = "SilentlyContinue"
Get-AzureAccount | Out-Null

Ercenk

Switch-AzureMode AzureResourceManager

Ercenk

# Read the contents
$pathToFile = "d:\somedir\somefile"
$vms = ConvertFrom-Json (Get-Content -Path $pathToFile | Out-String)

$vmsToBeCreated = @()

# Now loop over the objects and build the provisioning congs...

foreach ($vm in $vms)
{

Ercenk

# Filter below can be quite complex, below is an example
$json = ConvertTo-Json (Get-AzureVM | Where-Object {$_.Name -like "pa*" -and $_.ServiceName -notlike "*dr"}) -Depth 10

$outputFile = "d:\somefolder\somefile"
Out-File -FilePath $outputFile -InputObject $json

Ercenk

"outputs": {
  "key1": {
    "value": "value1",
    "type" : "<type-of-value>"
  }
}