Bulk Get Data(Query) (deprecated)

Operation Name

Bulk Get Data(Query)

Function Overview

This operation performs a Query operation with Bulk API and creates CSV file.

Job Creation, batch creation, batch result obtainment, and job closing will be done subsequently as one operation.

= Remarks =

For details about the API specification used in this operation, refer to the API documentation of the selected version in the connection resource from the following link destination page.

"Salesforce Developer Documentation"-(https://developer.salesforce.com/docs)
- Bulk API Developer's Guide

Properties

= Remarks =

For details on use of variables, refer to Variables.

Basic Settings

Item name	Required/Optional	Use of Variables	Description	Remarks
Name	Required	Not Available	Enter a name that is used on the script canvas.

Required Settings

Item name	Required/Optional	Use of Variables	Description	Remarks
Destination	Required	Not Available	Select a connection resource. Add A new connection resource can be added. Edit list Connection resource settings can be edited in > HULFT INTEGRATE > Connections.	Connection resources for API 29.0 or later versions can be specified.
SOQL	Required	Available	Enter SOQL.	Bulk API query does not support the following SOQL. COUNT ROLLUP SUM GROUP BY CUBE OFFSET Nested SOQL queries Relationship fields Base64 fields
File	Required	Available	Input the file path of the CSV format. The Browse button launches a file chooser that allows you to select a file.	Note Specify an absolute path of HULFT Square Storage for the file path. With the exception of the path separator "/", the Restricted characters of HULFT Square Storage can't be used.
Encoding	Required	Available	Select or enter an encoding for the file to write. When you enter encoding, specify one of the encodings supported in Java SE Runtime Environment 8. = Remarks = For details, refer to "Supported Encodings" (http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html).	The default value is "UTF-8".
New line code	Required	Not available	Select a newline code. CR LF CR+LF (Default)

Property actions

Item name	Description	Remarks
Preview	The previewer is started, and the contents of the file specified in File is displayed.	Disabled when the specified file doesn't exist or a variable is set in File. The contents are displayed with the encoding specified in Encoding. The contents of the file can't be edited. The maximum file size that can be displayed in the previewer is 1MB. If the file size exceeds 1MB, the contents up to 1MB from the beginning of the file will be displayed.

Option Settings

Item name	Required/Optional	Use of Variables	Description	Remarks
Concurrency mode	Required	Not Available	Select the job's concurrency mode. Parallel (Default) The job is created with the parallel processing mode. Serial The job is created with the sequential processing mode.	Note If parallel processing is performed, database conflicts can occur. If there is a severe database conflict, reads may fail. If the sequential processing mode is used, the batches will be reliably processed one after another. However, with this option, the reading processing time may increase greatly.
Waiting Time before the monitoring (sec) starts	Optional	Available	Input the waiting time, until the beginning of the batch state monitoring, in seconds.	The default value is "3". Will be valid only when Obtain the batch results after waiting until the task is completed is checked. A value of 3 or greater and 10800 or smaller can be specified. If a value is specified outside of this range, an error will occur.
Batch monitoring intervals (sec)	Optional	Available	Input the intervals, which determine whether or not the batch results have been obtained and the process has completed, in seconds.	The default value is "10". Will be valid only when Obtain the batch results after waiting until the task is completed is checked. A value of 10 or greater and 600 or smaller can be specified. If a value is specified outside of this range, an error will occur.
Max. monitoring time(sec)	Required	Not Available	Input the maximum monitoring time for the batch state in seconds.	The default value is "14400". Will be valid only when Obtain the batch results after waiting until the task is completed is checked. A value of 1 or greater can be specified. If a value is specified outside of this range, an error will occur.

Comment

Item name	Required/Optional	Use of Variables	Description	Remarks
Comment	Optional	Not Available	You can write a short description of this connector.

Schemas

Input Schema

None.

Output Schema

None.

Mass data processing

Mass data processing isn't supported.

Transaction

Transaction is supported.

Transaction is enabled only when Enable transaction in Transaction is checked.

Parallel Stream Processing

PSP isn't supported.

Available Component variables

Component Variable Name	Description	Remarks
job_id	The IDs of the jobs created are stored.	The default value is null.
batch_id	The IDs of the batches created are stored.	The default value is null.
number_records_processed	The number of records that have completed the process, in the batch, is stored.	The default value is null.
number_records_failed	Stores the number of records that were not successfully processed by the batch.	The default value is null.
created_date	Start time of the batch is stored.	The default value is null.
state	The batch state is stored.	The default value is null.
state_message	The batch state message is stored.	The default value is null.
apex_processing_time	Stores the processing time (ms) of triggers and other processes related to the batch.	The default value is null.
api_active_processing_time	Stores the processing time (ms) of the batch. Does not include time waiting for a queue or for serialization / parallelization.	The default value is null.
total_processing_time	Stores the total processing time (ms) of the batch. Does not include time waiting for a queue.	The default value is null.
system_modstamp	The system time of the batch is stored.	The default value is null.
queryResultCount	Number of files created on the server is stored.	The default value is null.
server_url	The end point URL after Login is stored.	The default value is null.
session_id	The session Id is stored.	The default value is null.
message_category	When an error occurs, the category of the message code corresponding to the error is stored.	The default value is null.
message_code	When an error occurs, the code of the message code corresponding to the error is stored.	The default value is null.
message_level	When an error occurs, the severity of the message code corresponding to the error is stored.	The default value is null.
operation_api_exception_code	The ExceptionCode of the occured error, in a case of API error, is stored.	The default value is null. For any error other than an API Error, the value is not stored.
operation_error_message	When an error occurs, the error message is stored.	The default value is null.
operation_error_trace	When an error occurs, the trace information for the error is stored.	The default value is null.

Message codes, exception messages, and limitations

Connector	Message code	Error message	Limitations
Messages and limitations of the Salesforce(deprecated) connector