To change an XMLport export from XML to CSV, set the Format property to VariableText

MB-820 By islever Editorial Last updated

Design and create an XMLport

Short answer

E Set the XMLport Format property to VariableText to export delimited CSV text instead of XML.

Question

You have an XMLport that exports items from a database to an XML file. You need to change the export format from XML to CSV. What should you do?
  1. Change the Direction property to Both.
  2. Change the FormatEvaluate property to Legacy.
  3. Change the XmlVersionNo property to 1.1.
  4. Fill the FileName property with the Items.csv value.
  5. Change the Format property to VariableText. Correct Answer

Key Takeaways

Only the Format property needs to change to switch the output format; the node definitions remain valid for both XML and CSV output. The Direction, XmlVersionNo, and FileName properties do not change the format.

The XMLport Format property controls the serialization format. Setting Format to VariableText produces comma-separated, delimited text (CSV) instead of XML, while keeping the same node structure defined in the XMLport.

Common mistake: Do not change Direction to Both, set FormatEvaluate to Legacy, or change XmlVersionNo, as none of those convert the output to CSV. The FileName property only names the file, not its format.

Expert Analysis

Why the Answer Is Correct

Option E is correct because the XMLport Format property, when set to VariableText, makes the XMLport export delimited CSV text rather than XML. This is the single property that controls the output format. Community voting is unanimously E (100 votes), and edbb578 confirms 'Format = VariableText'.

Why the Other Options Are Wrong

Option A (Direction = Both) controls import/export direction, not the format. Option B (FormatEvaluate = Legacy) relates to evaluable format handling, not XML versus CSV. Option C (XmlVersionNo = 1.1) sets the XML version, and Option D (FileName = Items.csv) only names the output file without changing its format.

Community Comment Notes

z_safar points to the official Format property documentation and AutomateFlo states 'E is correct,' both supporting the answer.

Official Reference

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-format-property

This link opens the official vendor documentation in a new tab.

Community Votes

E
100%

100% of anonymous learners picked answer E. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 4 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 4

  1. z_safar 👍 2
    Correct answer is E See https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-format-property
  2. Rahila_Amir 👍 1
    I guess the correct answe is E.
  3. edbb578 👍 4 Answered E
    Format = VariableText;
  4. AutomateFlo 👍 3 Answered E
    E is correct

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Snapshot debugging only fires on the next session of the configured user, so a session that never occurs means debugging never starts

S-grade

Use Get-BcArtifactUrl with -select Current to pull the most recent Business Central artifact URL when setting up a local development Docker container

S-grade

Adding InherentPermissions = 'RI' to a table object grants Read and Insert permissions and resolves permission errors, blocked posting, and list-page access without a new permission set

S-grade

On a Role Center page, define the navigation bar (second-level navigation) in the area(Embedding) to link to other pages

S-grade

← Back to MB-820 Study Guide