Yes, our documentation needs to be much clearer on how to retrieve the Item. Please try https://outlook.office365.com/api/v1.0/me/messages/{messageid}/attachments/{AttachmentId}?$expand=Microsoft.OutlookServices.ItemAttachment/Item and let me know if this works for you.
As suggested by Niels V try using the Office365-REST-Python-Client. The client implements the Sharepoint REST API. Here’s an example of what you are trying to do: from office365.runtime.auth.authentication_context import AuthenticationContext from office365.sharepoint.client_context import ClientContext from office365.sharepoint.files.file import File url=”https://yoursharepointsite.com/sites/documentsite” username=”yourusername” password = ‘yourpassword’ relative_url=”/sites/documentsite/Documents/filename.xlsx” This section is straight from the github README.md using the ClientContext … Read more
Instead of a client_secret in your request body, you need a client_assertion. This is a bit more complex, but it’s the reason you need that certificate. Basically you need to build a JSON Web Token and sign it with your certificate using a SHA256 hash. The token is going to look something like this: Header: … Read more
At present we only allow access to mail, calendar and contacts belonging to the authenticated user. So, your scenario of an admin accessing the conf. room calendar is not supported at this time. Access to resources belonging to other users e.g. conf. room calendar is on our roadmap to support but we don’t yet have … Read more
We are actively working on OAuth support for IMAP connections to O365 mailboxes. We will make a public announcement once the same is available.
Since finding the Union of several ranges is a quite usefull function on its own, I use a LAMBDA to do that. The output of that can then be passed to UNIQUE The Lambda, which I call, unimaginatively, UNION =LAMBDA(tabl1, tabl2, LET(rowindex, SEQUENCE(ROWS(tabl1)+ROWS(tabl2)), colindex, SEQUENCE(1,COLUMNS(tabl1)), IF(rowindex<=ROWS(tabl1), INDEX(tabl1,rowindex,colindex), INDEX(tabl2,rowindex-ROWS(tabl1),colindex) ) ) ) Then =UNIQUE(Union(tblFruits1[Name],tblFruits2[Name])) gives the … Read more
Fixed a few typos in the working code above: MailMessage msg = new MailMessage(); msg.To.Add(new MailAddress(“[email protected]”, “SomeOne”)); msg.From = new MailAddress(“[email protected]”, “You”); msg.Subject = “This is a Test Mail”; msg.Body = “This is a test message using Exchange OnLine”; msg.IsBodyHtml = true; SmtpClient client = new SmtpClient(); client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential(“your user … Read more
There may be a better approach, but here is one using TEXTJOIN and FILTERXML to create an array that you can call UNIQUE on: =SORT(UNIQUE(FILTERXML(“<t><s>”&TEXTJOIN(“</s><s>”,TRUE,A1:C6)&”</s></t>”,”//s”)))