Azure Data Factory: use of hyphen (-) in Json tree node

Question

Hi all

I'm encountering following problem in the use of the 'Web Activity' in one of my pipelines. I have to pass a node of my json response from one 'Web Activity' to the other 'Web Activity', but the issue is that the name of the node contains a '-' (name is 'Set-Cookie'). I can't seem to be able to parse this expression correctly, is there a way to bypass this issue?
My expression is as follows: 'WebActivity.output.Response.Set-Cookie'

Kind regards

Answer 1

Hello @MPL Michiel Puylaert and welcome to Microsoft Q&A.

Sometimes there are property names that do not parse well when using the dot operator. These may include characters such as . , - , ? . This is not an exhaustive list.

When you need to access such a property, use brackets instead of the dot. This means, in your case:

WebActivity.output.Response['Set-Cookie']

By putting Set-Cookie in single quotes (') , it is interpreted as a string, and not an expression. This works when put inside the brakets ([]).

Please let me know if this helps, or if you have further questions.

Thank you for your patience,
Martin