I have a lookup that returns the following in ADF:

{
“firstRow”: {
“”: 1044624
},
“effectiveIntegrationRuntime”: “AutoResolveIntegrationRuntime (East US)”,
“durationInQueue”: {
“integrationRuntimeQueue”: 0
}
}

In my pipeline, I’m trying to do a Set Variable and return the value of 1044624 but I can’t seem to retrieve it. I’m getting the string value of “@activity(‘Lookup1’).output.firstRow[”]”

Using the output above, what do I put in for the value of the Set Variable in the pipeline that occurs directly after the Lookup?

​I have a lookup that returns the following in ADF:{“firstRow”: {“”: 1044624},”effectiveIntegrationRuntime”: “AutoResolveIntegrationRuntime (East US)”,”durationInQueue”: {“integrationRuntimeQueue”: 0}} In my pipeline, I’m trying to do a Set Variable and return the value of 1044624 but I can’t seem to retrieve it. I’m getting the string value of “@activity(‘Lookup1’).output.firstRow[”]” Using the output above, what do I put in for the value of the Set Variable in the pipeline that occurs directly after the Lookup?      Read More

​