{"id":1060,"date":"2023-08-11T06:55:26","date_gmt":"2023-08-11T06:55:26","guid":{"rendered":"https:\/\/fredborg.org\/?p=1060"},"modified":"2023-08-11T11:32:15","modified_gmt":"2023-08-11T11:32:15","slug":"data-is-king-part-1-send-data-from-business-central-to-azure","status":"publish","type":"post","link":"https:\/\/fredborg.org\/?p=1060","title":{"rendered":"Data is King: Part 1 Send data from Business Central to Azure"},"content":{"rendered":"\n

There is no question that in our world data is king. Still, for many of us, the problem is that we have so much data in so many different systems and different formats, that we quickly can lose track. We might therefore not get the full potential out of all our data, in this blog series, I will cover some of the tools that Microsoft has made available to us in Azure to handle data. I will also cover some of the basics of how you can structure your data so you can use it most effectively. <\/p>\n\n\n\n

Sending Data from Business Central<\/h2>\n\n\n\n

In this post, I will start by going through a way that we can set up a dynamic way in our Business Central to send data to Azure Blob Storage, which we will work with later on. What we are going to need for this setup is an Azure Function, an Azure storage account, and some AL code. What we are going to be creating is a way that we can set up if a field on a record is modified it will trigger a generic JSON file to be created in an Azure blob storage. This result could also be obtained using WebHooks in Business Central which you can read about here<\/a> but that would require us to create an API page for each record that we wish to export.<\/p>\n\n\n\n

We are going to need 4 tables, the first table is a setup table where we can set up our Azure function URL and also a Boolean to turn our module on, my table and page look as follows:<\/p>\n\n\n

\ntable 50103 "DEF Data Export Setup"\n{\n    Caption = 'Data Export Setup';\n    DataClassification = CustomerContent;\n\n    fields\n    {\n        field(1; "Code"; Code[10])\n        {\n            Caption = 'Code';\n        }\n        field(2; "Azure Function URL"; Text[250])\n        {\n            Caption = 'Azure Function URL';\n        }\n        field(3; "Azure Function Token"; Text[250])\n        {\n            Caption = 'Azure Function Token';\n        }\n        field(4; "Enable Send on Triggers"; Boolean)\n        {\n            Caption = 'Enable Send on Triggers';\n        }\n    }\n    keys\n    {\n        key(PK; "Code")\n        {\n            Clustered = true;\n        }\n    }\n}\n\n<\/pre><\/div>\n\n
\npage 50101 "DEF Data Export Setup"\n{\n    ApplicationArea = All;\n    Caption = 'Data Export Setup';\n    PageType = Card;\n    SourceTable = "DEF Data Export Setup";\n    UsageCategory = Administration;\n\n    layout\n    {\n        area(content)\n        {\n            group(General)\n            {\n                Caption = 'General';\n\n                field("Azure Function URL"; Rec."Azure Function URL")\n                {\n                    ToolTip = 'Specifies the value of the Azure Function URL field.';\n                }\n                field("Azure Function Token"; Rec."Azure Function Token")\n                {\n                    ToolTip = 'Specifies the value of the Azure Function Token field.';\n                }\n                field("Enable Send on Triggers"; Rec."Enable Send on Triggers")\n                {\n                    ToolTip = 'Specifies the value of the Enable Send on Triggers field.';\n                }\n            }\n        }\n    }\n\n    trigger OnOpenPage()\n    begin\n        if not Rec.Get() then\n            Rec.Insert();\n    end;\n}\n\n<\/pre><\/div>\n\n\n
\"\"<\/figure>\n\n\n\n
Next, we need a way to set up which records and which fields should trigger a data export, for this purpose I have created two tables “Data Export Mapping Header” and “Data Export Mapping Lines” <\/p>\n\n\n
\ntable 50101 "DEFData Export Mapping Header"\n{\n    Caption = 'Data Export Mapping Header';\n    DataClassification = CustomerContent;\n\n    fields\n    {\n        field(1; "Table No."; Integer)\n        {\n            Caption = 'Table No.';\n            DataClassification = CustomerContent;\n            TableRelation = AllObj."Object ID" where("Object Type" = const(Table));\n        }\n        field(2; "Table Name"; Text[250])\n        {\n            Caption = 'Table Name';\n            FieldClass = FlowField;\n            CalcFormula = lookup(AllObj."Object Name" where("Object ID" = field("Table No.")));\n            Editable = false;\n        }\n        field(3; "Json Array Name"; Text[250])\n        {\n            Caption = 'Json Array Name';\n            DataClassification = CustomerContent;\n        }\n        field(4; "Json Object Name"; Text[250])\n        {\n            Caption = 'Json Object Name';\n            DataClassification = CustomerContent;\n        }\n    }\n    keys\n    {\n        key(PK; "Table No.")\n        {\n            Clustered = true;\n        }\n    }\n}\n\n<\/pre><\/div>\n\n
\ntable 50102 "DEF Data Export Mapping Lines"\n{\n    Caption = 'Data Export Mapping Lines';\n    DataClassification = CustomerContent;\n\n    fields\n    {\n        field(1; "Field No."; Integer)\n        {\n            Caption = 'Field No.';\n            DataClassification = CustomerContent;\n            TableRelation = Field."No." where(TableNo = field("Table No."));\n        }\n        field(2; "Field Name"; Text[250])\n        {\n            Caption = 'Field Name';\n            Editable = false;\n            FieldClass = FlowField;\n            CalcFormula = lookup(Field.FieldName where(TableNo = field("Table No."), "No." = field("Field No.")));\n\n        }\n        field(3; "Table No."; Integer)\n        {\n            Caption = 'Table No.';\n            DataClassification = CustomerContent;\n            Editable = false;\n        }\n    }\n    keys\n    {\n        key(PK; "Field No.", "Table No.")\n        {\n            Clustered = true;\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
And I have created 3 pages a sub-page for the lines:<\/p>\n\n\n
\npage 50105 "DEF Data Export Mapping Lines"\n{\n    ApplicationArea = All;\n    Caption = 'Data Export Mapping Lines';\n    PageType = ListPart;\n    SourceTable = "DEF Data Export Mapping Lines";\n\n    layout\n    {\n        area(content)\n        {\n            repeater(General)\n            {\n                field("Field No."; Rec."Field No.")\n                {\n                    ToolTip = 'Specifies the value of the Field No. field.';\n                }\n                field("Field Name"; Rec."Field Name")\n                {\n                    ToolTip = 'Specifies the value of the Field Name field.';\n                }\n            }\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
A card page:<\/p>\n\n\n
\npage 50106 "DEF Data Export Mapping Card"\n{\n    ApplicationArea = All;\n    Caption = 'Data Export Mapping Card';\n    PageType = Card;\n    SourceTable = "DEFData Export Mapping Header";\n    UsageCategory = Administration;\n\n    layout\n    {\n        area(content)\n        {\n            group(General)\n            {\n                Caption = 'General';\n\n                field("Table No."; Rec."Table No.")\n                {\n                    ToolTip = 'Specifies the value of the Table No. field.';\n                }\n                field("Table Name"; Rec."Table Name")\n                {\n                    ToolTip = 'Specifies the value of the Table Name field.';\n                }\n                field("Json Array Name"; Rec."Json Array Name")\n                {\n                    ToolTip = 'Specifies the value of the Json Array Name field.';\n                }\n                field("Json Object Name"; Rec."Json Object Name")\n                {\n                    ToolTip = 'Specifies the value of the Json Object Name field.';\n                }\n            }\n            part(lines; "DEF Data Export Mapping Lines")\n            {\n                SubPageLink = "Table No." = field("Table No.");\n            }\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
and a list page:<\/p>\n\n\n
\npage 50103 "DEFData Export Mapping List"\n{\n    ApplicationArea = All;\n    Caption = 'Data Export Mapping List';\n    PageType = List;\n    SourceTable = "DEFData Export Mapping Header";\n    UsageCategory = Administration;\n    CardPageId = "DEF Data Export Mapping Card";\n    Editable = false;\n\n    layout\n    {\n        area(content)\n        {\n            repeater(General)\n            {\n                field("Table No."; Rec."Table No.")\n                {\n                    ToolTip = 'Specifies the value of the Table No. field.';\n                }\n                field("Table Name"; Rec."Table Name")\n                {\n                    ToolTip = 'Specifies the value of the Table Name field.';\n                }\n                field("Json Array Name"; Rec."Json Array Name")\n                {\n                    ToolTip = 'Specifies the value of the Json Array Name field.';\n                }\n                field("Json Object Name"; Rec."Json Object Name")\n                {\n                    ToolTip = 'Specifies the value of the Json Object Name field.';\n                }\n            }\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
The idea here is that you choose which table and fields should trigger an export, which fields you wish to export, and what you wish the name of your JSON objects and JSON arrays should be once they have been exported.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Next, we will need a log table and a page, which is used as a buffer table for our job queue<\/p>\n\n\n
\ntable 50104 "DEFData Export Log"\n{\n    Caption = 'Data Export Log';\n    DataClassification = CustomerContent;\n\n    fields\n    {\n        field(1; ID; Guid)\n        {\n            Caption = 'ID';\n        }\n        field(2; "Table ID"; Integer)\n        {\n            Caption = 'Table ID';\n        }\n        field(3; "RecordID"; RecordId)\n        {\n            Caption = 'RecordID';\n        }\n        field(4; SysId; Guid)\n        {\n            Caption = 'Sys ID';\n        }\n    }\n    keys\n    {\n        key(PK; ID)\n        {\n            Clustered = true;\n        }\n    }\n}\n\n<\/pre><\/div>\n\n
\npage 50102 "DEFData Export Log"\n{\n    ApplicationArea = All;\n    Caption = 'Data Export Log';\n    PageType = List;\n    SourceTable = "DEFData Export Log";\n    UsageCategory = Administration;\n    Editable = false;\n\n    layout\n    {\n        area(content)\n        {\n            repeater(General)\n            {\n                field(ID; Rec.ID)\n                {\n                    ToolTip = 'Specifies the value of the ID field.';\n                }\n                field("RecordID"; Rec."RecordID")\n                {\n                    ToolTip = 'Specifies the value of the RecordID field.';\n                }\n                field(SysId; Rec.SysId)\n                {\n                    ToolTip = 'Specifies the value of the Sys ID field.';\n                }\n                field("Table ID"; Rec."Table ID")\n                {\n                    ToolTip = 'Specifies the value of the Table ID field.';\n                }\n            }\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
Next, we need our codeunit which is where all the magic happens.<\/p>\n\n\n
\ncodeunit 50104 "DEF JsonExport"\n{\n    trigger OnRun()\n    var\n        ExportLog: Record "DEFData Export Log";\n        RecordRef: RecordRef;\n    begin\n        if ExportLog.FindSet() then\n            repeat\n                RecordRef.Open(ExportLog."Table ID");\n                RecordRef.GetBySystemId(ExportLog.SysId);\n                Rec2Json(RecordRef);\n                SendJSonToAzureFunction(GetJsonString(RecordRef, ExportLog.SysId));\n                ExportLog.Delete();\n                RecordRef.Close();\n            until ExportLog.Next() = 0;\n    end;\n\n    procedure Rec2Json(Rec: Variant)\n    var\n        ExportMappingHeaderSetup: Record "DEFData Export Mapping Header";\n        ExportMappingSetupLines: Record "DEF Data Export Mapping Lines";\n        FieldRef: FieldRef;\n        JObject: JsonObject;\n        RecJObject: JsonObject;\n        RecordRef: RecordRef;\n        i: Integer;\n        OutString: Text;\n    begin\n        RecordRef.GetTable(Rec);\n        if ExportMappingHeaderSetup.get(RecordRef.Number) then begin\n            ExportMappingSetupLines.setrange("Table No.", ExportMappingHeaderSetup."Table No.");\n            if ExportMappingSetupLines.FindSet() then\n                repeat\n                    FieldRef := RecordRef.FieldIndex(ExportMappingSetupLines."Field No.");\n                    JObject.Add(DelChr(FieldRef.Name(), '=', ' \/.-*+'), FieldToJsonValue(FieldRef));\n                until ExportMappingSetupLines.Next() = 0;\n            RecJObject.Add(ExportMappingHeaderSetup."Json Object Name", JObject);\n        end else begin\n            for i := 1 to RecordRef.FieldCount do begin\n                FieldRef := RecordRef.FieldIndex(i);\n                JObject.Add(DelChr(FieldRef.Name(), '=', ' \/.-*+'), FieldToJsonValue(FieldRef));\n            end;\n            RecJObject.Add(DelChr(RecordRef.Name(), '=', ' \/.-*+'), JObject);\n        end;\n\n        JArray.Add(RecJObject);\n    end;\n\n    procedure GetJsonString(Rec: Variant; SysId: guid): Text;\n    var\n        ExportMappingHeaderSetup: Record "DEFData Export Mapping Header";\n        Result: Text;\n        RecordRef: RecordRef;\n    begin\n        RecordRef.GetTable(Rec);\n        if ExportMappingHeaderSetup.get(RecordRef.Number) then\n            ResultJObject.Add(ExportMappingHeaderSetup."Json Array Name", JArray)\n        else\n            ResultJObject.Add(DelChr(RecordRef.Name(), '=', ' \/.-*+') + 's', JArray);\n        ResultJObject.Add('Type', RecordRef.Name);\n        ResultJObject.Add('Id', format(SysId));\n        ResultJObject.WriteTo(Result);\n        Clear(ResultJObject);\n        Clear(JArray);\n        exit(Result);\n    end;\n\n    procedure SendJSonToAzureFunction(payload: Text)\n    var\n        DataExportSetup: Record "DEF Data Export Setup";\n        AzureFunctions: Codeunit "Azure Functions";\n        AzureFunctionsAuthentication: Codeunit "Azure Functions Authentication";\n        AzureFunctionsResponse: Codeunit "Azure Functions Response";\n        IAzureFunctionsAuthentication: Interface "Azure Functions Authentication";\n        Response: HttpResponseMessage;\n        QurreyDic: Dictionary of [text, text];\n        Result: Text;\n        error: JsonToken;\n        Jobject: JsonObject;\n    begin\n        DataExportSetup.Get();\n        IAzureFunctionsAuthentication := AzureFunctionsAuthentication.CreateCodeAuth(DataExportSetup."Azure Function URL", DataExportSetup."Azure Function Token");\n        AzureFunctionsResponse := AzureFunctions.SendPostRequest(IAzureFunctionsAuthentication, payload, 'application\/json');\n        AzureFunctionsResponse.GetHttpResponse(Response);\n        if not response.IsSuccessStatusCode() then\n            error(Response.ReasonPhrase);\n    end;\n\n    local procedure FieldToJsonValue(FieldRef: FieldRef): JsonValue\n    var\n        FieldValue: JsonValue;\n        BoolValue: Boolean;\n        IntValue: Integer;\n        DecimalValue: Decimal;\n        DateValue: Date;\n        TimeValue: Time;\n        DateTimeValue: DateTime;\n        DurationValue: Duration;\n        BigIntegerValue: BigInteger;\n        GuidValue: Guid;\n        RecordRefField: RecordRef;\n    begin\n        if (FieldRef.Class() = FieldClass::FlowField) then\n            FieldRef.CalcField();\n\n\n        case FieldRef.Type() of\n            FieldType::Boolean:\n                begin\n                    BoolValue := FieldRef.Value();\n                    FieldValue.SetValue(BoolValue);\n                end;\n            FieldType::Integer:\n                begin\n                    IntValue := FieldRef.Value();\n                    FieldValue.SetValue(IntValue);\n                end;\n            FieldType::Decimal:\n                begin\n                    DecimalValue := FieldRef.Value();\n                    FieldValue.SetValue(DecimalValue);\n                end;\n            FieldType::Date:\n                begin\n                    DateValue := FieldRef.Value();\n                    FieldValue.SetValue(DateValue);\n                end;\n            FieldType::Time:\n                begin\n                    TimeValue := FieldRef.Value();\n                    FieldValue.SetValue(TimeValue);\n                end;\n            FieldType::DateTime:\n                begin\n                    DateTimeValue := FieldRef.Value();\n                    FieldValue.SetValue(DateTimeValue);\n                end;\n            FieldType::Duration:\n                begin\n                    DurationValue := FieldRef.Value();\n                    FieldValue.SetValue(DurationValue);\n                end;\n            FieldType::BigInteger:\n                begin\n                    BigIntegerValue := FieldRef.Value();\n                    FieldValue.SetValue(BigIntegerValue);\n                end;\n            FieldType::Guid:\n                begin\n                    GuidValue := FieldRef.Value();\n                    FieldValue.SetValue(GuidValue);\n                end;\n            else\n                FieldValue.SetValue(Format(FieldRef.Value()));\n        end;\n\n        exit(FieldValue);\n    end;\n\n    var\n        ResultJObject: JsonObject;\n        JArray: JsonArray;\n}\n\n<\/pre><\/div>\n\n\n
First off I would like to give a shout-out to IVAN SINGLETO<\/a>N<\/a> for his blog post about turning any record in Business Central into a JSON object, I have been heavily inspired by his post. The last thing that we will need is a codeuint that subscribes to our global modify trigger.<\/p>\n\n\n
\ncodeunit 50101 "DEF GlobalSubscriber"\n{\n    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Global Triggers", 'OnDatabaseModify', '', false, false)]\n    local procedure OnGlobalModify(RecRef: RecordRef)\n    var\n        DataExportSetup: Record "DEF Data Export Setup";\n        ExportLog: Record "DEFData Export Log";\n        ExportMappingHeaderSetup: Record "DEFData Export Mapping Header";\n        ExportMappingSetupLines: Record "DEF Data Export Mapping Lines";\n        Fieldef: FieldRef;\n        xFieldef: FieldRef;\n        xRecRef: RecordRef;\n    begin\n        if not DataExportSetup.get() then\n            exit;\n        if not DataExportSetup."Enable Send on Triggers" then\n            exit;\n        if not ExportMappingHeaderSetup.Get(RecRef.Number) then\n            exit;\n\n        ExportMappingSetupLines.SetRange("Table No.", RecRef.Number);\n        xRecRef.Open(RecRef.Number, false, RecRef.CurrentCompany);\n        xRecRef.Get(RecRef.RecordId);\n        if ExportMappingSetupLines.FindSet() then\n            repeat\n                Fieldef := RecRef.Field(ExportMappingSetupLines."Field No.");\n                xFieldef := xRecRef.Field(ExportMappingSetupLines."Field No.");\n                if xFieldef.Value <> Fieldef.Value then begin\n                    Fieldef := RecRef.Field(RecRef.SystemIdNo);\n                    ExportLog.SetRange(SysId, Fieldef.Value);\n                    if ExportLog.FindFirst() then\n                        exit;\n                    ExportLog.ID := CreateGuid();\n                    ExportLog.RecordID := RecRef.RecordId;\n                    Fieldef := RecRef.Field(RecRef.SystemIdNo);\n                    ExportLog.SysId := Fieldef.Value;\n                    ExportLog."Table ID" := RecRef.Number;\n                    ExportLog.insert();\n                end;\n            until ExportMappingSetupLines.Next() = 0;\n        xRecRef.Close();\n\n    end;\n\n\n    [EventSubscriber(ObjectType::Codeunit, Codeunit::"Global Triggers", 'GetDatabaseTableTriggerSetup', '', false, false)]\n    local procedure GetDatabaseTableTriggerSetup(TableId: Integer; var OnDatabaseInsert: Boolean; var OnDatabaseModify: Boolean; var OnDatabaseDelete: Boolean)\n    var\n        ExportMappingHeaderSetup: Record "DEFData Export Mapping Header";\n    begin\n        if ExportMappingHeaderSetup.Get(TableId) then begin\n            OnDatabaseInsert := true;\n            OnDatabaseModify := true;\n            OnDatabaseDelete := true;\n        end;\n\n    end;\n}\n\n\n<\/pre><\/div>\n\n\n
And that is it you will now need to set up codeuint 50104 to run in a job queue as often as you wish to send data.<\/p>\n\n\n\n
The next thing that we need to do is create our Azure Blob storage, to do so head over to portal.azure.com<\/a> and search for Storage accounts <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
And create a new storage account, once your storage account has been created go to Containers, and create a new container, mine is called frombc.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
<\/p>\n\n\n\n
Now start your visual studio, and create an HTTP triggered Azure Function<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Once the Azure Function has been created, go to Tools->NuGet Package Manager->Mange NuGet Packages for Solution, and make sure the following NuGet packages are installed Azure.Storage.Blobs<\/strong>, Microsoft.Azure.WebJobs.Extensions.Storage<\/strong>, Microsoft.NET.Sdk.Functions<\/strong><\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Next, replace the code in your Azure function with the following.<\/p>\n\n\n
\nusing System;\nusing System.IO;\nusing System.Threading.Tasks;\nusing Microsoft.AspNetCore.Mvc;\nusing Microsoft.Azure.WebJobs;\nusing Microsoft.Azure.WebJobs.Extensions.Http;\nusing Microsoft.AspNetCore.Http;\nusing Microsoft.Extensions.Logging;\nusing Azure.Storage.Blobs;\nusing Newtonsoft.Json;\nusing System.Collections.Generic;\n\nnamespace UploadToBlob\n{\n    public static class BlobMangement\n    {\n        [FunctionName(nameof(UploadToBlob))]\n        public static async Task<IActionResult> UploadToBlob(\n            [HttpTrigger(AuthorizationLevel.Function, "post", Route = null)] HttpRequest req,\n            ILogger log)\n        {\n            string requestBody = String.Empty;\n            using (StreamReader streamReader = new StreamReader(req.Body))\n            {\n                requestBody = await streamReader.ReadToEndAsync();\n            }\n\n            dynamic data = JsonConvert.DeserializeObject(requestBody);\n            string folder = data. Type;\n            string id = data.Id;\n\n            string Connection = Environment.GetEnvironmentVariable("AzureWebJobsStorage");\n            string containerName = Environment.GetEnvironmentVariable("ContainerName");\n            var blobClient = new BlobContainerClient(Connection, containerName);\n            var blob = blobClient.GetBlobClient(folder + "\/"+id+".json");\n            var stream = new MemoryStream();\n            var writer = new StreamWriter(stream);\n            writer.Write(requestBody);\n            writer.Flush();\n            stream.Position = 0;\n            await blob.UploadAsync(stream,true);\n            return new OkObjectResult("file uploaded successfylly");\n        }\n    }\n}\n\n<\/pre><\/div>\n\n\n
What this code does, is it takes a POST request reads the body, takes whatever is written in the Type element and creates a folder with that name in your blob storage, and then creates a JSON file with a GUID as the name and the payload from the post request, if you wish to try this out locally you will have to open up the file local.settings.json and change the file to the following:<\/p>\n\n\n
\n{\n    "IsEncrypted": false,\n  "Values": {\n    "AzureWebJobsStorage": "{{Connection string to blob}}",\n    "ContainerName": "frombc",\n    "FUNCTIONS_WORKER_RUNTIME": "dotnet"\n  }\n}\n<\/pre><\/div>\n\n\n
To get your connection string to your blob storage, go to your Azure portal, Access keys,<\/strong> and copy the connection string.<\/p>\n\n\n\n
 <\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
Once you publish your Azure Function to Azure you must change some configurations, you must change AzureWebJobsStorage <\/strong>to your blob connection string and you must add your ContainerName<\/strong>.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
And that is it, your Business Central will now start sending data to your Azure Blob Storage, and every time a new record type is sent it will create a new folder.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
And inside these folders, you will see all the files with the data that you have set up in Business Central.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
My Customer contains:<\/p>\n\n\n
\n{\n    "Customers": [\n        {\n            "Customer": {\n                "No": "10000",\n                "Name": "Kontorcentralen A\/S d",\n                "Address2": ""\n            }\n        }\n    ],\n    "Type": "Customer"\n}\n<\/pre><\/div>\n\n\n
Because that is what I set up in my mapping in Business Central.<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
You should, of course, modify the code so that it fits your needs, maybe you do not want it to send the record every time, a field has been changed, but only once you perform a certain action, or maybe once a day; that is entirely up to you, also if you look at the codeuint JsonExport, you will see that in the function Rec2Json<\/strong>, if you run it on a record that is not set up, it will export all the fields in your table, which could be used if you wish to have a complete backup of your tables stored in another system. That was it for this post, in the next post we are going to take a look at what we can do with our data once we have it in Azure, until next time stay safe.<\/p>\n","protected":false},"excerpt":{"rendered":"
There is no question that in our world data is king. Still, for many of us, the problem is that…  Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":1061,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11,5],"tags":[],"class_list":["post-1060","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","category-business-central","shapla-grid-item"],"yoast_head":"\nData is King: Part 1 Send data from Business Central to Azure - Fredborg<\/title>\n<meta name=\"description\" content=\"Data is king. Still, for many of us, the problem is that we have so much data in so many different systems and different formats.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fredborg.org\/?p=1060\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Data is King: Part 1 Send data from Business Central to Azure - Fredborg\" \/>\n<meta property=\"og:description\" content=\"Data is king. Still, for many of us, the problem is that we have so much data in so many different systems and different formats.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fredborg.org\/?p=1060\" \/>\n<meta property=\"og:site_name\" content=\"Fredborg\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-11T06:55:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-11T11:32:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header-1024x576.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dfredborg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dfredborg\" \/>\n<meta name=\"twitter:site\" content=\"@dfredborg\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dfredborg\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fredborg.org\/?p=1060#article\",\"isPartOf\":{\"@id\":\"https:\/\/fredborg.org\/?p=1060\"},\"author\":{\"name\":\"dfredborg\",\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"headline\":\"Data is King: Part 1 Send data from Business Central to Azure\",\"datePublished\":\"2023-08-11T06:55:26+00:00\",\"dateModified\":\"2023-08-11T11:32:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fredborg.org\/?p=1060\"},\"wordCount\":941,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"image\":{\"@id\":\"https:\/\/fredborg.org\/?p=1060#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header.png\",\"articleSection\":[\"Azure\",\"Business Central\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fredborg.org\/?p=1060#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fredborg.org\/?p=1060\",\"url\":\"https:\/\/fredborg.org\/?p=1060\",\"name\":\"Data is King: Part 1 Send data from Business Central to Azure - Fredborg\",\"isPartOf\":{\"@id\":\"https:\/\/fredborg.org\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fredborg.org\/?p=1060#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fredborg.org\/?p=1060#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header.png\",\"datePublished\":\"2023-08-11T06:55:26+00:00\",\"dateModified\":\"2023-08-11T11:32:15+00:00\",\"description\":\"Data is king. Still, for many of us, the problem is that we have so much data in so many different systems and different formats.\",\"breadcrumb\":{\"@id\":\"https:\/\/fredborg.org\/?p=1060#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fredborg.org\/?p=1060\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fredborg.org\/?p=1060#primaryimage\",\"url\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header.png\",\"contentUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header.png\",\"width\":2560,\"height\":1440},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fredborg.org\/?p=1060#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/fredborg.org\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Data is King: Part 1 Send data from Business Central to Azure\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fredborg.org\/#website\",\"url\":\"https:\/\/fredborg.org\/\",\"name\":\"Fredborg\",\"description\":\"Business Central and Azure\",\"publisher\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fredborg.org\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d\",\"name\":\"dfredborg\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png\",\"contentUrl\":\"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png\",\"width\":256,\"height\":256,\"caption\":\"dfredborg\"},\"logo\":{\"@id\":\"https:\/\/fredborg.org\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:fredborg.org\",\"https:\/\/www.linkedin.com\/in\/dfredborg\/\",\"https:\/\/x.com\/dfredborg\",\"https:\/\/www.youtube.com\/channel\/UCUNZglLDMjBlOK_T9JtI8UA\"],\"url\":\"https:\/\/fredborg.org\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Data is King: Part 1 Send data from Business Central to Azure - Fredborg","description":"Data is king. Still, for many of us, the problem is that we have so much data in so many different systems and different formats.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fredborg.org\/?p=1060","og_locale":"en_US","og_type":"article","og_title":"Data is King: Part 1 Send data from Business Central to Azure - Fredborg","og_description":"Data is king. Still, for many of us, the problem is that we have so much data in so many different systems and different formats.","og_url":"https:\/\/fredborg.org\/?p=1060","og_site_name":"Fredborg","article_published_time":"2023-08-11T06:55:26+00:00","article_modified_time":"2023-08-11T11:32:15+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header-1024x576.png","type":"image\/png"}],"author":"dfredborg","twitter_card":"summary_large_image","twitter_creator":"@dfredborg","twitter_site":"@dfredborg","twitter_misc":{"Written by":"dfredborg","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fredborg.org\/?p=1060#article","isPartOf":{"@id":"https:\/\/fredborg.org\/?p=1060"},"author":{"name":"dfredborg","@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"headline":"Data is King: Part 1 Send data from Business Central to Azure","datePublished":"2023-08-11T06:55:26+00:00","dateModified":"2023-08-11T11:32:15+00:00","mainEntityOfPage":{"@id":"https:\/\/fredborg.org\/?p=1060"},"wordCount":941,"commentCount":0,"publisher":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"image":{"@id":"https:\/\/fredborg.org\/?p=1060#primaryimage"},"thumbnailUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header.png","articleSection":["Azure","Business Central"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fredborg.org\/?p=1060#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fredborg.org\/?p=1060","url":"https:\/\/fredborg.org\/?p=1060","name":"Data is King: Part 1 Send data from Business Central to Azure - Fredborg","isPartOf":{"@id":"https:\/\/fredborg.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fredborg.org\/?p=1060#primaryimage"},"image":{"@id":"https:\/\/fredborg.org\/?p=1060#primaryimage"},"thumbnailUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header.png","datePublished":"2023-08-11T06:55:26+00:00","dateModified":"2023-08-11T11:32:15+00:00","description":"Data is king. Still, for many of us, the problem is that we have so much data in so many different systems and different formats.","breadcrumb":{"@id":"https:\/\/fredborg.org\/?p=1060#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fredborg.org\/?p=1060"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fredborg.org\/?p=1060#primaryimage","url":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header.png","contentUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/07\/header.png","width":2560,"height":1440},{"@type":"BreadcrumbList","@id":"https:\/\/fredborg.org\/?p=1060#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fredborg.org\/"},{"@type":"ListItem","position":2,"name":"Data is King: Part 1 Send data from Business Central to Azure"}]},{"@type":"WebSite","@id":"https:\/\/fredborg.org\/#website","url":"https:\/\/fredborg.org\/","name":"Fredborg","description":"Business Central and Azure","publisher":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fredborg.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/fredborg.org\/#\/schema\/person\/59a5520cbf04c6bd1267f30b4488e71d","name":"dfredborg","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/fredborg.org\/#\/schema\/person\/image\/","url":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png","contentUrl":"https:\/\/fredborg.org\/wp-content\/uploads\/2023\/06\/download.png","width":256,"height":256,"caption":"dfredborg"},"logo":{"@id":"https:\/\/fredborg.org\/#\/schema\/person\/image\/"},"sameAs":["https:fredborg.org","https:\/\/www.linkedin.com\/in\/dfredborg\/","https:\/\/x.com\/dfredborg","https:\/\/www.youtube.com\/channel\/UCUNZglLDMjBlOK_T9JtI8UA"],"url":"https:\/\/fredborg.org\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/1060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1060"}],"version-history":[{"count":10,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/1060\/revisions"}],"predecessor-version":[{"id":1101,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/posts\/1060\/revisions\/1101"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=\/wp\/v2\/media\/1061"}],"wp:attachment":[{"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fredborg.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}