Azure Data Factory Copy using Variable

Question

I am copying data from a rest api to an azure SQL database. The copy is working fine but there is a column which isn't being return within the api.

What I want to do is to add this column to the source. I've got a variable called symbol which I want to use as the source column. However, this isn't working:

Mapping

Any ideas?

Answer 1

This functionality is available using the "Additional Columns" feature of the Copy Activity.

If you navigate to the "Source" area, the bottom of the page will show you an area where you can add Additional Columns. Clicking the "New" button will let you enter a name and a value (which can be dynamic), which will be added to the output.

Source(s): https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-overview#add-additional-columns-during-copy