XMLToTxt Step

Use this step to convert XML data to TXT format

Last published at: May 14th, 2024


This step converts and displays the XML data to TXT format, with rows and columns. This step is used in conjunction with ExecuteSQLStatement step as it requires //Row tag in the XML to process. 


  • xmlVariable – Variable that holds the xml. Ex: - variable.data
  • txtFilePath – TXT file path on the FlowWright server
  • writeColHeadings - Write column names
  • rowDelimiter – Row delimiter
  • colDelimiter – Column delimiter


  • True – step executed successfully
  • False – step failed to execute 



Let’s build and execute the XmlToTxtDef example.          

  • Create a new definition called “XmlToTxtDef
  • Select the definition and click the “design” button
  • Drag the ExecuteSQL and XMLtoTXT steps and connect as shown above
  • Let’s define variables called “xmlData” to hold the XML value (containing //Row tag) 
  • Click on the “executeSQL” step to configure its properties as shown below
  • Click on the “XmlToTxt” step to configure its properties as shown below. The TXT file path refers to the file location on the server. 
  • Save the process definition, create a new process instance and execute. The step should transform the XML data to TXT file to the path specified on the server. 
  • A sample xmlData (containing //Row tags) are shown here
  • A sample XMLtoTXT transform is shown here