Search

REST API Reference

REST API Reference

Back Next

CSV Flat File Connections

CSV Flat File Connections

When you create or update a CSV flat file connection, you can configure additional attributes, such as the connection ID and the connection name.

The following table describes attributes that you can use for CSV flat file connections:

Attribute	Description
id	Connection ID.
orgId	Organization ID.
name	Connection name.
description	Optional connection description.
type	Connection type. Use CSVFile.
database	Directory where flat files are stored. In the user interface, this attribute is the Directory field. In the REST API response that populates the value in the user interface, the name of this attribute is dirName.
dateFormat	Date format for date fields in the flat file. Use one of the following formats: MM/dd/yyyy MM-dd-yyyy MM.dd.yyyy dd/MM/yyyy dd-MM-yyyy dd.MM.yyyy MM/dd/yyyy HH:mm MM-dd-yyyy HH:mm MM.dd.yyyy HH:mm dd/MM/yyyy HH:mm dd-MM-yyyy HH:mm dd.MM.yyyy HH:mm MM/dd/yyyy HH:mm:ss MM-dd-yyyy HH:mm:ss MM.dd.yyyy HH:mm:ss dd/MM/yyyy HH:mm:ss dd-MM-yyyy HH:mm:ss dd.MM.yyyy HH:mm:ss yyyy-MM-dd yyyy-MM-dd HH:mm yyyy-MM-dd HH:mm:ss yyyy-MM-ddTHH:mm:ss.SSSZ yyyy/MM/dd yyyy/MM/dd HH:mm yyyy/MM/dd HH:mm:ss yyyyMMdd MM/dd/yyyy HH24:mm:ss MM/dd/yyyy HH24:mm:ss.ms MM/dd/yyyy HH24:mm:ss.us MM/dd/yyyy HH24:mm:ss.ns Default is MM/dd/yyyy HH:mm:ss.
codepage	The code page of the system that hosts the flat file. Use one of the following options: UTF-8. Unicode Transformation Format, multibyte. MS1252. MS Windows Latin 1 (ANSI), superset of Latin 1. ISO-8859-15. Latin 9, Western European. ISO-8859-2. Eastern European. ISO-8859-3. Southeast European. ISO-8859-5. Cyrillic. ISO-8859-9. Latin 5, Turkish. IBM500. IBM EBCDIC International Latin-1.

Watch

Comments

0 COMMENTS

We’d like to hear from you! Log in to comment.