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.
Best answer
Date Changed to 0 on Data Out
- Beginner
- 1 reply
Best answer by MikeFBest answer by MikeF
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.
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+14- Zapier Expert
- 31004 replies
Hi
Good question.
I believe Ontraport expects timestamps in UNIX format.
You can use Formatter > Date / Time > Format to get into UNIX format.
+9- Zapier Staff
- 2653 replies
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.
- Beginner
- 1 reply
- Answer
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.
+9- Zapier Staff
- 2653 replies
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.