Data Mapping Guide: Azure to Jira Assets

Owned by Martin Fischer
Dec 19, 2024
6 min read

JSON representation of the syncing data

Note: How to get the JSON resource representation? The easiest way to do this is by:

  • Opening the Azure UI

  • Clicking on the resource you want to sync

  • Finding the JSON view button (usually on the right side of the screen)

  • Reviewing the JSON, where you can see all the details about the resource

  • From this JSON, we can point out the specific values of attributes

Resource Type: Location

  • API Endpoint: subscriptions/${subscriptionId}/locations?api-version=2021-04-01

  • Attributes Synced:

    • value[0].name → Name

    • value[0].displayName → Display Name

    • value[0].id → Id

  • Example:

Resource Type: Tag

  • API Endpoint: any resource that has a tag set

  • Attributes Synced:

    • tags[0].id → Id

    • tags[0].name → Name

    • tags[0].value → Value

Resource Type: Subscription

  • API Endpoint: /subscriptions?api-version=2021-04-01&$top=100&$skip=0

  • Attributes Synced:

    • value[0].state → State

    • value[0].id → Id

    • value[0].displayName → Display Name

Resource Type: Resource Group

  • API Endpoint: /subscriptions/${subscriptionId}/resourceGroups?api-version=2021-04-01&$top=100&$skip=0`,

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

Resource Type: Virtual Network

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Network/virtualNetworks?api-version=2023-02-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].type → Type

    • value[0].location → Location

    • value[0].tags → Tags

Resource Type: Subnet

  • API Endpoint: (included in Virtual Networks)

  • Attributes Synced:

    • [virtual-Network].properties.subnets[0].name → Name

    • [virtual-Network].properties.subnets[0].id → Id

    • [virtual-Network].properties.subnets[0].properties.addressPrefix → Address Prefix

Resource Type: Network Interface

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Network/networkInterfaces?api-version=2023-11-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].properties.provisioningState → Provisioning State

    • value[0].properties.ipConfigurations.privateIPAddress → Private IP Address

    • value[0].properties.ipConfigurations.publicIPAddress →Public IP Address

    • value[0].properties.macAddress → MAC Address

    • value[0].properties.enableAcceleratedNetworking → Enable Accelerated Networking

    • value[0].properties.networkSecurityGroup.id → Network Security Group Id

    • value[0].tags → Tags

    • value[0].properties.virtualMachine.id → Virtual Machine

    • value[0].properties.ipConfigurations.subnet.id→ Virtual networks

    • value[0].properties.type → Resource Type

Resource Type: Public IP Address

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Network/publicIPAddresses?api-version=2023-02-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].properties.provisioningState → Provisioning State

    • value[0].properties.ipAddress → IP Address

    • value[0].properties.ipAddressVersion → IP Address Version

    • value[0].properties.ipAllocationMethod → IP Allocation Method

    • value[0].properties.idleTimeoutInMinutes → Idle Timeout (Minutes)

    • value[0].sku.name → SKU

    • value[0].type → Resource Type

Resource Type: Azure Firewall

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Network/azureFirewalls?api-version=2023-02-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].properties.provisioningState → Provisioning State

    • value[0].sku.name → SKU

    • value[0].properties.threatIntelMode → Threat Intelligence Mode

    • value[0].properties.ipConfigurations → IP Configurations

    • value[0].properties.publicIpAddress.id → Public IP Address

    • value[0].properties.subnet.id → Subnet

    • value[0].properties.firewallPolicy.id → Firewall Policy Id

    • value[0].type → Resource Type

Resource Type: Load Balancer

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Network/loadBalancers?api-version=2023-02-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].sku.name → SKU

    • value[0].properties.provisioningState → Provisioning State

    • value[0].properties.inboundNatRules → Inbound Nat Rules

    • value[0].properties.loadBalancingRules → Load Balancing Rules

    • value[0].properties.frontendIPConfigurations → Frontend IP Configurations

    • value[0].type → Resource Type

Resource Type: Frontend IP Configuration

  • API Endpoint: (included in load balancers)

  • Attributes Synced:

    • [load-Balancer].properties.frontendIPConfigurations[0].id → Id

    • [load-Balancer].properties.frontendIPConfigurations[0].name → Name

    • [load-Balancer].properties.frontendIPConfigurations[0].properties.privateIPAddress → Private IP Address

    • [load-Balancer].properties.frontendIPConfigurations[0].properties.subnet.id → Subnet

Resource Type: Load Balancing Rule

  • API Endpoint: (included in load balancers)

  • Attributes Synced:

    • [load-Balancer].properties.loadBalancingRules[0].id → Id

    • [load-Balancer].properties.loadBalancingRules[0].name → Name

    • [load-Balancer].properties.loadBalancingRules[0].properties.protocol → Protocol

    • [load-Balancer].properties.loadBalancingRules[0].properties.probe.id → Probe

    • value[0].properties.backendAddressPool.id → Backend Address Pool

    • [load-Balancer].properties.loadBalancingRules[0].properties.frontendPort → Frontend Port

    • [load-Balancer].properties.loadBalancingRules[0].properties.backendPort → Backend Port

Resource Type: Inbound NAT Rule

  • API Endpoint: (included in load balancers)

  • Attributes Synced:

    • [load-Balancer].properties.inboundNatRules[0].id → Id

    • [load-Balancer].properties.inboundNatRules[0].name → Name

    • [load-Balancer].properties.inboundNatRules[0].properties.protocol → Protocol

    • [load-Balancer].properties.inboundNatRules[0].properties.frontendIPConfiguration.id → Frontend IP Configuration

    • [load-Balancer].properties.inboundNatRules[0].properties.backendIPConfiguration.id → Backend IP Configuration

    • [load-Balancer].properties.inboundNatRules[0].properties.frontendPort → Frontend Port

    • [load-Balancer].properties.inboundNatRules[0].properties.backendPort → Backend Port

Resource Type: Private Endpoint

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Network/privateEndpoints?api-version=2024-01-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].properties.provisioningState → Provisioning State

    • value[0].properties.subnet.id → Subnet

    • value[0].type → Resource Type

Resource Type: Virtual Network Gateway

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Network/virtualNetworkGateways?api-version=2024-01-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].properties.ipConfigurations[0]

    • value[0].properties.natRules[0] → NAT Rules

    • value[0].properties.gatewayType → Gateway Type

    • value[0].properties.vpnType → VPN Type

    • value[0].properties.activeActive → Active Active

    • value[0].properties.enableBgp → BGP Enabled

    • value[0].properties.bgpSettings.asn → BGP ASN

    • value[0].properties.bgpSettings.peerWeight → Peer Weight

    • value[0].properties.bgpSettings.bgpPeeringAddress → BGP Peering Address

    • value[0].properties.sku.name → SKU Name

    • value[0].properties.sku.tier → SKU Tier

    • value[0].properties.sku.capacity → SKU Capacity

    • value[0].type → Resource Type

Resource Type: Nat Rule

  • API Endpoint: (included in Virtual Network Gateway)

  • Attributes Synced:

    • [Virtual Network Gateway].properties.natRules[0].id → Id

    • [Virtual Network Gateway].properties.natRules[0].name → Name

    • [Virtual Network Gateway].properties.natRules[0].type → Resource Type

    • [Virtual Network Gateway].properties.natRules[0].properties.ipConfigurationId → IP Configuration ID

    • [Virtual Network Gateway].properties.natRules[0].properties.internalMapping[0].addressSpace → Internal Mappings Address Space

    • [Virtual Network Gateway].properties.natRules[0].properties.internalMapping[0].portRange → Internal Mappings Port Range

    • [Virtual Network Gateway].properties.natRules[0].properties.externalMapping[0].addressSpace → External Mappings Address Space

    • [Virtual Network Gateway].properties.natRules[0].properties.externalMapping[0].portRange → External Mappings Port Range

Resource Type: Ip Configuration

  • API Endpoint: (included in Virtual Network Gateway)

  • Attributes Synced:

    • [Virtual Network Gateway].properties.ipConfigurations[0].id → Id

    • [Virtual Network Gateway].properties.ipConfigurations[0].name → Name

    • [Virtual Network Gateway].properties.ipConfigurations[0].type → Resource Type

    • [Virtual Network Gateway].properties.ipConfigurations[0].properties.provisioningState → Provisioning State

    • [Virtual Network Gateway].properties.ipConfigurations[0].properties.privateIPAllocationMethod → Private IP Allocation Method

    • [Virtual Network Gateway].properties.ipConfigurations[0].properties.publicIPAddress → Public IP Address

    • [Virtual Network Gateway].properties.ipConfigurations[0].properties.subnet → Subnet

Resource Type: DNS Record Set

  • API Endpoint:

    • /subscriptions/${subscriptionId}/providers/Microsoft.Network/dnsZones?api-version=2018-05-01

    • /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Network/dnsZones/{zoneName}/recordsets?api-version=2018-05-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Record Set Name

    • value[0].type → Record Type

    • [zone].name → Zone Name

    • [zone].properties.fqdn → FQDN

Resource Type: Storage Account

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Storage/storageAccounts?api-version=2023-05-01

  • Attributes Synced:

    • value[0].type → Type

    • value[0].properties.sku.tier → SKU Type

    • value[0].properties.statusOfPrimaryPrimary -> Account Status

    • value[0].id → Id

    • value[0].name → Name

    • value[0].kind → Kind

    • value[0].tags → Tags

    • value[0].location → Location

    • value[0].properties.accessTier → Access Tier

    • value[0].properties.primaryEndpoints → End Points

Resource Type: Backup Vault

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.DataProtection/BackupVaults?api-version=2024-04-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].properties.provisioningState → Provisioning State

    • value[0].properties.storageSettings[0].datastoreType → Datastore Type

    • value[0].properties.storageSettings[0].type → Storage Type

    • value[0].properties.securitySettings.softDeleteSettings.state → Soft Delete State

    • value[0].properties.securitySettings.softDeleteSettings.retentionDurationInDays → Retention Duration In Days

    • value[0].properties.secureScoreSecure Score

    • value[0].properties.bcdrSecurityLevel → BCDR Security Level

    • value[0].type → Resource Type

Resource Type: User

  • API Endpoint: v1.0/users/? (graph, Entra Id)

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].userType → Type

    • value[0].accountEnabled → Account enabled

    • value[0].firstName → First name

    • value[0].lastName → Last name

    • value[0].principalName → Principal Name

    • value[0].givenName → Given Name

    • ….

Resource Type: Group

  • API Endpoint: v1.0/groups/? (graph, Entra Id)

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

Resource Types: Computer Vision, Text Analytics, Speech Service, Azure Open Ai

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.CognitiveServices/accounts?api-version=2023-10-01-preview

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].type → Resource Type

    • value[0].tags → Tags

    • value[0].location → Location

    • value[0].properties.endpoint → Endpoint

Resource Type: Communication Service

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Communication/communicationServices?api-version=2023-03-31

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].type → Resource Type

    • value[0].tags → Tags

    • value[0].location → Location

    • value[0].properties.provisioningState → Provisioning State

    • value[0].properties.hostName → Host Name

    • value[0].properties.immutableResourceId → Immutable Resource Id

    • value[0].properties.dataLocation → Data Location

    • value[0].type → Resource Type

Resource Type: Virtual Machines

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Compute/virtualMachines?api-version=2024-03-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].type → Resource Type

    • value[0].tags → Tags

    • value[0].location → Location

    • value[0].properties.dataDisks → Data Disks

    • value[0].properties.storageProfile.osDisk.manageDisk.id → OS Disk

Resource Type: Disk

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Compute/disks?api-version=2023-10-02

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].type → Resource Type

    • value[0].tags → Tags

    • value[0].location → Location

    • value[0].sku.tier → Pricing Tiers

    • value[0].properties.osType → OS Type

    • value[0].properties.diskSizeGB → Disk size GB

    • value[0]properties.diskIOPSReadWriteDisk → IOPS Read Write

    • value[0]properties.diskMBPSReadWriteDisk → Disk MBPS Read Write

Resource Type: Database Server

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.sql/servers?api-version=2023-08-01-preview

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].properties.administratorLogin → Administrator Login

    • value[0].properties.version → Version

    • value[0].properties.state → State

    • value[0].properties.fullyQualifiedDomainName → Fully Qualified Domain Name

    • value[0].properties.minimalTlsVersion → Minimal TLS Version

    • value[0].properties.publicNetworkAccess → Public Network Access

    • value[0].properties.administratorType → Administrator Type

    • value[0].properties.principalType → Principal Type

    • value[0].properties.login → Login

    • value[0].properties.sid → SID

    • value[0].properties.tenantId → Tenant Id

    • value[0].properties.azureADOnlyAuthentication → Azure AD Only Authentication

    • value[0].properties.restrictOutboundNetworkAccess → Restrict Outbound Network Access

    • value[0].properties.externalGovernanceStatus → External Governance Status

    • value[0].type → Resource Type

Resource Type: Database

  • API Endpoint: /resources?api-version=2024-03-01&$filter=(subscriptionId eq '${subscriptionId}') and (resourceType eq 'microsoft.sql/servers/databases')`

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].type → Type

    • value[0].properties.kind → Kind

    • value[0].sku.tier → Pricing Tier

    • value[0].sku.capacity → Capacity

    • value[0].location → Location

    • value[0].tags → Tags

Resource Type: PostgreSQL Server

  • API Endpoint: /subscriptions/${subscriptionId}/providers//Microsoft.DBforPostgreSQL/flexibleServers?api-version=2023-06-01-preview

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].properties.state → State

    • value[0].properties.storageProfile.storageMB → Storage Size (GB)

    • value[0].type → Resource Type

Resource Type: PostgreSQL Database

  • API Endpoint: /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/databases?api-version=2022-12-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].properties.serverName → Postgre Server

Resource Type: MySQL Server

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.DBforMySQL/flexibleServers?api-version=2023-06-01-preview

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].properties.state → State

    • value[0].properties.storageProfile.storageMB → Storage Size (GB)

    • value[0].type → Resource Type

Resource Type: MySQL Database

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.DBforMySQL/flexibleServers/{serverName}/databases?api-version=2022-12-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].properties.serverName → MySQL Server

Resource Type: App Service Plan

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Web/serverFarms?api-version=2023-12-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].type → Resource Type

    • value[0].tags → Tags

    • value[0].location → Location

    • value[0].properties.status → Status

    • value[0].sku.capacity → Capacity

    • value[0].properties.maximumNumberOfWorkers → Max Instances

    • value[0].properties.numberOfSites → Number of Sites

    • value[0].properties.perSiteScaling → Per Site scaling

    • value[0].sku.tier → Pricing Tier

Resource Type: App Service

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Web/sites?api-version=2023-12-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].type → Resource Type

    • value[0].tags → Tags

    • value[0].location → Location

    • value[0].properties.serverFarmId → App Service plan

    • value[0].kind → Operating System

Resource Type: Function App

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.Web/sites?api-version=2023-12-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].type → Resource Type

    • value[0].tags → Tags

    • value[0].location → Location

    • value[0].properties.sku → SKU

    • value[0].properties.state → State

Resource Type: Container Group

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.ContainerInstance/containerGroups?api-version=2023-02-01

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].location → Location

    • value[0].tags → Tags

    • value[0].properties.containers → Container Instances

    • value[0].properties.ipAddress → IP Address

    • value[0].properties.osType → OS Type

Resource Type: Container Instance

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.ContainerInstance/containerGroups/${containerGroupName}/containers?api-version=2023-02-01

  • Attributes Synced:

    • value[0].name → Name

    • value[0].properties.image → Image

    • value[0].properties.volumeMounts → Volume Mounts

    • value[0].properties.ports → Ports

Resource Type: Desktop

  • API Endpoint: /subscriptions/${subscriptionId}/providers/Microsoft.DesktopVirtualization/applicationGroups/?api-version=2022-02-10-preview

  • Attributes Synced:

    • value[0].id → Id

    • value[0].name → Name

    • value[0].resourceGroup → Resource Group

    • value[0].subscriptionId → Subscription