Convert Date to be able to use with Google Calendar

Help
, , ,
1

Hello everyone,

I am trying to use some data I receive thru webhook to create events in a Google Calendar. I am having issues creating those events because according to the “Event Date” setup instructions;
“For all-day events, enter the Event day in the format ‘yyyy-mm-dd’. For events with time, format according to RFC3339: ‘yyyy-mm-ddThh:mm:ss+01:00’. A time zone offset is required unless a time zone is explicitly specified in timeZone.”
But the data I have available is formatted as : ‘06-10-2022’ in the the date item and ‘00:45:00’ in the time item

  1. Is there a way for me in pipe dream to transform the data and get it as google calendar needs it?
  2. Once transformed how can I use the same data to get that date/time + one hour so that I can use it in the “Event End Date” for google.

Here is a copy of the response log in case it’s needed:
{
“error”: {
“errors”: [
{
“domain”: “global”,
“reason”: “badRequest”,
“message”: “Bad Request”
}
],
“code”: 400,
“message”: “Bad Request”
}
}

I appreciate the help!

2

Hi @khalidmadih

Yes absolutely you can do this in Pipedream.

You can use Node.js or Python code steps to modify and perform the date time addition and formatting.

You can import any NPM package such as moment or date-fns to perform this transformation.