Replace all attributes of this CSV Import
imports_put_files_csv(id, source, destination, first_row_is_header,
column_delimiter = NULL, escaped = NULL, compression = NULL,
existing_table_rows = NULL, max_errors = NULL,
table_columns = NULL, execution = NULL,
redshift_destination_options = NULL)integer required. The ID for the import.
list required. A list containing the following elements:
fileIds array, The file ID(s) to import, if importing Civis file(s).
storagePaths object,
list required. A list containing the following elements:
schema string, The destination schema name.
table string, The destination table name.
remoteHostId integer, The ID of the destination database host.
credentialId integer, The ID of the credentials for the destination database.
primaryKeys array, A list of the primary key column(s) of the destination table.If the destination table does not exist, and the import mode is "upsert", this field is required.
lastModifiedKeys array, A list of the columns indicating a record has been updated.If the destination table does not exist, and the import mode is "upsert", this field is required.
boolean required. A boolean value indicating whether or not the first row of the source file is a header row.
string optional. The column delimiter for the file. Valid arguments are "comma", "tab", and "pipe". Defaults to "comma".
boolean optional. A boolean value indicating whether or not the source file has quotes escaped with a backslash.Defaults to false.
string optional. The type of compression of the source file. Valid arguments are "gzip" and "none". Defaults to "none".
string optional. The behavior if a destination table with the requested name already exists. One of "fail", "truncate", "append", "drop", or "upsert".Defaults to "fail".
integer optional. The maximum number of rows with errors to ignore before failing. This option is not supported for Postgres databases.
array optional. An array containing the following fields:
name string, The column name.
sqlType string, The SQL type of the column.
string optional. In upsert mode, controls the movement of data in upsert mode. If set to "delayed", the data will be moved after a brief delay. If set to "immediate", the data will be moved immediately. In non-upsert modes, controls the speed at which detailed column stats appear in the data catalogue. Defaults to "delayed", to accomodate concurrent upserts to the same table and speedier non-upsert imports.
list optional. A list containing the following elements:
distkey string, Distkey for this table in Redshift
sortkeys array, Sortkeys for this table in Redshift. Please provide a maximum of two.
A list containing the following elements:
integer, The ID for the import.
list, A list containing the following elements:
fileIds array, The file ID(s) to import, if importing Civis file(s).
storagePaths object,
list, A list containing the following elements:
schema string, The destination schema name.
table string, The destination table name.
remoteHostId integer, The ID of the destination database host.
credentialId integer, The ID of the credentials for the destination database.
primaryKeys array, A list of the primary key column(s) of the destination table.If the destination table does not exist, and the import mode is "upsert", this field is required.
lastModifiedKeys array, A list of the columns indicating a record has been updated.If the destination table does not exist, and the import mode is "upsert", this field is required.
boolean, A boolean value indicating whether or not the first row of the source file is a header row.
string, The column delimiter for the file. Valid arguments are "comma", "tab", and "pipe". Defaults to "comma".
boolean, A boolean value indicating whether or not the source file has quotes escaped with a backslash.Defaults to false.
string, The type of compression of the source file. Valid arguments are "gzip" and "none". Defaults to "none".
string, The behavior if a destination table with the requested name already exists. One of "fail", "truncate", "append", "drop", or "upsert".Defaults to "fail".
integer, The maximum number of rows with errors to ignore before failing. This option is not supported for Postgres databases.
array, An array containing the following fields:
name string, The column name.
sqlType string, The SQL type of the column.
string, In upsert mode, controls the movement of data in upsert mode. If set to "delayed", the data will be moved after a brief delay. If set to "immediate", the data will be moved immediately. In non-upsert modes, controls the speed at which detailed column stats appear in the data catalogue. Defaults to "delayed", to accomodate concurrent upserts to the same table and speedier non-upsert imports.
list, A list containing the following elements:
distkey string, Distkey for this table in Redshift
sortkeys array, Sortkeys for this table in Redshift. Please provide a maximum of two.
boolean, The hidden status of the item.