Hey I'm working with the pinterest ads tap and I'm having some issues with the date format for one of the columns. The current output from the api is

"2021-09-02"

, but I'm getting this error when I try to send it to my target

Expected [yyyy-MM-dd'T'HH:mm:ssZ, yyyy-MM-dd'T'HH:mm:ss.[0-9]{1,9}Z]\n#/DATE: expected: null, found: String\n"}

. Is there supposed to be some transformation happening, or is that on me? Does anyone have experience with this?

can you see which stream is emitting this? which target? I've been running it into snowflake and jsonl

@dennis_dinwiddie what's the declared JSON type of that field?

The stream is

ad_analytics

and the schema is

"DATE": {
            "format": "date-time",
            "type": [
              "string",
              "null"
            ]
          }

I'm testing with the stitch target

hmm do the dates emitted from the tap have to be in yyyy-MM-ddTHHMMSSZ format? 🤔

I think so https://github.com/singer-io/getting-started/blob/master/docs/BEST_PRACTICES.md#dates

updated on this branch if you wanna try: https://github.com/GtheSheep/tap-pinterest-ads/tree/dates

Wow that was fast

I missed the "Z" in the first commit, have added it now 😅

Alright looks good on my end!

👌 I'll test it out with json/snowflake tomorrow and update main