ADF:使用等待和动态foreach调用表格行
在ADF中使用等待操作和动态foreach调用表格行的方法如下：
-
将ADF的操作添加到ForEach循环内。
-
编写脚本来检索表格行的值。这可以通过使用Lookup活动来实现。
-
在ForEach循环内使用Wait活动。等待活动可以使用时间间隔或直到某个条件得到满足。
以下是一个示例ADF的解决方法，可以使用等待和动态ForEach调用表格行：
{ "name": "ForEach_Call_Table_Row_Dynamically_Wait", "properties": { "activities": [ { "name": "ForEach", "type": "ForEach", "dependsOn": [], "userProperties": [], "typeProperties": { "items": { "value": "@activity('Lookup_Table').output.value", "type": "Expression" }, "batchCount": 20, "activities": [ { "name": "Wait", "type": "Wait", "dependsOn": [ { "activity": "Lookup_Table", "dependencyConditions": [ "Completed" ] } ], "userProperties": [], "typeProperties": { "waitTimeInSeconds": 10, "expression": { "value": "@equals(activity('Lookup_Table').output.value[0].state,'Succeeded')", "type": "Expression" } } }, { "name": "Call_Table_Row_Dynamically", "type": "ExecutePipeline", "dependsOn": [ { "activity": "Wait", "dependencyConditions": [ "Completed" ] } ], "userProperties": [], "typeProperties": { "pipeline": { "referenceName": "SubPipeline", "type": "PipelineReference" }, "waitOnCompletion": true, "parameters": { "TableName": "@item().TableName", "TableRow": "@item().TableRow" } } } ] } }, { "