how to add ingestion time column in csv getting created by calling rest api from azure data factory copy activity

Question

how to add ingestion time column in csv getting created by calling rest api from azure data factory copy activity

vijayshankar 0

Hi,
I am getting some data from Rest API and copying it in a csv file. I want to add a additional column ingestion_timestamp, which is time at which pipeline ran, to each row of csv .
How do I achieve this, as additional column is only available on UI when working with a Text Source ?
Thanks

J N S S Kasyap 3,625 Reputation points Microsoft External Staff Moderator

2025-03-19T14:01:06.6933333+00:00

@vijayshankar
Just checking in to see if the below answer provided by @Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

J N S S Kasyap 3,625 Reputation points Microsoft External Staff Moderator

2025-03-19T14:01:06.6933333+00:00

@vijayshankar
Just checking in to see if the below answer provided by @Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Nandan Hegde 36,146 MVP Volunteer Moderator

Can you please confirm on what you mean by this :

as additional column is only available on UI when working with a Text Source ??

because with REST as a source in copy activity, you can add additional columns :

User's image

J N S S Kasyap 3,625 Reputation points Microsoft External Staff Moderator

2025-03-20T16:17:41.6633333+00:00

@vijayshankar
Just checking in to see if the above answer provided by @Nandan Hegde helped.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

how to add ingestion time column in csv getting created by calling rest api from azure data factory copy activity

1 answer

Your answer