Codeunit 6999 Outlook Add-In Services

Base Application, System.Integration

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;}