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

MPL Michiel Puylaert 26 Reputation points
2020-10-08T07:46:55.117+00:00

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

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,064 questions
{count} votes

Accepted answer
  1. MartinJaffer-MSFT 25,991 Reputation points
    2020-10-08T19:32:21.137+00:00

    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

    3 people found this answer helpful.

0 additional answers

Sort by: Most helpful