CODEWITHSUNDEEP
azure-data-factory
user3048456
user3048456

Reputation: 31

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

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?

Upvotes: 2

Views: 486

Answers (1)

chiragMishra-msft
chiragMishra-msft

Reputation: 192

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 :

enter image description here

Hope this helps.

Upvotes: 0

Related Questions