{ "name": "AB1_Copy_issue_fix", "properties": { "activities": [ { "name": "FileLookup", "type": "Lookup", "dependsOn": [], "policy": { "timeout": "0.12:00:00", "retry": 0, "retryIntervalInSeconds": 30, "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "source": { "type": "DelimitedTextSource", "storeSettings": { "type": "AzureBlobStorageReadSettings", "recursive": false, "enablePartitionDiscovery": false }, "formatSettings": { "type": "DelimitedTextReadSettings", "quoteAllText": false, "fileExtension": null } }, "dataset": { "referenceName": "ab1_copy_issue_fixlookupdataset", "type": "DatasetReference", "parameters": { "containerName": { "value": "@pipeline().parameters.containerName", "type": "Expression" }, "folderPath": { "value": "@pipeline().parameters.folderPath", "type": "Expression" }, "fileName": { "value": "@pipeline().parameters.fileName", "type": "Expression" } } }, "firstRowOnly": false, "location": null, "sheetIndex": 0, "columnDelimiter": null, "firstRowAsHeader": false, "sink": null, "enableStaging": false, "translator": null, "items": null, "isSequential": false, "variableName": null, "value": null, "activities": null, "expression": null, "ifFalseActivities": null, "ifTrueActivities": null, "recurrence": null, "blobPathBeginsWith": null, "blobPathEndsWith": null, "ignoreEmptyBlobs": false, "scope": null, "events": null }, "inputs": null, "outputs": null }, { "name": "ForEach", "type": "ForEach", "dependsOn": [ { "activity": "FileLookup", "dependencyConditions": [ "Succeeded" ] } ], "userProperties": [], "typeProperties": { "items": { "value": "@activity('FileLookup').output.value", "type": "Expression" }, "isSequential": true, "activities": [ { "name": "Trigger Condition", "type": "IfCondition", "dependsOn": [ { "activity": "SetLookUpTriggerName", "dependencyConditions": [ "Succeeded" ] }, { "activity": "PipeLineTriggerName", "dependencyConditions": [ "Succeeded" ] } ], "userProperties": [], "typeProperties": { "expression": { "value": "@equals(variables('triggerName'), pipeline().TriggerName)\r\n", "type": "Expression" }, "ifFalseActivities": [ { "name": "EnteredElse", "description": "Entered Else Condition If evaluation failed", "type": "SetVariable", "dependsOn": [], "policy": { "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "variableName": "elseVar", "value": "Entered Else" } } ], "ifTrueActivities": [ { "name": "SetContainerName", "description": null, "type": "SetVariable", "dependsOn": [ { "activity": "EnterIfCondition", "dependencyConditions": [ "Completed" ] } ], "policy": { "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "variableName": "containerName", "value": { "value": "@{item().containerName}", "type": "Expression" } }, "inputs": null, "outputs": null }, { "name": "SetSourceFolderPath", "description": null, "type": "SetVariable", "dependsOn": [ { "activity": "EnterIfCondition", "dependencyConditions": [ "Completed" ] } ], "policy": { "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "variableName": "sourceFolderPath", "value": { "value": "@{item().sourceFolderPath}", "type": "Expression" } }, "inputs": null, "outputs": null }, { "name": "SetFileName", "description": null, "type": "SetVariable", "dependsOn": [ { "activity": "EnterIfCondition", "dependencyConditions": [ "Completed" ] } ], "policy": { "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "variableName": "fileName", "value": { "value": "@{item().fileName}", "type": "Expression" } }, "inputs": null, "outputs": null }, { "name": "SetDestinationFolderPath", "description": null, "type": "SetVariable", "dependsOn": [ { "activity": "EnterIfCondition", "dependencyConditions": [ "Completed" ] } ], "policy": { "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "variableName": "destFolderPath", "value": { "value": "@{item().destinationFolderPath}", "type": "Expression" } }, "inputs": null, "outputs": null }, { "name": "FileTransfer Copy", "description": null, "type": "Copy", "dependsOn": [ { "activity": "SetSourceFolderPath", "dependencyConditions": [ "Succeeded" ] }, { "activity": "SetContainerName", "dependencyConditions": [ "Succeeded" ] }, { "activity": "SetFileName", "dependencyConditions": [ "Succeeded" ] }, { "activity": "SetDestinationFolderPath", "dependencyConditions": [ "Succeeded" ] } ], "policy": { "timeout": "0.12:00:00", "retry": 0, "retryIntervalInSeconds": 30, "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "source": { "type": "DelimitedTextSource", "storeSettings": { "type": "AzureBlobStorageReadSettings", "recursive": false, "enablePartitionDiscovery": false }, "formatSettings": { "type": "DelimitedTextReadSettings", "quoteAllText": true, "fileExtension": ".csv" } }, "sink": { "type": "DelimitedTextSink", "storeSettings": { "type": "FileServerWriteSettings", "recursive": false, "wildcardFileName": null, "enablePartitionDiscovery": false }, "formatSettings": { "type": "DelimitedTextWriteSettings", "quoteAllText": true, "fileExtension": ".csv" } }, "enableStaging": false, "translator": { "type": "TabularTranslator", "typeConversion": true, "typeConversionSettings": { "allowDataTruncation": true, "treatBooleanAsNumber": false } }, "variableName": null, "value": null, "dataset": null }, "inputs": [ { "referenceName": "ab1_copy_issue_fixcsvsourcedataset", "type": "DatasetReference", "parameters": { "containerName": { "value": "@{string(variables('containerName'))}", "type": "Expression" }, "folderPath": { "value": "@{string(variables('sourceFolderPath'))}", "type": "Expression" }, "fileName": { "value": "@{string(variables('fileName'))}", "type": "Expression" } } } ], "outputs": [ { "referenceName": "ab1_copy_issue_fixcsvdestinationdataset", "type": "DatasetReference", "parameters": { "containerName": { "value": "@{string(variables('containerName'))}", "type": "Expression" }, "folderPath": { "value": "@{string(variables('destFolderPath'))}", "type": "Expression" }, "fileName": { "value": "@{string(variables('fileName'))}", "type": "Expression" } } } ] }, { "name": "EnterIfCondition", "description": "Entered If Condition", "type": "SetVariable", "dependsOn": [], "policy": { "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "variableName": "ifVar", "value": { "value": "@pipeline().TriggerName", "type": "Expression" } }, "inputs": null, "outputs": null } ], "location": null, "sheetIndex": 0, "columnDelimiter": null, "firstRowAsHeader": false, "source": null, "sink": null, "enableStaging": false, "translator": null, "dataset": null, "firstRowOnly": false, "items": null, "isSequential": false, "variableName": null, "value": null, "activities": null, "recurrence": null, "blobPathBeginsWith": null, "blobPathEndsWith": null, "ignoreEmptyBlobs": false, "scope": null, "events": null }, "policy": null, "inputs": null, "outputs": null }, { "name": "SetLookUpTriggerName", "type": "SetVariable", "dependsOn": [], "policy": { "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "variableName": "triggerName", "value": { "value": "@item().triggerName", "type": "Expression" } }, "inputs": null, "outputs": null }, { "name": "PipeLineTriggerName", "type": "SetVariable", "dependsOn": [], "policy": { "secureOutput": false, "secureInput": false }, "userProperties": [], "typeProperties": { "variableName": "pipeLineTriggerName", "value": { "value": "@pipeline().TriggerName", "type": "Expression" } }, "inputs": null, "outputs": null } ], "location": null, "sheetIndex": 0, "columnDelimiter": null, "firstRowAsHeader": false, "source": null, "sink": null, "enableStaging": false, "translator": null, "dataset": null, "firstRowOnly": false, "variableName": null, "value": null, "expression": null, "ifFalseActivities": null, "ifTrueActivities": null, "recurrence": null, "blobPathBeginsWith": null, "blobPathEndsWith": null, "ignoreEmptyBlobs": false, "scope": null, "events": null }, "inputs": null, "outputs": null } ], "parameters": { "containerName": { "type": "string", "defaultValue": "filetransfer" }, "folderPath": { "type": "string", "defaultValue": "LookUp" }, "fileName": { "type": "string", "defaultValue": "FileTransferLookUp.csv" } }, "variables": { "containerName": { "type": "String" }, "sourceFolderPath": { "type": "String" }, "fileName": { "type": "String" }, "destFolderPath": { "type": "String" }, "triggerName": { "type": "String" }, "pipeLineTriggerName": { "type": "String" }, "elseVar": { "type": "String" }, "ifVar": { "type": "String" }, "lookUpContainer": { "type": "String", "defaultValue": "filetransfer" } }, "annotations": [], "linkedServiceName": null, "typeProperties": null, "schema": null, "lastPublishTime": "2024-05-14T06:58:23Z", "type": null, "pipelines": null }, "type": "Microsoft.DataFactory/factories/pipelines" }