在Azure数据工厂中遍历Azure SQL表 [英] Iterating Through azure SQL table in Azure Data Factory

问题描述

我正在使用ADF 2并试图解决网络活动.

I'm using ADF 2 and trying to grapple with the web activity.

任务是

从blob存储中复制文件，并将数据放入Azure SQL数据库中遍历数据并使用对REST API的PUT调用来更新数据

Copy file from blob storage and put the data in an azure SQL database Iterate through the data and use a PUT call to a REST API to update the data

好的，这样我就可以在表中获取数据了.我还可以使用Web活动对API进行调用，并在其中放置一些硬编码数据.

Okay so I can get the data in the table no problem. I can also make the call using a Web activity to the the API and put some hard coded data there.

但是我一直在尝试使用For Each来遍历我拥有的表，并调用网络活动以将该数据传递给API

But I've been trying to use a For Each to iterate through the table I have and call the web activity to pass that data to the API

这就是我被困住的地方.我是数据工厂的新手，并遍历了所有标准帮助信息，但是却找不到任何地方.

This is where I'm stuck. I'm New to data factory and been through all their standard help information but not getting any where.

感谢您的帮助

推荐答案

我认为您需要通过填充数据集的SQL查找任务来驱动foreach，然后为每一行调用活动:

I think you need to drive the foreach via a SQL lookup task that populates a data set and then call the activity for each row:

以下是一些入门指南: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-for-each-activity

here are some posts to get you started: https://docs.microsoft.com/en-us/azure/data-factory/control-flow-for-each-activity

https://docs.microsoft.com/zh-CN/azure/data-factory/control-flow-lookup-activity

替换复制活动: https://docs.microsoft.com/zh-CN/azure/data-factory/tutorial-bulk-copy-portal

这篇关于在Azure数据工厂中遍历Azure SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！