I have a SQL table that gets updated every night with instructor's schedule. it has many fields but the main fields are:
- EventName
- OrderID
- TeacherName
- ProgramName
- SchoolName
- StartDateTime
- EndDateTime
- CreateDate
- UpdateDate
I created a flow that writes that information from SQL to an Outlook Calendar anytime a new event is added to the table and that works great, I've tested it and have no problem. The problem i do have is that sometimes the events are changed or deleted so i need to update the event on the outlook calendar to either update with the new date or remove the event if it has been deleted. i cant get this to work. this is what i did .
The part on the left (Create) works Fine . the part on the left fails every time . i think it may have to do with the ID because i don't understand how to get the ID of an existing calendar item to update . but am not sure.
the error says bad request and this is the output
{
"statusCode": 400,
"headers": {
"Pragma": "no-cache",
"x-ms-request-id": "1bb1d023-7338-4cf9-88bd-2ada11604923",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"X-Content-Type-Options": "nosniff",
"X-Frame-Options": "DENY",
"Timing-Allow-Origin": "*",
"x-ms-apihub-cached-response": "false",
"Cache-Control": "no-store, no-cache",
"Date": "Fri, 23 Aug 2019 06:59:31 GMT",
"Set-Cookie": "ARRAffinity=48c1aab958578a8842b7561455dec5acf0c7064c05bffd287bd301d60aed5721;Path=/;HttpOnly;Domain=office365-cus.azconn-cus.p.azurewebsites.net",
"Content-Length": "231",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"status": 400,
"message": "Id is malformed.\r\nclientRequestId: b0fe6676-b085-4c67-8208-1477cf1d544e\r\nserviceRequestId: 1bb1d023-7338-4cf9-88bd-2ada11604923",
"source": "office365-cus.azconn-cus.p.azurewebsites.net"
}
}
