XMLPORT UTF-8

(1) Share

Report

Posted on by Steve.Desmedt

Hello all,
I am having a problem exporting an XMLPort from the format 'Xml' to UTF-8 format. I have already tested this in many ways and each time I get UTF-16 format.

Test 1

xmlport 90000 "TEST EXPORT UTF"
{
    Format = Xml;
    Caption = 'TEST EXPORT UTF';
    Direction = Export;
    UseRequestPage = false;

    schema
    {
        textelement(RootNodeName)
        {
            tableelement(Item; Item)
            {
                fieldelement(No; Item."No.")
    ....
}

pageextension 90016 "test export" extends "Item List"
{
    actions
    {
        addafter(History)
        {
            action(ExportItems)
            {
                Caption = 'Export Items';
                Promoted = true;
                PromotedCategory = Process;
                Image = Export;
                ApplicationArea = All;

                trigger OnAction()
                begin
                    testxml.TextEncoding(TextEncoding::UTF8);
                    testxml.Run();
                end;
            }
        }
    }


    var
        testxml: XmlPort 90000;
}

I also tried it with outstream but without success

Can anybody suggest a solution so the final XML has UTF-8 format ?

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

CU08071217-0 on at

Like (1)

Report
XMLPORT UTF-8

To export an XMLPort in UTF-8 format in Microsoft Dynamics 365 Business Central, you can follow these steps:

Set the TextEncoding property of the XMLPort to UTF8:

TextEncoding = UTF8;

Optionally, you can also set the TextEncoding in AL code at runtime if needed:

currXMLport.TextEncoding(TextEncoding::UTF8);

Make sure the Format property of the XMLPort is set to either Fixed Text or Variable Text.

When exporting data using the XMLPort, it will be converted from Unicode to UTF-8 encoding before being written to the file.

UTF-8 is a Unicode Transformation Format that uses one byte (8 bits) to encode each character. It is based on the Unicode character set, which includes most characters of all languages in a single character set.

UTF-8 is compatible with ASCII and is the most common encoding format recommended if you aren't sure of the format supported by the system you are integrating with.

So in summary, set the TextEncoding property of the XMLPort to UTF8, optionally set it in code if needed, ensure the Format is Fixed or Variable Text, and the data will be exported in UTF-8 encoding. UTF-8 is a widely supported format that is compatible with ASCII.

Was this reply helpful? Yes No
Gerardo Rentería Ga... 22,623 Most Valuable Professional on at

Like (0)

Report
XMLPORT UTF-8

Hi

Can you add the following property to the xmlport object?

TextEncoding Property - Business Central | Microsoft Learn

TextEncoding = UTF8;

xmlport 90000 "TEST EXPORT UTF" { Format = Xml;

BR

GR

Was this reply helpful? Yes No

Community site session details

XMLPORT UTF-8

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates

Community site session details

XMLPORT UTF-8

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Small and medium business | Business Central, NAV, RMS

Featured topics

Product updates