Copy(API，SQL_table):如何将管道参数作为列表的值传递? [英] Copy(API,SQL_table) : how to pass pipeline parameters as column table's value ?

问题描述

大家好！

我在azure数据工厂工作，并且有一条管道.

I work on azure data factory, and i have a pipeline.

此管道由一个查询和一个foreach(查询的foreach元素)组成.

This pipeline is composed of a look up then a foreach (foreach element of the look up). 

我在这里有参数:例如@item().Id，它将在我的foreach活动中使用.

I have parameters here : @item().Id for instance, which will be used in my foreach's activities. 

我将从API调用(我在数据集httpfile中解析的json)复制到SQL表.我从json文件(持续时间，href)中提取了两件事，所以我有到两列的映射.但是，如果我必须将我的ID添加为列表，但不是从中解析的 我的json(@item().Id在这里).我意识到我没有办法将动态内容作为要在接收器目标中映射的列进行传递.如果我不太清楚，请告诉我:).预先谢谢您.

I do a copy from an API call (a json that i parse in my dataset httpfile) to an SQL table. I extract two things from my json file (duration,href), so i have a mapping to two columns. But if i have to add my ID as a column table, but which isn't parse from my json (@item().Id here). I realized that i don't have a way to pass dynamic contents as columns to be mapped in the sink destination. If i'm not clear enough, tell me :). Thank you in advance. 

推荐答案

您好，

您是否要在遍历foreach时不断添加列?

Are you trying to constantly add columns as you iterate through the foreach?

这篇关于Copy(API，SQL_table):如何将管道参数作为列表的值传递?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！