Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Reference: CSV-to-XML Step Properties

Reference: CSV-to-XML Step Properties

Common Tab

Property
XML Attribute Name
Description
Step Id
id
The unique ID of the
csv-to-xml
step within the assembly.
Input
input
Specifies where the
csv-to-xml
step obtains data as input. There are 5 possible values:
  • message
    : the entire message, including
    rootpart
    and attachments.
  • soapbody
    : the content of the SOAP body from the
    rootpart
    of the message. Only applicable when the input contains a SOAP message.
  • attachment
    : a MIME attachment within the message. Specify the attachment index.
  • rootpart
    : the content of the root part of a MIME message. If the message isn't MIME, the entire message is selected.
  • variable
    : use a named variable from the
    MediationContext
    .
Output
output
Specifies where the
csv-to-xml
step directs the output. There are 5 possible values:
  • message
    : the entire message, including
    rootpart
    and attachments. This value creates a new message, effectively removing any attachments.
  • soapbody
    : the content of the SOAP body from the
    rootpart
    of the message.
  • attachment
    : a MIME attachment to the message. Specify the attachment index.
  • rootpart
    : the content of the root part of a MIME message, or if the message isn't MIME, the message itself. This value preserves any attachments on the original message.
  • variable
    : save the output as a named variable in the
    MediationContext
    .
Col Names
colNames
The names of the columns that display in your XML output file.
Enter the value for this property as a comma-separated list of names. Example:
col1
,
col2
,
col3
.
Namespace Prefix
namespacePrefix
The namespace prefix that displays in your XML output file.
Namespace URI
namespaceURI
The namespace URI that displays on the root element in your XML output file.
Example: if you specify a URI of
http://example.workday.com/SupplyChainManagement/DataTypes.xsd
and a namespace prefix of
ns
, the
csv-to-xml
step creates this root element in your XML output file:
<ns:root xmlns:ns="http://example.workday.com/SupplyChainManagement/DataTypes.xsd">
Root Name
rootName
The name of the root element that displays in your XML output file.
Row Name
rowName
The names of the rows that display in your XML output file.
Enter the value for this property as a comma-separated list of names. Example:
row1
,
row2
,
row3
.
Separator
separator
The separator character used in your CSV input file.
Format
format
Specifies whether your CSV input file is RFC-4180 compliant. You can enter either of these values:
  • rfc4180
  • simple
If you enter
rfc4180
, then the
csv-to-xml
step assumes that your CSV input file complies with RFC-4180 standards.
If you enter
simple
, or leave the field blank, then the
csv-to-xml
step:
  • Treats apostrophes as alternative quote marks.
  • Trims initial whitespaces in values.
  • Accepts any line endings (CR, LF, or CRLF).
Use First Line As Header
useFirstLineAsHeader
Specifies whether the
csv-to-xml
step uses the first line of your CSV input file to name the columns that display in your XML output file.

Advanced Tab

Property
XML Attribute Name
Description
Description
description
A description of the
csv-to-xml
step that displays in the consolidated log. You can use this feature to describe the step's function and the data on which it is operating.
Execute When
execute-when
A condition that determines whether the
csv-to-xml
step executes.