NOTE: Using Utility Connectors counts toward your overall Connector and Task Usage.
The Generic File Connector provides the Create Delimited Text File Method that creates delimited text content, for example Comma Separated Values (CSV) and Tab Separated Values text. This content might then be sent to a remote FTP server as a new file using the FTP Connector.
Create Delimited Text File Method
The Generic File Connector’s Create Delimited Text File Method doesn’t provide any initial “data fields” as it doesn’t know the data you wish to use. The only default fields are are fields to define the structure of the content to be created: Delimiter and Include Header.
You must therefore add custom Request Fields for the values you want to bring in as the “columns” of your data using Field Locations in this format:
You’ll then be able to map to these Fields in the Builder from a previous Step that retrieves a list of data you wish to convert into delimited text content.
The generated text content is accessible through the Content Response Field and will be in the format you’ve specified.
Example of CSV output:
emailAddress,firstName firstname.lastname@example.org,John email@example.com,Dave
Note: You should ensure that the Cycle’s Collection Splitting Setting doesn’t split the data you’re mapping from, otherwise the Method will generate separate file content for each record you’re passing in.