Codeunit 6999 Outlook Add-In Services
src/Layers/W1/BaseApp/System/OutlookAddIn/OutlookAddInServices.Codeunit.al263 lines, Copyright (c) Microsoft Corporation. MIT
// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace System.Integration;using Microsoft.CRM.Outlook;using System.Text;using System.Utilities;/// <summary>/// The codeunit to provide internal services for Outlook Add-In code inside BaseApp./// </summary>/// <remarks>/// Code inspired from EmailOutlookAPIClient codeunit from 'Email - Outlook REST API' app./// </remarks>codeunit 6999 "Outlook Add-In Services"{ Access = Internal; trigger OnRun() begin end; var OutlookCategoryLbl: Label 'AL Outlook Add-In', Locked = true; // Please note UrlHelper cannot be used here as it does not provide right URL on-prem RetrieveEmailMeUriTxt: Label 'https://graph.microsoft.com/v1.0/me/messages/%1', Locked = true; RetrieveEmailAttachmentsUriTxt: Label 'https://graph.microsoft.com/v1.0/me/messages/%1/attachments', Locked = true; FailedToRetrieveEmailBodyErr: Label 'Could not retrieve the email. Please try again later.'; FailedToRetrieveEmailAttachmentsErr: Label 'Could not retrieve the email attachments. Please try again later.'; FailedToReadResponseContentErr: Label 'Something went wrong while reading the email. Please try again later.'; ConnectionErr: Label 'Could not connect to the email service. Please check your connection and try again later.'; TelemetryRetrievingMyEmailTxt: Label 'Retrieving my email.', Locked = true; TelemetryRetrievingMyEmailAttachmentsTxt: Label 'Retrieving email attachments.', Locked = true; UnexpectedResponseFormatErr: Label 'Something went wrong while reading the email. Please try again later.'; TelemetryUnexpectedResponseFormatTxt: Label 'Unexpected response format: expected property ''%1'' was not found.', Locked = true; /// <summary> /// Enables getting email and attachments for Outlook Add-In. /// </summary> /// <param name="ItemID">REST ID of email</param> /// <param name="TempExchangeObject">Temporary record for the email and attachments</param> /// <param name="Action">Action to be initiated for attachments</param> /// <param name="RecRef">Record reference for the record to which email/attachments</param> /// <param name="AccessToken">Access token for Graph API (callback token from platform)</param> [Scope('OnPrem')] procedure GetEmailAndAttachments(ItemID: Text[250]; var TempExchangeObject: Record "Exchange Object" temporary; "Action": Option InitiateSendToOCR,InitiateSendToIncomingDocuments,InitiateSendToWorkFlow,IntiateSendToAttachments; RecRef: RecordRef; AccessToken: SecretText) var Base64Convert: Codeunit "Base64 Convert"; TempBlob: Codeunit "Temp Blob"; StreamEmailContentText: InStream; StreamAttachmentContentText: InStream; ContentOutStream: OutStream; AttachmentsArray: JsonArray; AttachmentObject: JsonObject; MessageJson: JsonObject; AttachmentJson: JsonObject; BodyJson: JsonObject; Jtoken: JsonToken; hasAttachmentsToken: JsonToken; CurrentAttachment: JsonToken; SubjectToken: JsonToken; WebLinkToken: JsonToken; BodyContextText: Text; AttachmentContextText: Text; begin MessageJson := GetMessage(ItemID, AccessToken); GetRequiredJsonToken(MessageJson, 'subject', SubjectToken); GetRequiredJsonToken(MessageJson, 'webLink', WebLinkToken); GetRequiredJsonToken(MessageJson, 'hasAttachments', hasAttachmentsToken); GetRequiredJsonToken(MessageJson, 'body', JToken); BodyJson := JToken.AsObject(); GetRequiredJsonToken(BodyJson, 'content', JToken); BodyContextText := JToken.AsValue().AsText(); Clear(TempBlob); TempBlob.CreateOutStream(ContentOutStream, TextEncoding::UTF8); ContentOutStream.WriteText(BodyContextText); TempBlob.CreateInStream(StreamEmailContentText, TextEncoding::UTF8); TempExchangeObject.Init(); TempExchangeObject.Validate("Item ID", ItemID); TempExchangeObject.Validate(Type, TempExchangeObject.Type::Email); TempExchangeObject.Validate(Name, SubjectToken.AsValue().AsText()); TempExchangeObject.Validate(Owner, UserSecurityId()); TempExchangeObject.SetBody(BodyContextText); TempExchangeObject.SetContent(StreamEmailContentText); TempExchangeObject.SetViewLink(WebLinkToken.AsValue().AsText()); if not TempExchangeObject.Insert(true) then TempExchangeObject.Modify(true); if not hasAttachmentsToken.AsValue().AsBoolean() then exit; AttachmentJson := GetAttachments(ItemID, AccessToken); GetRequiredJsonToken(AttachmentJson, 'value', Jtoken); AttachmentsArray := Jtoken.AsArray(); foreach CurrentAttachment in AttachmentsArray do begin AttachmentObject := CurrentAttachment.AsObject(); TempExchangeObject.Init(); TempExchangeObject.Validate(Type, TempExchangeObject.Type::Attachment); TempExchangeObject.Validate("Parent ID", ItemID); TempExchangeObject.Validate(InitiatedAction, Action); TempExchangeObject.Validate(RecId, RecRef.RecordId()); GetRequiredJsonToken(AttachmentObject, 'id', Jtoken); TempExchangeObject.Validate("Item ID", Jtoken.AsValue().AsText()); GetRequiredJsonToken(AttachmentObject, 'name', Jtoken); TempExchangeObject.Validate(Name, Jtoken.AsValue().AsText()); GetRequiredJsonToken(AttachmentObject, 'contentType', Jtoken); TempExchangeObject.Validate("Content Type", Jtoken.AsValue().AsText()); GetRequiredJsonToken(AttachmentObject, 'isInline', Jtoken); TempExchangeObject.Validate(IsInline, Jtoken.AsValue().AsBoolean()); GetRequiredJsonToken(AttachmentObject, 'contentBytes', Jtoken); AttachmentContextText := Jtoken.AsValue().AsText(); Clear(TempBlob); TempBlob.CreateOutStream(ContentOutStream); Base64Convert.FromBase64(AttachmentContextText, ContentOutStream); TempBlob.CreateInStream(StreamAttachmentContentText); TempExchangeObject.SetContent(StreamAttachmentContentText); if not TempExchangeObject.Insert(true) then TempExchangeObject.Modify(true); end; end; /// <summary> /// Enables getting email body via Microsoft Graph for Outlook Add-In. /// </summary> /// <param name="ExternalMessageId">REST ID of email</param> /// <param name="AccessToken">Access token for Graph API (callback token from platform)</param> [Scope('OnPrem')] procedure GetEmailBodyViaGraph(ExternalMessageId: Text; AccessToken: SecretText): Text var ResponseJson: JsonObject; BodyJson: JsonObject; JToken: JsonToken; begin ResponseJson := GetMessage(ExternalMessageId, AccessToken); GetRequiredJsonToken(ResponseJson, 'body', JToken); BodyJson := JToken.AsObject(); GetRequiredJsonToken(BodyJson, 'content', JToken); exit(JToken.AsValue().AsText()); end; /// <summary> /// Checks if email has attachments via Microsoft Graph for Outlook Add-In. /// </summary> /// <param name="ExternalMessageId">REST ID of email</param> /// <param name="AccessToken">Access token for Graph API (callback token from platform)</param> [Scope('OnPrem')] procedure EmailHasAttachments(ExternalMessageId: Text[250]; AccessToken: SecretText): Boolean var ResponseJson: JsonObject; JToken: JsonToken; begin ResponseJson := GetMessage(ExternalMessageId, AccessToken); GetRequiredJsonToken(ResponseJson, 'hasAttachments', JToken); exit(JToken.AsValue().AsBoolean()); end; [NonDebuggable] local procedure CreateRequest(Method: Text; RequestUri: Text; AccessToken: SecretText; var MailHttpRequestMessage: HttpRequestMessage) var MailRequestHeaders: HttpHeaders; begin MailHttpRequestMessage.Method(Method); MailHttpRequestMessage.SetRequestUri(RequestUri); MailHttpRequestMessage.GetHeaders(MailRequestHeaders); MailRequestHeaders.Add('Authorization', SecretStrSubstNo('Bearer %1', AccessToken)); end; [NonDebuggable] local procedure SendRequest(var MailHttpRequestMessage: HttpRequestMessage; var MailHttpResponseMessage: HttpResponseMessage) var MailHttpClient: HttpClient; begin if not MailHttpClient.Send(MailHttpRequestMessage, MailHttpResponseMessage) then Error(ConnectionErr); end; /// <summary> /// Enables getting full information about the email via Microsoft Graph for Outlook Add-In. /// </summary> /// <remarks> /// Based on this call https://learn.microsoft.com/en-us/graph/api/message-get. /// </remarks> /// <param name="ExternalMessageId">REST ID of email</param> /// <param name="AccessToken">Access token for Graph API (callback token from platform)</param> local procedure GetMessage(ExternalMessageId: Text; AccessToken: SecretText): JsonObject var MailHttpRequestMessage: HttpRequestMessage; MailHttpResponseMessage: HttpResponseMessage; MailRequestHeaders: HttpHeaders; ResponseJson: JsonObject; ResponseJsonText: Text; RequestUri: Text; begin Session.LogMessage('0000QGW', TelemetryRetrievingMyEmailTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', OutlookCategoryLbl); RequestUri := StrSubstNo(RetrieveEmailMeUriTxt, ExternalMessageId); CreateRequest('GET', RequestUri, AccessToken, MailHttpRequestMessage); MailHttpRequestMessage.GetHeaders(MailRequestHeaders); MailRequestHeaders.Add('Prefer', 'outlook.body-content-type="text"'); SendRequest(MailHttpRequestMessage, MailHttpResponseMessage); if MailHttpResponseMessage.HttpStatusCode <> 200 then begin Session.LogMessage('0000QGX', FailedToRetrieveEmailBodyErr, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', OutlookCategoryLbl); Error(FailedToRetrieveEmailBodyErr); end; if not MailHttpResponseMessage.Content.ReadAs(ResponseJsonText) then Error(FailedToReadResponseContentErr); if not ResponseJson.ReadFrom(ResponseJsonText) then Error(FailedToReadResponseContentErr); exit(ResponseJson); end; /// <summary> /// Enables getting full information about the email attachments via Microsoft Graph for Outlook Add-In. /// </summary> /// <remarks> /// Based on this call https://learn.microsoft.com/en-us/graph/api/message-list-attachments. /// </remarks> /// <param name="ExternalMessageId">REST ID of email</param> /// <param name="AccessToken">Access token for Graph API (callback token from platform)</param> local procedure GetAttachments(ExternalMessageId: Text; AccessToken: SecretText): JsonObject var MailHttpRequestMessage: HttpRequestMessage; MailHttpResponseMessage: HttpResponseMessage; MailRequestHeaders: HttpHeaders; ResponseJson: JsonObject; ResponseJsonText: Text; RequestUri: Text; begin Session.LogMessage('0000QGY', TelemetryRetrievingMyEmailAttachmentsTxt, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', OutlookCategoryLbl); RequestUri := StrSubstNo(RetrieveEmailAttachmentsUriTxt, ExternalMessageId); CreateRequest('GET', RequestUri, AccessToken, MailHttpRequestMessage); MailHttpRequestMessage.GetHeaders(MailRequestHeaders); MailRequestHeaders.Add('Prefer', 'outlook.body-content-type="text"'); SendRequest(MailHttpRequestMessage, MailHttpResponseMessage); if MailHttpResponseMessage.HttpStatusCode <> 200 then begin Session.LogMessage('0000QGZ', FailedToRetrieveEmailAttachmentsErr, Verbosity::Normal, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', OutlookCategoryLbl); Error(FailedToRetrieveEmailAttachmentsErr); end; if not MailHttpResponseMessage.Content.ReadAs(ResponseJsonText) then Error(FailedToReadResponseContentErr); if not ResponseJson.ReadFrom(ResponseJsonText) then Error(FailedToReadResponseContentErr); exit(ResponseJson); end; local procedure GetRequiredJsonToken(JsonObj: JsonObject; PropertyName: Text; var JToken: JsonToken) begin if not JsonObj.Get(PropertyName, JToken) then begin Session.LogMessage('0000TCS', StrSubstNo(TelemetryUnexpectedResponseFormatTxt, PropertyName), Verbosity::Error, DataClassification::SystemMetadata, TelemetryScope::ExtensionPublisher, 'Category', OutlookCategoryLbl); Error(UnexpectedResponseFormatErr); end; end;}