QUICK LINKS
View Jitterbit Developer Portal
- Created by Laura Knowles, last modified by Lisa Brown on Mar 11, 2020
Introduction
This page covers Jitterbit variables that are available for sources, organized by informational variables that you get (read), and settings variables that you set (write):
Informational
jitterbit.source.filenamejitterbit.source.filenamesjitterbit.source.ftp.return_codejitterbit.source.http.responsejitterbit.source.http.status_codejitterbit.source.locatorjitterbit.source.locatorsjitterbit.source.sizejitterbit.source.sizes
Settings
jitterbit.source.db.character_encodingjitterbit.source.db.preserve_char_whitespacejitterbit.source.db.schema_name_delimiterjitterbit.source.db.trimjitterbit.source.file_limitjitterbit.source.file_share.file_list_limitjitterbit.source.ftp.transfer_timeoutjitterbit.source.http.max_redirsjitterbit.source.http.response.header.HeaderNamejitterbit.source.http.ssl_cert_idjitterbit.source.http.transfer_timeoutjitterbit.source.preserve_char_whitespacejitterbit.source.sftp.ssh_key_idandjitterbit.target.sftp.ssh_key_idjitterbit.source.text.character_encodingjitterbit.source.text.csv_nullable
Informational
jitterbit.source.filename
| Variable | jitterbit.source.filename |
|---|---|
Data Type | String |
| Description | The name of the source file. Holds the leaf part of the locator. For example, if the locator is ftp://ordersrv/orderdrop/po.xml, the name of the source file is po.xml. This variable is available only while a transformation using this particular file is executing. |
jitterbit.source.filenames
| Variable | jitterbit.source.filenames |
|---|---|
Data Type | Array |
| Description | Same as jitterbit.source.locators but holding only the leaf part of the locators (see jitterbit.source.locator). This variable is available unless it has been overwritten by another operation in an operation chain. |
jitterbit.source.ftp.return_code
| Variable | jitterbit.source.ftp.return_code |
|---|---|
Data Type | Integer |
| Description | The response status code returned from an FTP source when used in an operation or |
jitterbit.source.http.response
| Variable | jitterbit.source.http.response |
|---|---|
Data Type | String |
| Description | The response body returned from an HTTP source when used in an operation or |
jitterbit.source.http.status_code
| Variable | jitterbit.source.http.status_code |
|---|---|
Data Type | Integer |
| Description | The response status code returned from an HTTP source when used in an operation or |
jitterbit.source.locator
| Variable | jitterbit.source.locator |
|---|---|
Data Type | String |
| Description | The locator used to fetch a file. This can be a URL or a path to a file share, such as |
jitterbit.source.locators
| Variable | jitterbit.source.locators |
|---|---|
Data Type | Array |
| Description | An array containing all the locators that will be processed. This variable is available after the source files have been fetched. It is available as long as it has not been overwritten by another operation in an operation chain. |
jitterbit.source.size
| Variable | jitterbit.source.size |
|---|---|
Data Type | Integer |
| Description | Size of the source file in bytes. The size is |
jitterbit.source.sizes
| Variable | jitterbit.source.sizes |
|---|---|
Data Type | Array |
| Description | An array containing all the sizes of the source files that will be processed. This variable is available after the source files have been fetched. It is available as long as it has not been overwritten by another operation in an operation chain. |
Settings
jitterbit.source.db.character_encoding
| Variable | jitterbit.source.db.character_encoding |
|---|---|
Data Type | String |
| Description | Specifies the character encoding for ODBC source database character/text columns. If no encoding is specified, Latin-1 (ISO-8859-1) is assumed. For supported encoding, see Character Encoding. |
jitterbit.source.db.preserve_char_whitespace
| Variable | jitterbit.source.db.preserve_char_whitespace |
|---|---|
Data Type | Boolean |
| Default | false |
| Description | Preserves whitespace in char(n) database source columns if the length of the data is less than n. |
jitterbit.source.db.schema_name_delimiter
| Variable | jitterbit.source.db.schema_name_delimiter |
|---|---|
Data Type | String |
| Default | . |
| Description | Character used by the source database to delimit the schema name from the table name, such as Schema.Tab. The default is a single period (.), as most databases use a period as the delimiter. |
jitterbit.source.db.trim
| Variable | jitterbit.source.db.trim |
|---|---|
Data Type | Boolean |
| Default | false |
| Description | Trim white-space characters from values read from the database. |
jitterbit.source.file_limit
| Variable | jitterbit.source.file_limit |
|---|---|
Data Type | Integer |
| Description | Maximum number of files to process for a file share or FTP source. This limit is applied after the files have been listed and filtered. |
jitterbit.source.file_share.file_list_limit
| Variable | jitterbit.source.file_share.file_list_limit |
|---|---|
Data Type | Integer |
| Description | This option limits the number of files that are listed for a file share. It is applied before the filter. This option is more efficient than jitterbit.source.file_limit, but it can be used only if all the files in a directory are to be processed. In all other cases, use jitterbit.source.file_limit for file share sources. |
jitterbit.source.ftp.transfer_timeout
| Variable | jitterbit.source.ftp.transfer_timeout |
|---|---|
Data Type | Integer |
| Description | Set the transfer time-out in seconds for FTP source transfers. The default transfer time-out for FTP is four hours (14,400 seconds). Set to zero to disable. |
jitterbit.source.http.max_redirs
| Variable | jitterbit.source.http.max_redirs |
|---|---|
Data Type | Integer |
| Default | 0 |
| Description | Maximum number of redirects to follow when using an HTTP source. Set this variable to a negative number to follow any number of redirects. The default is 0 (zero); no redirects are followed. |
jitterbit.source.http.response.header.HeaderName
| Variable | |
|---|---|
Data Type | String |
| Description | Set when handling a hosted web service call or an HTTP endpoint. HTTP request headers are not exposed, just the payload. When substituted by the name of an HTTP header for For example, the variable |
jitterbit.source.http.ssl_cert_id
| Variable | jitterbit.source.http.ssl_cert_id |
|---|---|
Data Type | String |
| Description | An identifier for a configuration entry in the configuration file |
jitterbit.source.http.transfer_timeout
| Variable | jitterbit.source.http.transfer_timeout |
|---|---|
Data Type | Integer |
| Description | Sets the transfer time-out in seconds for HTTP source transfers. The default transfer time-out for HTTP is one hour (3,600 seconds). Set to zero to disable. |
jitterbit.source.preserve_char_whitespace
| Variable | jitterbit.source.preserve_char_whitespace |
|---|---|
Data Type | Boolean |
| Default | false |
| Description | Set this to |
jitterbit.source.sftp.ssh_key_idjitterbit.target.sftp.ssh_key_id
jitterbit.source.sftp.ssh_key_idjitterbit.target.sftp.ssh_key_id| Variable | |
|---|---|
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.source.text.character_encoding
| Variable | jitterbit.source.text.character_encoding |
|---|---|
Data Type | String |
| Description | Specify the character encoding for text source documents. If no encoding is specified, Latin-1 (ISO-8859-1) is assumed. For supported encoding, see Character Encoding. |
jitterbit.source.text.csv_nullable
| Variable | jitterbit.source.text.csv_nullable |
|---|---|
Data Type | Boolean |
| Description | If set to |
Related Articles
- API Jitterbit Variables
- Global Variable Source
- Global Variable Target
- Global Variable versus Temporary Storage
- Global Variables
- Hosted Endpoint Jitterbit Variables
- Jitterbit Variables
- Operation Jitterbit Variables
- Scripting Jitterbit Variables
- SFDC Jitterbit Variables
- Source Jitterbit Variables
- Specifying Source and Target Fields Dynamically
- Target Jitterbit Variables
- Text Jitterbit Variables
- Transformation Jitterbit Variables
- Web Service Jitterbit Variables
Related Topics
Last updated: Mar 11, 2020
Overview
Content Tools
