formatting time in Zapier
The date time is sent as unix timestamp (integers). This solves the issue related to time zones between 3rd party servers. For example, this is the webhook data that is sent:
{
“id”: 500,
“form_id”: 125,
“form_name”: “TEST Form”,
“number”: 10,
“ip”: “”,
“created_at”: 1610484007,
“updated_at”: 1610484007,
“created_by”: 22,
“updated_by”: 22,
“status”: null,
“new”: null,
“answers”: {
“Name”: “John”,
“Email”: “john@example.com“
},
“country”: “”,
“city”: “”,
“latitude”: “”,
“longitude”: “”,
“user_agent”: “Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.141 Safari/537.36”,
}
Then with Zapier you can use the Format action to convert the unix timestamp value to a date / time format, before send the value to the 3rd party app.
The above Format Step comes between the Trigger and the Action Steps in a Zap.