How to define pipeline return value in SetVariableActivity in .NET project?

OGINTZ Marina 175

Hi,

I'm implementing SetVariableActivity in my .NET project.

I wanted to define the return value pipeline but it is defined as

DataFactoryElement<BinaryData> Value

although it is an array of values.

How can I define it in my project?

I tried few options but it doesn't work.

User's image

Bhargava-MSFT 31,246 Reputation points Microsoft Employee

2024-03-18T20:41:13.8566667+00:00

Hello OGINTZ Marina

If the output of 'Lookup2' is an array of values and you want to assign this array to a variable in your SetVariableActivity, you need to make sure you're handling the array correctly in your expression.

if you want to assign the entire array to a variable, you don't need to use .value because 'value' is used when you're accessing a single value. Instead, you can directly assign the output of 'Lookup2' to the variable:

@activity('Lookup2').output

This expression will assign the entire array output of 'Lookup2' to the variable defined in your SetVariableActivity.

If you want to access a specific element of the array, you can use array indexing. For example, to access the first element of the array:

@activity('Lookup2').output[0]

I hope this helps.
OGINTZ Marina 175 Reputation points

2024-03-19T08:23:50.4533333+00:00

I'm not sure I got you.

I'm trying to define pipeline return value of SetVariableActivity. I tried to return json and I set it as you showed in the example:

[{"key": "myKey1", "value": {"type": "String", "content": "hello world"}}, {"key": "myKey2", "value": {"type": "String", "content": "hi"}} ]

and it didn't work.

Can you please show me an example?

Your answer