Copy Activity(REST source) How to map a particular json key-value to a variable

Ramamoorthy, Kesavan 61 Reputation points
2021-01-26T13:34:04.487+00:00

Hi,

I am using a http connector to pull the data from a rest api source(due to other issues in rest connector) and store the data in ADLS gen2. The source api response is a json file with few fields.

Under 'Mapping' tab in the copy activity dataset, the array 'data' is what we need to store in ADLS and there is no issues in mapping that array to Sink and that has been done already.

The question is, Is there any possibility to assign the values coming from the json output key
"[pagination][cursors][after]" that has been highlighted in the picture to a variable ?

60643-image.png

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