CODEWITHSUNDEEP
jsonazure-data-factory
MetallicPriest
MetallicPriest

Reputation: 30765

How to read a JSON field with @ in it, in ADF?

I have a JSON field which starts with @ (For example @odata.nextLink). How can I refer it in ADF. If I try activity('SomeActivity')[email protected], it doesn't work.

Note that the field @odata.nextLink also has a dot in it.

Upvotes: 1

Views: 431

Answers (1)

wBob
wBob

Reputation: 14379

Use the square brackets syntax and remove the dot, eg two examples:

@activity('SomeActivity').output['@odata'].nextLink

@activity('Lookup1').output.firstRow['@test']

I'm not sure if this is documented anywhere, I just hammered it out.

Upvotes: 1

Related Questions