{
        "name": "copypipeline_F0i_Sent_To_Community",
        "properties": {
            "activities": [
                {
                    "name": "lkDeviceList",
                    "type": "Lookup",
                    "dependsOn": [],
                    "policy": {
                        "timeout": "7.00:00:00",
                        "retry": 0,
                        "retryIntervalInSeconds": 30,
                        "secureOutput": false,
                        "secureInput": false
                    },
                    "userProperties": [],
                    "typeProperties": {
                        "source": {
                            "type": "AzureSqlSource",
                            "sqlReaderQuery": "Select deviceserial From [vwDF_GetDeviceInfo]",
                            "queryTimeout": "02:00:00",
                            "partitionOption": "None"
                        },
                        "dataset": {
                            "referenceName": "vwDF_GetDeviceInfo",
                            "type": "DatasetReference"
                        },
                        "firstRowOnly": false
                    }
                },
                {
                    "name": "Set DeviceList Var",
                    "type": "SetVariable",
                    "dependsOn": [
                        {
                            "activity": "lkDeviceList",
                            "dependencyConditions": [
                                "Succeeded"
                            ]
                        }
                    ],
                    "userProperties": [],
                    "typeProperties": {
                        "variableName": "DevList",
                        "value": {
                            "value": "@activity('lkDeviceList').output.value",
                            "type": "Expression"
                        }
                    }
                },
                {
                    "name": "ForEach1",
                    "type": "ForEach",
                    "dependsOn": [
                        {
                            "activity": "Set DeviceList Var",
                            "dependencyConditions": [
                                "Succeeded"
                            ]
                        }
                    ],
                    "userProperties": [],
                    "typeProperties": {
                        "items": {
                            "value": "@activity('lkDeviceList').output",
                            "type": "Expression"
                        },
                        "isSequential": true,
                        "activities": [
                            {
                                "name": "Copy_f0i_copy1",
                                "type": "Copy",
                                "dependsOn": [],
                                "policy": {
                                    "timeout": "7.00:00:00",
                                    "retry": 0,
                                    "retryIntervalInSeconds": 30,
                                    "secureOutput": false,
                                    "secureInput": false
                                },
                                "userProperties": [
                                    {
                                        "name": "Source",
                                        "value": "cdmEnergy"
                                    },
                                    {
                                        "name": "Destination",
                                        "value": "containermax//outCDMEnergy"
                                    }
                                ],
                                "typeProperties": {
                                    "source": {
                                        "type": "AzureTableSource",
                                        "azureTableSourceQuery": "PartitionKey eq @item().deviceserial and Timestamp gt datetime'2021-02-01T00:00:00' and Timestamp le datetime'2021-02-02T00:00:00'",
                                        "azureTableSourceIgnoreTableNotFound": false
                                    },
                                    "sink": {
                                        "type": "DelimitedTextSink",
                                        "storeSettings": {
                                            "type": "AzureBlobStorageWriteSettings",
                                            "maxConcurrentConnections": 1
                                        },
                                        "formatSettings": {
                                            "type": "DelimitedTextWriteSettings",
                                            "quoteAllText": true,
                                            "fileExtension": ".txt"
                                        }
                                    },
                                    "enableStaging": false,
                                    "validateDataConsistency": false,
                                    "dataIntegrationUnits": 2,
                                    "translator": {
                                        "type": "TabularTranslator",
                                        "mappings": [
                                            {
                                                "source": {
                                                    "name": "PartitionKey",
                                                    "type": "String"
                                                },
                                                "sink": {
                                                    "ordinal": 1
                                                }
                                            },
                                            {
                                                "source": {
                                                    "name": "mts",
                                                    "type": "DateTimeOffset"
                                                },
                                                "sink": {
                                                    "type": "DateTimeOffset",
                                                    "ordinal": 2
                                                }
                                            },
                                            {
                                                "source": {
                                                    "name": "L",
                                                    "type": "String"
                                                },
                                                "sink": {
                                                    "type": "String",
                                                    "ordinal": 3
                                                }
                                            },
                                            {
                                                "source": {
                                                    "name": "Sampling",
                                                    "type": "Int64"
                                                },
                                                "sink": {
                                                    "type": "Int64",
                                                    "ordinal": 4
                                                }
                                            },
                                            {
                                                "source": {
                                                    "name": "V",
                                                    "type": "Double"
                                                },
                                                "sink": {
                                                    "type": "Double",
                                                    "ordinal": 5
                                                }
                                            },
                                            {
                                                "source": {
                                                    "name": "VOut",
                                                    "type": "Double"
                                                },
                                                "sink": {
                                                    "type": "Double",
                                                    "ordinal": 6
                                                }
                                            },
                                            {
                                                "source": {
                                                    "name": "W",
                                                    "type": "Double"
                                                },
                                                "sink": {
                                                    "type": "Double",
                                                    "ordinal": 7
                                                }
                                            },
                                            {
                                                "source": {
                                                    "name": "Wh",
                                                    "type": "Double"
                                                },
                                                "sink": {
                                                    "type": "Double",
                                                    "ordinal": 8
                                                }
                                            }
                                        ]
                                    }
                                },
                                "inputs": [
                                    {
                                        "referenceName": "SourceDataset_f0i",
                                        "type": "DatasetReference"
                                    }
                                ],
                                "outputs": [
                                    {
                                        "referenceName": "DestDScdmEnergy",
                                        "type": "DatasetReference"
                                    }
                                ]
                            }
                        ]
                    }
                }
            ],
            "variables": {
                "DevList": {
                    "type": "Array"
                }
            },
            "annotations": [],
            "lastPublishTime": "2021-08-31T15:27:44Z"
        },
        "type": "Microsoft.DataFactory/factories/pipelines"
    }