InsertRow.json

InsertRow.json

"Insert_row": {
    "inputs": {
        "body": {
            "HappinessScore": "@{body('CleanGarbage').avg}"
        },
        "host": {
            "api": {
                "runtimeUrl": "https://logic-apis-australiaeast.azure-apim.net/apim/sql"
            },
            "connection": {
                "name": "@parameters('$connections')['sql']['connectionId']"
            }
        },
        "method": "post",
        "path": "/datasets/default/tables/@{encodeURIComponent(encodeURIComponent('[dbo].[Happiness]'))}/items"
    },
    "runAfter": {
        "CleanGarbage": [
            "Succeeded"
        ]
    },
    "type": "ApiConnection"
}