Title
#users-public
d

Dean Markwick

02/10/2022, 8:41 PM
I'm uploading csvs via the rest API, but the timestamps are inconsistent. Is there any way I can make the format flexible? For example: some timestamps are like 2022-02-10T19:00:00.123Z Others: 2022-02-10T19:00:00.123123Z
Vlad

Vlad

02/10/2022, 8:47 PM
hi Dean, is it in the same field i assume ?
d

Dean Markwick

02/10/2022, 8:48 PM
yeah all in the same field
Vlad

Vlad

02/10/2022, 8:50 PM
i think it should be possible
8:50 PM
give me a sec
d

Dean Markwick

02/10/2022, 8:51 PM
ty ty, no rush!
Vlad

Vlad

02/10/2022, 9:10 PM
I checked everywhere and its unfortunately not possible to load CSV with inconsistent format. I thought this format could cut it:
yyyy-MM-ddTHH:mm:ss.SSSUZ
but although
U
is greedy it requires at least one digit, wouldn't let
2022-02-10T19:00:00.123Z
thru. If you remove U, the other date doesn't go thru
9:11 PM
it would work if we had optionality, but that's quite niche and i'm not aware of traditional date formats supporting it
d

Dean Markwick

02/11/2022, 8:58 AM
Thanks for looking, I'll add a preprocess step too my data loading then to pad out with some zeros