Clarification on Adding a New Column ("City") to CSV file Extracted via API in Azure Data Factory

Piethagor Solutions 0 Reputation points
2024-02-11T08:50:13.73+00:00

I am currently working on utilizing an API to extract data in CSV format through Azure Data Factory (ADF). I have encountered a requirement to include an additional column named "City" in the output file, even though this column is not present in the API data.
To address this, I am seeking guidance on two aspects: Source Setting in Azure Data Factory: I would appreciate clarification on how to configure the source settings in Azure Data Factory to incorporate the new column "City" during the data extraction process. Specifically, I am interested in understanding any parameters or configurations necessary to achieve this seamlessly.

  1. Mapping the New Column in Data Flow: Once the data is extracted, I need to map the newly added "City" column within the Azure Data Factory . Could you please provide insights on how to appropriately map this new column, ensuring it aligns with the rest of the data structure?
    or
    could you guide me on how to add a new column(city) to an existing CSV file in the blob storage using ADF
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,041 questions
{count} votes