• d

    Dean Markwick

    6 months ago
    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

    6 months ago
    hi Dean, is it in the same field i assume ?
  • d

    Dean Markwick

    6 months ago
    yeah all in the same field
  • Vlad

    Vlad

    6 months ago
    i think it should be possible
  • give me a sec
  • d

    Dean Markwick

    6 months ago
    ty ty, no rush!
  • Vlad

    Vlad

    6 months ago
    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
  • 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

    6 months ago
    Thanks for looking, I'll add a preprocess step too my data loading then to pad out with some zeros