sjwaight

resource connections_keyvault_resource 'Microsoft.Web/connections@2016-06-01' = {
  name: connections_keyvault_name
  location: resource_group_location
  properties: {
    displayName: 'KeyVaultMIAccess'
    parameterValueType: 'Alternative'
    alternativeParameterValues: {
      vaultName: key_vault_name
    }
    customParameterValues: {}

sjwaight

parameters: {
      '$connections': {
        value: {
          keyvault: {
            connectionId: connections_keyvault_resource.id
            connectionName: 'keyvault'
            connectionProperties: {
              authentication: {
                type: 'ManagedServiceIdentity'
              }

sjwaight

resource key_vault_resource 'Microsoft.KeyVault/vaults@2022-07-01' = {
  name: key_vault_name
  location: resource_group_location
  properties: {
    sku: {
      family: 'A'
      name: 'standard'
    }
    tenantId: subscription().tenantId
    accessPolicies: [

sjwaight

resource managed_service_identity_kv_resource 'Microsoft.ManagedIdentity/userAssignedIdentities@2018-11-30' = {
  name: managed_identity_name
  location: resource_group_location
}

sjwaight

{
 "Title": "A sample blog post",
 "Summary": "This is a test blog post summary.",
 "Link": "https://blog.siliconvalve.com/"
}

sjwaight

# Install Java 11 SDK using Chocolatey
Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))
choco install openjdk --version 11.0.2.01 -y

choco install intellijidea-community -y

sjwaight

{
    "SensorName": "PurpleAir-XXX",
    "ReadingTime": "2022-08-15T05:26:41+00:00",
    "Latitude": -00.000000,
    "Longitude": 00.000000,
    "PressureMillibars": 993.75,
    "Humidity": 27,
    "Temperature": 22,
    "Pm25ChannelA": 0,
    "Pm25ChannelB": 0,

sjwaight

{
  "models": [{
    "modelId": "e88247b4-ed17-11ec-85a9-xxxxxxxxxxx",
    "createdTime": "2022-06-16T01:59:08Z",
    "lastUpdatedTime": "2022-06-16T02:00:34Z",
    "status": "READY",
    "displayName": "Air Quality",
    "variablesCount": 4
  }],
  "currentCount": 1,

sjwaight

SELECT
    DATETIMEFROMPARTS (DATEPART(year,readtime), DATEPART(month,readtime), DATEPART(day,readtime), DATEPART(hour, readtime), DATEPART(minute, readtime), 30, 0) as 'timestamp', 
    temperature as value
INTO
    [temperaturedatacsv]
FROM
    [rawiotjsondata]

SELECT 
    DATETIMEFROMPARTS (DATEPART(year,readtime), DATEPART(month,readtime), DATEPART(day,readtime), DATEPART(hour, readtime), DATEPART(minute, readtime), 30, 0) as 'timestamp',

sjwaight

# Originally from: https://www.meetup.com/api/guide/#p02-querying-section

query='query($eventId: ID) {
  event(id: $eventId) {
    title
    description
    dateTime
  }
}
'