getting 400 message": "Invalid attendee email" error with some events in the "Create event (SyncBlocker) in cal 2" step

[skeltonsc]

Hello, thank you for this very cool little flow, but we are getting some strange errors. that I hope you can assist with?

Some of our meetings when syncing to google from outlook will fail with this error in the "Create event (SyncBlocker) in cal 2" step

{
"statusCode": 400,
"headers": {
"Cache-Control": "no-store, must-revalidate, no-cache, max-age=0",
"Pragma": "no-cache",
"Vary": "Origin,X-Origin,Referer",
"X-XSS-Protection": "0",
"X-Frame-Options": "SAMEORIGIN",
"X-Content-Type-Options": "nosniff",
"Alt-Svc": "h3=":443"; ma=2592000,h3-29=":443"; ma=2592000",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "true",
"x-ms-apihub-obo": "false",
"Date": "Tue, 13 Aug 2024 14:00:48 GMT",
"Content-Length": "231",
"Content-Type": "application/json",
"Expires": "Mon, 01 Jan 1990 00:00:00 GMT"
},
"body": {
"error": {
"errors": [
{
"domain": "global",
"reason": "invalid",
"message": "Invalid attendee email."
}
],
"code": 400,
"message": "Invalid attendee email."
}
}
}

a sample of one of the failed attendees "newEvent/attendees": "do-not-delete-this-attendee-or-sync-breaks@040000008200e00074c5b7101a82e00807e8081c00000000000000000000000000000000430000007643616c2d55696401000000373264736d3661696a69396b656b6736356b756c7572663361325f5232303234303630355430363030303040676f6f676c652e636f6d00.invalid"

[ezequiassouzamx]

Hello, adding to this thread, I shortened the "attendee email" which was originally longer than 255 characters, and the flow error didn't occur again.

The original attendee email was: @concat('do-not-delete-this-attendee-or-sync-breaks@', variables('eventId'), '.invalid').
I changed it to: @concat('d@', variables('eventId'), '.invalid').

I also see that the failed attendee email in your case has 266 character lengh, which seems to be the same error reason as mine. I hope it helps.

[skeltonsc]

hello, thats correct, I have shortened it as well as changing the two slice sections to count the correct values now

its now working correctly :)

slice(
split(item()?['requiredAttendees'], ';')[0],
43, // length of "do-not-delete-this-attendee-or-sync-breaks@"
sub(length(split(item()?['requiredAttendees'], ';')[0]), 8) // 8 is the length of ".invalid"
)

[MShekow]

There is now an updated flow available at https://github.com/MShekow/ng-outlook-google-calendar-sync/ which might fix your problem. The https://github.com/MShekow/outlook-google-calendar-sync flow has been deprecated and is no longer maintained.