json - Azure ADF - 只能使用整数索引选择数组元素

Question

您好，我正在尝试从 Azure 数据工厂中的 Json 数组中选择状态

{
    "dataRead": 2997,
    "dataWritten": 2714,
    "filesWritten": 1,
    "sourcePeakConnections": 1,
    "sinkPeakConnections": 1,
    "rowsRead": 11,
    "rowsCopied": 11,
    "copyDuration": 3,
    "throughput": 0.976,
    "errors": [],
    "effectiveIntegrationRuntime": "DefaultIntegrationRuntime (East US)",
    "usedDataIntegrationUnits": 4,
    "billingReference": {
        "activityType": "DataMovement",
        "billableDuration": [
            {
                "meterType": "AzureIR",
                "duration": 0.06666666666666667,
                "unit": "DIUHours"
            }
        ]
    },
    "usedParallelCopies": 1,
    "executionDetails": [
        {
            "source": {
                "type": "AzureSqlDatabase",
                "region": "East US"
            },
            "sink": {
                "type": "AzureBlobStorage",
                "region": "East US"
            },
            "status": "Succeeded",
            "start": "2020-03-19T06:24:39.0666585Z",
            "duration": 3,
            "usedDataIntegrationUnits": 4,
            "usedParallelCopies": 1,

我尝试选择@activity('将数据从 CCP 复制到 Blob').output.executionDetails.status。它会引发错误:

'Array elements can only be selected using an integer index'.

有什么办法可以解决吗？

Answer 1

executionDetails 是一个数组，您必须设置索引来引用其中的元素。

请尝试:

@activity('Copy data From CCP TO Blob').output.executionDetails[0].status