参数化Azure Data Factory中的REST API调用 [英] Parameterize REST API Calls from Azure Data Factory
问题描述
我有一个要求,其中 我需要使用100个不同的REST从100个表中提取数据 API调用。我们是否可以选择参数化Rest服务(链接服务)来循环复制活动?
非常感谢您的帮助。
嗨Mari2004,
如果你有要在每次迭代中调用的REST API列表,您可以将其存储在管道或文件或表中的变量中,并使用ForEach活动循环遍历API列表并在每次迭代时调用Web活动。
如果表/ REST API列表来自另一个数据源(如REST API或外部表),您可以使用getMetadata活动来查询它,然后使用它的结果来构建如上所述的ForEach活动。
请参阅
本教程针对具有2个管道的类似复制活动。
希望这会有所帮助。
Hi,
I have a requirement where I need to pull data from 100 tables using 100 different REST API calls . Do we have any option to parameterize the Rest Service(Linked service) to loop the copy activity?
You help is highly appreciated.
Hi Mari2004,
If you have a list of REST APIs to be called in every iteration, you can store it in a variable in a pipeline or in a file or table and the use a ForEach activity to loop through the list of APIs and call a web activity at every iteration.
If the list of tables/REST APIs comes from another data source like a REST API or an external table, you can use a getMetadata activity to query that, then use the result of it to construct a ForEach activity as mentioned above.
Please refer to this tutorial for a similar copy activity with 2 pipelines.
Hope this helps.
这篇关于参数化Azure Data Factory中的REST API调用的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!