I’m using ADF to ingest data from a REST API into a SQL database. One endpoint contains dates of public holidays and has a ‘year’ parameter that must be specified in order to extract the holidays for that year. I’m using ADF’s built-in pagination to loop over multiple years in a single Copy Data activity.

I’d like to write the ‘year’ value to the SQL sink when I do this. This is my current setup:

I’ve tried to use Additional Columns to pass the year value to the sink, but it’s not currently working. How can I setup my activity to write this value to the sink?