azure - 如何使用逻辑应用程序将数组值插入表中

问题描述

当收到一个 http 请求时。我需要将数组值插入表中。在我的情况下，数组是需要响应的。

我使用了这些东西：当收到一个 http 请求并且我使用解析 JSON并且我用于每个循环然后在 for-each 中我使用插入实体但它抛出一个错误。如果有人知道如何实施，请告诉我答案。

我使用 RRT 的表达式为：body('Parse_JSON')['ResponseRequired'][0]['ResponseRequiredType']

json模式

{
"$schema": "http://json-schema.org/draft-04/schema#",
"properties": {
    "AssetErrorCode": {
        "type": "string"
    },
    "AssetErrorDesc": {
        "type": "string"
    },
    "AssetId": {
        "type": "integer"
    },
    "CustomerId": {
        "type": "integer"
    },
    "ResponseRequired": {
        "items": [
            {
                "properties": {
                    "ResponseRequiredAdditionalData": {
                        "type": "string"
                    },
                    "ResponseRequiredAddress": {
                        "type": "string"
                    },
                    "ResponseRequiredFrequency": {
                        "type": "string"
                    },
                    "ResponseRequiredType": {
                        "type": "integer"
                    }
                },
                "required": [
                    "ResponseRequiredType",
                    "ResponseRequiredFrequency",
                    "ResponseRequiredAddress",
                    "ResponseRequiredAdditionalData"
                ],
                "type": "object"
            },
            {
                "properties": {
                    "ResponseRequiredAdditionalData": {
                        "type": "string"
                    },
                    "ResponseRequiredAddress": {
                        "type": "string"
                    },
                    "ResponseRequiredFrequency": {
                        "type": "string"
                    },
                    "ResponseRequiredType": {
                        "type": "integer"
                    }
                },
                "required": [
                    "ResponseRequiredType",
                    "ResponseRequiredFrequency",
                    "ResponseRequiredAddress",
                    "ResponseRequiredAdditionalData"
                ],
                "type": "object"
            },
            {
                "properties": {
                    "ResponseRequiredAdditionalData": {
                        "type": "string"
                    },
                    "ResponseRequiredAddress": {
                        "type": "string"
                    },
                    "ResponseRequiredFrequency": {
                        "type": "string"
                    },
                    "ResponseRequiredType": {
                        "type": "integer"
                    }
                },
                "required": [
                    "ResponseRequiredType",
                    "ResponseRequiredFrequency",
                    "ResponseRequiredAddress",
                    "ResponseRequiredAdditionalData"
                ],
                "type": "object"
            }
        ],
        "type": "array"
    },
    "ServiceKey": {
        "type": "string"
    }
},
"required": [
    "CustomerId",
    "ServiceKey",
    "AssetId",
    "AssetErrorCode",
    "AssetErrorDesc",
    "ResponseRequired"
],
"type": "object"

}

标签： azureazure-devopsazure-functionsazure-web-app-serviceazure-logic-apps

azure - 如何使用逻辑应用程序将数组值插入表中

问题描述

解决方案

推荐阅读