{ "definition": { "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#", "actions": { "For_each": { "actions": { "Condition": { "actions": { "Send_an_email_(V2)": { "inputs": { "body": { "Body": "

@{items('For_each')}

", "Subject": "Health Status Alert Triggered", "To": "leeys2@artc.a-star.edu.sg" }, "host": { "connection": { "name": "@parameters('$connections')['office365']['connectionId']" } }, "method": "post", "path": "/v2/Mail" }, "runAfter": {}, "type": "ApiConnection" } }, "expression": { "and": [ { "less": [ "@floatbody('Parse_JSON')?['healthscore']", 0.75 ] } ] }, "runAfter": { "Parse_JSON": [ "Succeeded" ] }, "type": "If" }, "Parse_JSON": { "inputs": { "content": "@body('Query_documents_V3')?['value']", "schema": { "properties": { "datetime": { "type": "string" }, "healthscore": { "type": "number" }, "turbo_id": { "type": "integer" } } } }, "runAfter": {}, "type": "ParseJson" } }, "foreach": "@body('Query_documents_V3')?['value']", "runAfter": { "Query_documents_V3": [ "Succeeded" ] }, "type": "Foreach" }, "Query_documents_V3": { "inputs": { "host": { "connection": { "name": "@parameters('$connections')['documentdb']['connectionId']" } }, "method": "get", "path": "/v3/dbs/@{encodeURIComponent('aztruconnect')}/colls/@{encodeURIComponent('turbo_health')}/query", "queries": { "maxItemCount": 8, "queryText": "SELECT c.healthscore, c.turbo_id, c.datetime from c" } }, "runAfter": {}, "type": "ApiConnection" } }, "contentVersion": "1.0.0.0", "outputs": {}, "parameters": { "$connections": { "defaultValue": {}, "type": "Object" } }, "triggers": { "Recurrence": { "recurrence": { "frequency": "Minute", "interval": 5 }, "type": "Recurrence" } } }, "parameters": { "$connections": { "value": { "documentdb": { "connectionId": "/subscriptions/xxxxxxxxxxxxxxxxxxx/resourceGroups/xxxxxxxxxxxxxxxxxx/providers/Microsoft.Web/connections/documentdb", "connectionName": "documentdb", "id": "/subscriptions/xxxxxxxxxxxxxxxxx/providers/Microsoft.Web/locations/southeastasia/managedApis/documentdb" }, "office365": { "connectionId": "/subscriptions/xxxxxxxxxxxxxxxxx/resourceGroups/xxxxxxxxxxxxxxxx/providers/Microsoft.Web/connections/office365", "connectionName": "office365", "id": "/subscriptions/xxxxxxxxxxxxxxxxxxxxxxxx/providers/Microsoft.Web/locations/southeastasia/managedApis/office365" } } } } }