date problem in copy activity

Yannick Widmer 1

Similarly to this question https://stackoverflow.com/questions/57811363/azure-data-factory-copy-activity-rest-api-json-response-date-format-incorrect on stackoverflow do I have a problem with Copy activity and dates. I have an endpoint sending me perfectly fine dates. The copy activity then transforms them on one end into "/Date(1452902400000)/" which is what I get if I don't specify the format. If I do specify that it is a date I get an error saying an entry has a wrong format of the form "/Date(1452902400000)/" but the copy activity did that. I would be perfectly fine if it was just letting it as is. The problem is I need the copy activity to create json documents from an array so I can not use the binary copy.

HimanshuSinha-msft 19,476 Reputation points Microsoft Employee

2021-06-07T20:37:58.033+00:00
Hello @Yannick Widmer ,
Thanks for the ask . I wanted to repro this issue and I used the free API of Weatherstack.com
http://api.weatherstack.com/current?access_key={somekey}&query=New York.

When I process this in copy actvity it just works fine .
.

The ask is

Is the URL in question a public URL ? If yes I can try to work on that .

Can you share the response JSON of the REST API .

We will wait to hear from you on this .

Thanks
Himanshu
Yannick Widmer 1 Reputation point

2021-06-08T06:03:35.05+00:00

@HimanshuSinha-msft Sadly it is not a free API but a SAP webservice. I had to modify a bit to remove sensitive data but the response json looks like this

]1

I then write it into a blobstorage as json, in a row per document fasion where the documents are the entries in results.
Astha Chaturvedi 0 Reputation points

2023-06-11T18:06:58.6933333+00:00

Hi Yannick/Himanshu, Did anyone of you get the solution to this issue? I am facing a same issue for a very similar scenario.

Thank you.

Share via

date problem in copy activity

Your answer