how to store web activity result in a variable?

Question

i have a web activity through which i am executing a rest API(execute queries) this is a sample output of that:

        {

         "results": [
             {
             "tables": [
                 {
                 "rows": [
                       {
                       "[Value]": "2022-10-25T00:00:00Z"
                       }
                      ]
                  }
             ]
         }
]

i want to store the date value inside [Value] in a variable in adf

(variable value should be:2022-10-25T00:00:00Z)

but i am not able to do that because of square brackets this is what i have tried

"@activity('SQl validation').output.results[0].tables[0].rows[0].[value]"

but it give me error

Position 73 Unrecognized expression: value

please suggest how i can fix this

Edit the question to provide the error message as well.

Saideep Arikontham
– Saideep Arikontham

2022-11-15 11:32:08 +00:00
Commented Nov 15, 2022 at 11:32 — Saideep Arikontham
– Saideep Arikontham, Commented Nov 15, 2022 at 11:32

Saideep Arikontham · Accepted Answer · 2022-11-15 12:16:00Z

0

Look at the following demonstration. I have the lookup which returns the following values.

enter image description here

To access the [companyId] attribute from this output array, I have used the following dynamic content (Using for loop just for demonstration):

@string(activity('myLookUp').output.value[item()]['[companyId]'])

enter image description here

So, you can use the following dynamic content instead:

@activity('SQl validation').output.results[0].tables[0].rows[0]['[value]']

answered Nov 15, 2022 at 12:16

Saideep Arikontham

6,1922 gold badges6 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to store web activity result in a variable?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related