Open topic with navigation

The file content format that you select for the Read File action specifies the content type of the data contained by the file that is read. This determines how the action saves the content to the output variable and whether additional variables are created.

Supported file content format types include the following: 

• BTXML Script: Specifies that the action saves the entire data contents to the output variable that you specify.

• XML Variables: Specifies that the action parses the data and saves the parsed results as integration variables for later use.

  File Format Example

  When you specify the XML Variables format, the action parses the data into variables according to the schema contained within the data. The following formats are supported:

  Any <Variable> or <variable> that appears in the xml document is valid as long as the name and value can be retrieved from its attribute or child node. Lower case "variable," "name," and "value" are also accepted.

   

  ...

  <Variable Name=”Variable1” Value=”111”/>

  <Variable Name=”Variable2” Value=”222”/>

  ...

   

  ...

  <Variable Name="Variable1">111</Variable>

  <Variable Name="Variable2">222</Variable>

  ...

   

  ...

  <Variable Name=”Variable1”>

  <Value>111</Value>

  </Variable>

  <Variable Name=”Variable2”>

  <Value>222</Value>

  </Variable>

  ...

   

  ...

  <Variable>

  <Name>Variable1</Name>

  <Value>111</Value>

  </Variable>

  <Variable>

  <Name>Variable2</Name>

  <Value>222</Value>

  </Variable>

  ...

  In each of these examples, you can then use %Variable1% and %Variable2% in subsequent actions in the integration.

  The XML Variables format supports parsing variables in saved sample files (.vars).

   

• Other XML: Specifies that the action saves the entire data contents to the output variable that you specify.

• Text (CSV): Specifies that the action saves the entire data contents to the output variable that you specify.

• Text (Tab Delimited): Specifies that the action saves the entire data contents to the output variable that you specify.

• JSON Variables: Specifies that the action parses the data and saves the parsed results as integration variables for later use.

  File Format Example

  When you specify the JSON Variables format, the action parses the data into variables according to the schema contained within the data. The following format is supported:

  {

  "Variable1" : "111",

  "Variable2" : “222”

  }

  In this example, you can then use %Variable1% and %Variable2% in subsequent actions in the integration.

• Print Command Script: Specifies that the action saves the entire data contents to the output variable that you specify.

• Unstructured: Specifies that the action saves the entire data contents to the output variable that you specify.