Webhook date to Google Calendar

How To
, ,
1

Hi
I have a webhook going to a google calendar but the date/month format is incorrect.
I am trying to use a setvariable tool to format it but the google calendar module is ignoring the variable.

image
image1023×429 39.9 KB

image

image
image724×535 38.2 KB

image

This is the date its producing:
image

Any help would be appreciated.

2

Hi @Nathan_Gatt

I observed that the data is in the format DD/MM/YYYY from the webhook. Therefore, I recommend utilizing the “parseDate” function within Google Calendar directly instead of setting it as a variable.
I could see that in the start date field you have mapped two variable.

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

2 Likes
3

Thanks for the advise, I did try that by adding this into the start date:

{{parseDate(1.49; “DD/MM/YYYY”)}}YYYY-MM-DD){{1.51}}

I have tried all kinds of combinations of format date and parse date but the Google Calendar module produces this error:

HANDLED ERROR

  • type
    BundleValidationError
  • message
    Validation failed for 1 parameter(s).
  • detail
    Invalid date in parameter ‘start’

Update: Got it working by using the following: {{formatDate(parseDate(1.49; “DD/MM/YYYY”); “YYYY-MM-DD”)}}{{1.51}}
image

Thanks

2 Likes
4

Hello @Nathan_Gatt welcome to the community :wave:

I just wanted to quickly jump in and say congrats on solving this one with the assistance of @Msquare_Automation :clap: It’s great to see that you got things up and running!

Also, thank you very much for getting back to the community and sharing your final solution with us. This is super valuable and can help many folks searching for similar information in the future. :pray:

Keep up the great work :four_leaf_clover:

1 Like