File Connector Guide

Back Next

Built-In Process Object Output

Applicable only to Delimited Content Parser and Fixed Width Content Parser

When you choose the built-in process objects with delimited content and fixed width files, the output is represented in a DelimitedContent process object. For example, if you process a simple .csv file with several records, you might read a file similar to this:

User Name,Age,Born
Bob Smith,22,1987
Bill White,45,1999

Based on this .csv file, the file contents are represented with the header name and value for each field. The process object includes file information about the source file, list of header objects, list of records and total row count.

If you work in spilt rows mode, the file is divided into separate rows and for each row Process Designer produces a DelimitedContent process objects with headers and one record.

<DelimitedContent>
     <fileInfo>
        <!-- for FTP/SFTP only -->
        <host>127.0.0.1</host>        
        
        <lastModified>2015-04-29T14:37:35.448Z</lastModified>
        <dir>DataFiles</dir>
        <name>users</name>
        <path>/DataFiles/users.csv</path>
        <fullName>users.csv</fullName>
        <ext>csv</ext>
        <size>78</size>
     </fileInfo>
     <header>
        <name>User Name</name>
        <fieldIndex>1</fieldIndex>
     </header>
     <header>
        <name>Age</name>
        <fieldIndex>2</fieldIndex>
     </header>
     <header>
        <name>Born</name>
        <fieldIndex>3</fieldIndex>
     </header>
     <record>
        <field><value>Bob Smith</value></field>
        <field><value>22</value></field>
        <field><value>1987</value></field> 
        <index>1</index>
     </record>
     <record>
        <field><value>Bill White</value></field>
        <field><value>45</value></field>
        <field><value>1999</value></field>
        <index>2</index>
     </record>
     <totalRowsCount>3</totalRowsCount>
</DelimitedContent>

Process Objects with File Connector

Download Guide

Watch

Comments

Cloud Application Integration Homepage