I need to format the date from Google Calendar (2024-12-18T08:30:00-03:00) to ISO 8601 Calendly (2024-12-18T11:45:00Z or 2024-12-18T11:45:00+00:00).
I've been trying with Zapier Formatter in many ways and always fails.
How can I do it?
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.
+5
I believe your input date is already in the ISO format.
Here's the breakdown:
2024-12-18: Date in YYYY-MM-DD format.
T: Separator between date and time.
08:30:00: Time in HH:MM:SS format (24-hour clock).
-03:00: Timezone offset, indicating 3 hours behind UTC
The formatted datetimes you are entering are wrong because the -0000 offset is invalid. To correct this the the offset should be -00:00. Although this will be different from your input timezone of -03:00 or three hours behind UTC.
To convert to UTC just add a Z at the end 2024-12-18T11:30:00Z or format the offset as -00:00
Another issue is that the meeting is 15 minutes long but your start and end are the same time your end datetime should read 2024-12-18T11:45:00-03:00 15 minutes after the start.
Do let me know if I understood the problem correctly.
I believe your input date is already in the ISO format.
Here's the breakdown:
2024-12-18: Date in YYYY-MM-DD format.
T: Separator between date and time.
08:30:00: Time in HH:MM:SS format (24-hour clock).
-03:00: Timezone offset, indicating 3 hours behind UTC
The formatted datetimes you are entering are wrong because the -0000 offset is invalid. To correct this the the offset should be -00:00. Although this will be different from your input timezone of -03:00 or three hours behind UTC.
To convert to UTC just add a Z at the end 2024-12-18T11:30:00Z or format the offset as -00:00
Another issue is that the meeting is 15 minutes long but your start and end are the same time your end datetime should read 2024-12-18T11:45:00-03:00 15 minutes after the start.
Do let me know if I understood the problem correctly.
Thanks for the answer.
Yeah, you’re right, but this is only one of the many solutions I tried. I also try using the G Calendar raw date format, and input manually and problem still there.
+14
For us to have full context, post screenshots showing how your current Zap steps are outlined and configured in EDIT mode with the field mappings visible.
+11Hi there,
I can see that you reached out to our Support team about this as well but I couldn’t see any reply from your end, so I’m not sure whether their suggestion resolved things for you here. I’ll share their suggestion here in case it helps you or anyone else encountering that “The supplied parameters are invalid” error:
I see what you mean about the Calendy action returning the error: The supplied parameters are invalid
Reviewing the error message, I found that this is happening due to the input in the 'Host User' field. I did some digging in Calendly's API docs and found that they're expecting the Calendly User ID in this field.
Can you try mapping the 'ID' value from step 2 to the 'Host User' field in step 7 to see if that helps out here?
(view larger)
Can you give that a try (if you haven’t already) and let us know if it resolves the error?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
