How to open any document in OneDrive from Business Central

https://github.com/juancamilo0519/OpenInOneDrive

 

The following post explains how to open any document, in this case a Sales Order, from OneDrive in order to immediately share it with our work team:

By pressing the Open in Onedrive button, Business Central will ask if we agree to use our OneDrive in our environment.

Finally, our document opens directly from OneDrive and we can share it with our work team.

Below is the source code:

https://github.com/juancamilo0519/OpenInOneDrive

//Whith this solution you can copy the file to your bussiness central folder in OneDrive and open it in a new windows.

pageextension 50100 SalesOrderExt extends "Sales Order"

{

    actions

    {

        addlast("O&rder")

        {

            action(OpenInOneDrive)

            {

                ApplicationArea = all;

                Caption = 'Open in One Drive';

                Image = Cloud;

                Promoted = true;

                PromotedCategory = Category6;

                PromotedOnly = true;

                trigger OnAction()

                var

                    TempBlob: Codeunit "Temp Blob";

                    DocumentServiceMgt: Codeunit "Document Service Management";

                    InStr: InStream;

                begin

                    GetSalesOrder(TempBlob);

                    TempBlob.CreateInStream(InStr);

                    DocumentServiceMgt.OpenInOneDrive(StrSubstNo(SalesOrderName, Rec."No."), '.pdf', InStr);

                end;

            }

        }

    }

    var

        ShareOptionsEnable: Boolean;

        SalesOrderName: Label 'Sales Order %1';

    local procedure GetSalesOrder(var TempBlob: Codeunit "Temp Blob")

    var

        ReportSelections: Record "Report Selections";

        RecRef: RecordRef;

    begin

        RecRef.GetTable(Rec);

        RecRef.SetRecFilter();

        ReportSelections.GetPdfReportForCust(TempBlob, ReportSelections.Usage::"S.Order", RecRef, rec."Sell-to Customer No.");

    end;

}