View Jitterbit Developer Portal
Introduction
This page covers Jitterbit variables that are available for targets, organized by informational variables that you get (read), and settings variables that you set (write):
Informational
Settings
jitterbit.target.chunk_node_name
jitterbit.target.chunk_size
jitterbit.target.chunking_uncombined
jitterbit.target.db.character_encoding
jitterbit.target.db.commit_chunks
jitterbit.target.db.include_null_in_sql_statement
jitterbit.target.db.no_data_action
jitterbit.target.db.pre_target_sql
jitterbit.target.db.schema_name_delimiter
jitterbit.target.db.transaction
jitterbit.target.file_share.create_directories
jitterbit.target.ftp.encode_url
jitterbit.target.ftp.transfer_timeout
jitterbit.target.http.form_data
jitterbit.target.http.form_data.ContentType
jitterbit.target.http.form_data.filename
jitterbit.target.http.form_data.name
jitterbit.target.http.max_redirs
jitterbit.target.http.remove_trailing_linebreaks
jitterbit.target.http.response.header.HeaderName
jitterbit.target.http.ssl_cert_id
jitterbit.target.http.transfer_timeout
jitterbit.target.sftp.ssh_key_id
andjitterbit.source.sftp.ssh_key_id
jitterbit.target.text.character_encoding
jitterbit.target.wave.json
jitterbit.target.xml.include_empty_xml
jitterbit.target.xml.include_null_xml
jitterbit.target.xml.nsprefix
jitterbit.target.xml.num_for_bool
jitterbit.target.xml.prettify
Informational
jitterbit.target.file_count
Variable | jitterbit.target.file_count |
---|---|
Data Type | Integer |
Description | After all the input files have been transformed, this variable is set to the number of target files that will be transferred. |
jitterbit.target.ftp.return_code
Variable | jitterbit.target.ftp.return_code |
---|---|
Data Type | Integer |
Description | The response status code returned from an FTP target when used in an operation or |
jitterbit.target.http.status_code
Variable | jitterbit.target.http.status_code |
---|---|
Data Type | Integer |
Description | The response status code returned from a HTTP target when used in an operation or |
Settings
jitterbit.target.chunk_node_name
Variable | jitterbit.target.chunk_node_name |
---|---|
Data Type | String |
Description | If chunking (splitting a file apart) is enabled, a node is the repeating record (or loop node) at which it is possible to split the file. For example, in an XML file, the named levels (repeating records) could be root, organization, department, and employee. You could choose to chunk (split) the file on department or on employee. It is also possible to set the node in Operation Options. |
jitterbit.target.chunk_size
Variable | jitterbit.target.chunk_size |
---|---|
Data Type | Integer |
Description | Two possible cases where
|
jitterbit.target.chunking_uncombined
Variable | jitterbit.target.chunking_uncombined |
---|---|
Data Type | Boolean |
Description | If set to |
jitterbit.target.db.character_encoding
Variable | jitterbit.target.db.character_encoding |
---|---|
Data Type | String |
Description | Specify the character encoding for ODBC target database character/text columns. If no encoding is specified, Latin-1 (ISO-8859-1) is assumed. For supported encoding, see Supported Character Encodings. |
jitterbit.target.db.commit_chunks
Variable | jitterbit.target.db.commit_chunks |
---|---|
Data Type | Boolean |
Description | If set to |
jitterbit.target.db.include_null_in_sql_statement
Variable | jitterbit.target.db.include_null_in_sql_statement |
---|---|
Data Type | Boolean |
Default | false |
Description | If set to |
jitterbit.target.db.no_data_action
Variable | jitterbit.target.db.no_data_action |
---|---|
Data Type | String |
Description | Option for what to do if an empty database target is created. These values are valid:
The default (for when this variable is not set) can be changed in |
jitterbit.target.db.pre_target_sql
Variable | jitterbit.target.db.pre_target_sql |
---|---|
Data Type | String |
Default | "" |
Description | Run this SQL statement before starting to populate the target database table(s). The default is an empty string. |
jitterbit.target.db.schema_name_delimiter
Variable | jitterbit.target.db.schema_name_delimiter |
---|---|
Data Type | String |
Default | . |
Description | The default is a single period ( |
jitterbit.target.db.transaction
Variable | jitterbit.target.db.transaction |
---|---|
Data Type | Boolean |
Default | true |
Description | Set to |
jitterbit.target.file_share.create_directories
Variable | jitterbit.target.file_share.create_directories |
---|---|
Data Type | Boolean |
Default | false |
Description | Set to |
jitterbit.target.ftp.encode_url
and jitterbit.source.ftp.encode_url
Variable | jitterbit.target.ftp.encode_url andjitterbit.source.ftp.encode_url |
---|---|
Data Type | Boolean |
Default | false |
Description | Set both variables to |
jitterbit.target.ftp.transfer_timeout
Variable | jitterbit.target.ftp.transfer_timeout |
---|---|
Data Type | Integer |
Description | Set the transfer time-out in seconds for FTP target transfers. The default transfer time-out for FTP is one hour (3,600 seconds). Set to zero to disable. |
jitterbit.target.http.form_data
Variable | jitterbit.target.http.form_data |
---|---|
Data Type | Boolean |
Description | If set to |
jitterbit.target.http.form_data.ContentType
Variable | jitterbit.target.http.form_data.ContentType |
---|---|
Data Type | String |
Description | If RFC 1687 form upload is used, this sets the Content-Type of the file. |
jitterbit.target.http.form_data.filename
Variable | jitterbit.target.http.form_data.filename |
---|---|
Data Type | String |
Description | If RFC 1687 form upload is used, this sets the name of the uploaded file. |
jitterbit.target.http.form_data.name
Variable | jitterbit.target.http.form_data.name |
---|---|
Data Type | String |
Description | If RFC 1687 form upload is used, this sets the name of the form. |
jitterbit.target.http.max_redirs
Variable | jitterbit.target.http.max_redirs |
---|---|
Data Type | Integer |
Default | 0 |
Description | Maximum number of redirects to follow when using an HTTP target. Set this variable to a negative number to follow any number of redirects. The default is |
jitterbit.target.http.remove_trailing_linebreaks
Variable | jitterbit.target.http.remove_trailing_linebreaks |
---|---|
Data Type | Boolean |
Description | If set to |
jitterbit.target.http.response.header.HeaderName
jitterbit.target.http.response.header.HeaderName
Variable | jitterbit.target.http.response.header.HeaderName (shown in the script editor as jitterbit.target.http.response.header.* ) |
---|---|
Data Type | String |
Description | Set when handling a hosted web service post or an HTTP endpoint. HTTP response headers are not exposed, just the payload. When substituted by the name of an HTTP header for HeaderName, this variable holds the corresponding value. For example, the variable |
jitterbit.target.http.ssl_cert_id
Variable | jitterbit.target.http.ssl_cert_id |
---|---|
Data Type | String |
Description | An identifier for a configuration entry in |
jitterbit.target.http.transfer_timeout
Variable | jitterbit.target.http.transfer_timeout |
---|---|
Data Type | Integer |
Description | Set the transfer time-out in seconds for HTTP target transfers. The default transfer time-out for HTTP is one hour (3,600 seconds). Set to zero to disable. |
jitterbit.target.sftp.ssh_key_id
and
jitterbit.source.sftp.ssh_key_id
jitterbit.target.sftp.ssh_key_id
jitterbit.source.sftp.ssh_key_id
Variable | jitterbit.target.sftp.ssh_key_id andjitterbit.source.sftp.ssh_key_id |
---|---|
Data Type | String |
Default | "" |
Description | For configuring multiple SSH keys. By default, these are both empty, meaning the configuration in the NOTE: When editing the configuration file, note that a line that is commented out with a leading # must not be left blank, or the next line will be read as a comment even if it does not begin with # .If either of these variables is set to a string (such as |
jitterbit.target.text.character_encoding
Variable | jitterbit.target.text.character_encoding |
---|---|
Data Type | String |
Description | Specify the character encoding for target text documents. If no encoding is specified, Latin-1 (ISO-8859-1) is assumed. For supported encoding, see Supported Character Encodings. |
jitterbit.target.wave.json
Variable | jitterbit.target.wave.json |
---|---|
Data Type | String |
Description | Used to override the JSON in a Salesforce Einstein (Wave) JSON metafile. See Overriding JSON Metadata in Salesforce Einstein Analytics. |
jitterbit.target.xml.include_empty_xml
Variable | jitterbit.target.xml.include_empty_xml |
---|---|
Data Type | Boolean |
Default | false |
Description | If a mapping to a target node results in an empty value, include the node. The default is to exclude this node. Setting this option to |
jitterbit.target.xml.include_null_xml
Variable | jitterbit.target.xml.include_null_xml |
---|---|
Data Type | Boolean |
Default | true |
Description | If a mapping to a target node results in null or an empty value, include the node but make it nil. The default is to include this node. Setting this option to |
jitterbit.target.xml.nsprefix
Variable | jitterbit.target.xml.nsprefix |
---|---|
Data Type | String |
Default | "NS" |
Description | The default XML namespace prefix is For example, with the default XML namespace, your XML target output may look like this: <ns:Body xmlns:ns="http://www.marketo.com/mktows/"> <ns:successGetMultipleLeads> <result> When you set this global variable equal to a different prefix, for example <tp:Body xmlns:tp="http://www.marketo.com/mktows/"> <tp:successGetMultipleLeads> <result> |
jitterbit.target.xml.num_for_bool
Variable | jitterbit.target.xml.num_for_bool |
---|---|
Data Type | Boolean |
Default | true |
Description | If set to |
jitterbit.target.xml.prettify
Variable | jitterbit.target.xml.prettify |
---|---|
Data Type | Boolean |
Default | true |
Description | If set to true, XML targets are written with line breaks and tab indention. This is easier to read but the resulting file will be larger. |