Google Calendar event time is not the same as the time sent from the webhook

[ebaru]

Flow Data: The event is created for 10:00 AM

Google Calendar View: The event is displayed for 05:00 AM

Please can you help me solve this error

[PFernandez98]

Hi! double check the timezone for the event in your calendar. Maybe that’s the issue.

[ebaru]

Thanks for answering.
I checked again and the time is the same as configured in the webhook (GMT-05:00).

Those 5 hours are what is making the difference.
The Webhook sends a reservation at 10 am but the calendar shows it at 5:00 am.
I did a test with Make with the same parameters sent in the webhook and the calendar correctly shows the appointment without any problem, which means that there must be some bug in Activepiece.

[PFernandez98]

Well @ebaru , I know is not ideal, but in the meantime, you can try the Date Helper piece, and subtract (or add, I’m not sure about your flow) those 5 hours before processing the data.

[ebaru]

Okay! I am not a programmer, but what I can understand is that you have to add the Date Helper module after the Webhook and before the Google Calendar so that it adds the (+5) hours that are needed.
Is there any example link, video or instruction on how to add these times to the start time sent by the webhook?

[PFernandez98]

Post the date you get in the webhook, I’ll prepare a functional example for you.

[ebaru]

Yes!

startTime”:“2024-01-17T16:00:00”}

Output:

{“body”:{“ip”:“45.181.206.30”,“Nombre”:“Jose A”,“idStat”:“7389179”,“booking”:{“name”:“ACTIVEPIECES-LFT”,“endTime”:“2024-01-17T16:30:00”,“timezone”:“America/Bogota”,“startTime”:“2024-01-17T16:00:00”},“idAgent”:“9acbda4c-53a7-445f-afb5-2cb299de0a55”,“WhatsApp”:“573155618443”,“idWidget”:“0dc043ef-749c-46d9-9da1-4029e29adff1”,“referrer”:“https://services.tochat.be/es/app/whatsapp/form/calendar-booking/0dc043ef-749c-46d9-9da1-4029e29adff1",“utmParams”:“”},“method”:“POST”,“headers”:{“host”:“cloud.activepieces.com”,“accept”:“*/*”,“cf-ray”:“84717682fce7634c-LHR”,“cdn-loop”:“cloudflare”,“x-real-ip”:“172.69.194.122”,“cf-visitor”:“{\“scheme\”:\“https\”}”,“connection”:“close”,“user-agent”:"Symfony HttpClient/Curl”,“cf-ipcountry”:“DE”,“content-type”:“application/x-www-form-urlencoded”,“content-length”:“464”,“accept-encoding”:“gzip”,“x-forwarded-for”:“172.69.194.122”,“cf-connecting-ip”:“2a01:4f8:c0c:c3b4::1”,“x-forwarded-host”:“cloud.activepieces.com”,“x-forwarded-port”:“443”,“x-forwarded-proto”:“https”,“x-forwarded-server”:“357498a82a7a”},“queryParams”:{}}

[PFernandez98]

@ebaru

2024-01-17T16:30:00

Here you go, let me know if it works for you.

[ebaru]

I followed the step by step of the image you sent and sent what I did, but the appointment is still assigned to me on the calendar 5 hours before.
I do not know what to do

[PFernandez98]

the Date helper, doesn’t output the corrected date and time? I can’t tell by the image.

[ebaru]

It worked.
The Date Helper added the 5 hours to the start time and I added another Data Helper to add 5 hours to the end time.
This way the Google Calendar is displayed well. The negative is that there are 2 additional tasks that are deducted from the plan for each reservation.
Should they fix that bug or does it just happen with my flow?

[PFernandez98]

Maybe is something with the service you are using to take reservation. Haven’t seen anybody in the community with this problem.

PS: I’m glad it worked. You can mark this as the solution, in case anybody else have this problem in the future: Google Calendar event time is not the same as the time sent from the webhook - #4 by PFernandez98