Uploaded image for project: 'Red Hat Fuse'
  1. Red Hat Fuse
  2. ENTESB-12856

Google Calendar time -> GC time data mapping throws 'Invalid date/time format: ...'

XMLWordPrintable

    • % %
    • Hide

      preparation:
      In `https://calendar.google.com/calendar/`
      1. Create 2 google calendars. (testCal1, and testCal2)
      2. Create an event "past_event" in calendar "testCal2":
      Extract event id:
      3. Double click on created event in google calendar -> you will get uri (e.g 'https://calendar.google.com/calendar/b/5/r/eventedit/ZnZ1azJzaWlwZjdvOGQybDJsZ3VucTI2MmMgZWNjaDlpMTY5cjV1NzdlZGw3NTJwOTFyNjBAZw?tab=rc1'
      4. Take string after last slash ('ZnZ1azJzaWlwZjdvOGQybDJsZ3VucTI2MmMgZWNjaDlpMTY5cjV1NzdlZGw3NTJwOTFyNjBAZw?tab=rc1')
      and decode it here: https://www.base64decode.org/
      5. take fist part of decoded result (there are 2 parts,separted by either '_' or ' ')
      that is event id (see extracted-event-id below)

      In syndesis:
      1. Put credentials for google calendar (Settings -> Google Calendar -> Client Id + Client Secret related to your account)
      2. Create connection for google calendar (Connections -> Create connections -> select Google Calendar type -> Connect to Google calendar (select your account))
      Create integration:
      3. (from) 'Timer' -> Simple -> 1 min.
      4. (to) 'Google Calendar' -> "Create event" -> event_title=new_event, calendar_name=testCal1
      5. Add middle step 'Google Calendar' -> "Get a specific event" -> calendar_name=testCal2, event_id=extracted-event-id(see preparation)

      6. add datamapper step between 2 google calendars steps, and map start_time -> start_time, end_time -> end_time (just these 2 are problematic, e.g start_date and end_date are OK) from past_event to new_event.
      7. publish integration

      Show
      preparation: In ` https://calendar.google.com/calendar/ ` 1. Create 2 google calendars. (testCal1, and testCal2) 2. Create an event "past_event" in calendar "testCal2": Extract event id: 3. Double click on created event in google calendar -> you will get uri (e.g 'https://calendar.google.com/calendar/b/5/r/eventedit/ZnZ1azJzaWlwZjdvOGQybDJsZ3VucTI2MmMgZWNjaDlpMTY5cjV1NzdlZGw3NTJwOTFyNjBAZw?tab=rc1' 4. Take string after last slash ('ZnZ1azJzaWlwZjdvOGQybDJsZ3VucTI2MmMgZWNjaDlpMTY5cjV1NzdlZGw3NTJwOTFyNjBAZw?tab=rc1') and decode it here: https://www.base64decode.org/ 5. take fist part of decoded result (there are 2 parts,separted by either '_' or ' ') that is event id (see extracted-event-id below) In syndesis: 1. Put credentials for google calendar (Settings -> Google Calendar -> Client Id + Client Secret related to your account) 2. Create connection for google calendar (Connections -> Create connections -> select Google Calendar type -> Connect to Google calendar (select your account)) Create integration: 3. (from) 'Timer' -> Simple -> 1 min. 4. (to) 'Google Calendar' -> "Create event" -> event_title=new_event, calendar_name=testCal1 5. Add middle step 'Google Calendar' -> "Get a specific event" -> calendar_name=testCal2, event_id=extracted-event-id(see preparation) 6. add datamapper step between 2 google calendars steps, and map start_time -> start_time, end_time -> end_time (just these 2 are problematic, e.g start_date and end_date are OK) from past_event to new_event. 7. publish integration

      When integration is from Google Calendar connection to Google Calendar connection, and in datamapper step is chosen mapping related to time (e.g start_time -> start_time) integration throws Exception:
      `java.lang.NumberFormatException: Invalid date/time format: 2018-10-01T10:00`

      (note 1: start_date -> start_date is OK.)

            christoph.deppisch Christoph Deppisch
            sveres@redhat.com Stefan Veres
            Stefan Veres Stefan Veres
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: