Azure Data Factory Copy Activity Rest API JSON response date format incorrect

Question

I am trying to copy data from rest api source using the azure copy activity. I have used Rest Api as source and csv as target. But the json response I am receiving is having the date as below format: {Createddate: /date(345667999)/}

But when I hit preview data its giving the correct date format.(yyyy-mm-dd).

Can anyone suggest why is it like this? Is there any workaround to get the date value with correct format in the copy activity itself?

Answer 1

In the mappings tab of the Copy activity, you will need to set the target column type to either date or string. Please refer the below screenshot :

Hope this helps.