Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions
what about @activity('Select_HLP_CFG').output.resultSets[0]['rows'][0].SRC_STM_CODE?
Azure Data Factory: Output Script Activity
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Poel van der, RE (Ron)
451
Reputation points
Hi
I am using two Script activities. The first one reads a table to get one row.
This array is then the input for the second Script activity. In this second one I will build a SQL query (concat or string interpolation (preferred)).
But how do I refer to the three items SRC_STM_CODE / SRC_SCM_CODE / SRC_DSET_TECH_NM?
Query would then be something like:
Update SRC_SCM_CODE.SRC_DSET_TECH_NM set Procesdate = current date where System = SRC_STM_CODE
@activity('Select_HLP_CFG').output.resultSets[0]['rows'] gives me the whole array.
I have tried so many things, but don't succeed. :(
Really hope someone can help.
Azure Data Factory
Accepted answer
-
Nasreen Akter 10,811 Reputation points Volunteer Moderator2022-03-15T18:01:34.333+00:00 -
Poel van der, RE (Ron) 451 Reputation points
2022-03-15T18:08:34.313+00:00 Hi @Nasreen Akter you are an angel.
It works, pff been struggling so long on it.
Tomorrow I will try to build the query with string interpolation.
including updating processdatetime with current datetimeThnx!
-
Nasreen Akter 10,811 Reputation points Volunteer Moderator
2022-03-15T18:16:22.947+00:00 @Poel van der, RE (Ron) , glad it helped! :)
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 98%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJK%3C/text%3E%3C/svg%3E)
James Klein 16 Reputation points2022-11-19T00:11:59.633+00:00 @Nasreen Akter I am trying to do something similar. I am trying to get the IDs from a lookup activity and set a variable = to each ID. From there I will do a ForEach activity to get each ID and put it in the variable and then use that variable in the API call to get different data based on the ID. When I use [0] as the array index, the function works except it selects the same ID for each row. Presumably because [0] references the first value in the array. How do I get it to loop through the lookup activity and get a new ID each time?
In the forEach items property i have
@activity('workspaceids').output.valueand for the variable inside the forEach i have the value set to@activity('workspaceids').output.value[0].ID
Originally I was trying to do what the OP was asking with a query but am now trying with a lookup function and it does not allow me to use resultSets[0] etc..Please help!
-
Nasreen Akter 10,811 Reputation points Volunteer Moderator
2022-11-21T13:30:55.533+00:00 Hi @Poel van der, RE (Ron) , Would you please provide the output sample what you are seeing for @activity('workspaceids').output.value. Thanks!
Sign in to comment -