We’ve got a zap that sends data from scheduleonce to ontroport. For “Data In” the date is correct, although the date is changed to 0 on “Data Out”. See below.
Does anybody know what is causing this.
Page 1 / 1
Hi
Good question.
I believe Ontraport expects timestamps in UNIX format.
You can use Formatter > Date / Time > Format to get into UNIX format.
https://en.wikipedia.org/wiki/Unix_time
Hey
It looks like Troy nailed it. Our friends in support also had this to share from the open ticket you opened:
It checked the other runs of the Zap, and it seems that the date field doesn't recognize the date from the trigger. I checked Ontraport's API doc to see if there's a specific format that the date field follows and found this:
(view larger)
Is there a way to change the field type of the "f1873" field? I'm not quite familiar with the Ontraport app. Could you please provide how to set the field types in the app?
Feel free to respond to that open ticket if you have further questions! We definitely want to make sure you’re all squared away.
Yes, we were able to solve the issue. We had to include the timezone when we sent the data to Ontraport, which required us to format the date using Zapiers formatter. Sending unix timestamp will not work.
Ah, gotcha! Thanks so much for sharing your solution! We’re stoked you were able to get this situated!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.