GetReslut(AsyncResult)

Operation Name

GetReslut(AsyncResult)

Function Overview

This operation is to obtain the AsyncResult using the checkStatus(), based on the AsyncResult ID specified in the input data.
Generally, in the case that the setting for the updating-related operations is specified as obtaining results after waiting for the process to be completed, this operation does not need to be used.
If the setting is not specified as obtaining results after waiting for the process to be completed, the results can be obtained at any time by using this component since the processes are executed asynchronously at the server side.
With regarding to the API specification utilized by this operation, please refer to the version of the API document, selected for the Global Resource, in the below-mentioned link.

Data Model

The data model of this component is the Table Model type.

Properties

For information about using variables, refer to "variables".
Basic Settings
Item name Required/Optional Use of Variables Description Supplement
Name Required Not Available Enter the name that appears on the script canvas.  
Input Data Required Not Available Select the component on the script canvas.  
Required Settings
Item name Required/Optional Use of Variables Description Supplement
Destination Required Not Available Select Global Resources.
  • [Add...]:
    Add new global resource.
  • [Edit...]:
    Global resource settings can be edited by [Edit Resource list].
  • A global resource on API 29.0 or earlier versions can be specified.
Large Data Processing Settings
Item name Required/Optional Use of Variables Description Supplement
Large Data Processing Required Not Available Select a Large Data Processing Settings.
  • [Use the setting in the script]:(default)
    Apply Large Data Processing Settings settings of script property to adapter.
  • [Disable Large Data Processing]:
    Large Data Processing is not performed.
  • [Enable Large Data Processing]:
    Large Data Processing is performed.
 
Comment
Item name Required/Optional Use of Variables Description Supplement
Comment Optional Not Available You can write a short description of this adapter.
The description will be reflected in the specifications.
 

Schema

Input Schema

<?xml version="1.0" encoding="UTF-8" ?>
<table>
  <row>
    <column>id</column>
  </row>
  <row>
  :
  </row>
</table>

Element Name Column Name Description Supplement
row
-
Repeats as many times as the number of IDs whose corresponding results to be obtained.  
column id Passes the IDs of AsyncResult whose corresponding results to be obtained.  

Output Schema

<?xml version="1.0" encoding="UTF-8" ?>
<table>
  <row>
    <column>id</column>
    <column>RESULT_inputRowNumber</column>
    <column>RESULT_ASYNC_done</column>
    <column>RESULT_ASYNC_id</column>
    <column>RESULT_ASYNC_message</column>
    <column>RESULT_ASYNC_state</column>
    <column>RESULT_ASYNC_statusCode</column>
  </row>
  <row>
  :
  </row>
</table>

Element Name Column Name Description Supplement
row
-
Repeats as many times as the number of data given to the input schema.
  • If [Not Checked]is selected in [Obtaining results after waiting for the completion of the operation], the repetition will be 0 times.
column id Output the ID given to the input schema.  
RESULT_inputRowNumber Number is output based on the placement of the node within the data given to the input schema.  
RESULT_ASYNC_done Output the completion flag (true,false) of the processing results (AsyncResult).  
RESULT_ASYNC_id Output the ID of the processing results (AsyncResult).  
RESULT_ASYNC_message Output the message of the processing results (AsyncResult).  
RESULT_ASYNC_state Output the status of the processing results (AsyncResult).
  • [Queued]:The processing is not started yet.
  • [InProgress]:The processing is in progress.
  • [Completed]:The processing has been completed.
  • [Error]:The processing has failed.
 
RESULT_ASYNC_statusCode Output the status code of the processing results (AsyncResult).  

Reading Schema by Mapper

The schema will be read automatically.

Large Data Processing

Large Data Processing is supported.

Transaction

Transaction is not supported.

Usage on PSP Script

Cannot be used on PSP Script.

Available Component variables

Component Variable Name Description Supplement
read_count The number of data that was successfully read is stored.
  • The default value is null.
success_count The number of data whose status is "Completed" is stored.
  • The default value is null.
error_count The number of data whose status is "Error" is stored.
  • The default value is null.
inprogress_count The number of data whose status is "Queued" or "InProgress" 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 In the case that an error occurs, the category of the message code corresponding to the error is stored.
  • The default value is null.
message_code In the case that an error occurs, the code of the message code corresponding to the error is stored.
  • The default value is null.
message_level In the case that an error occurs, the importance 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.
  • The content to be stored may change according to the version of DataSpider Servista.
operation_error_message If an error occurs, the error message of the occured error is stored.
  • The default value is null.
  • The content to be stored may change according to the version of DataSpider Servista.
operation_error_trace When an error occurs, the trace information of the occured error is stored.
  • The default value is null.
  • The content to be stored may change according to the version of DataSpider Servista.

Specification Limits

Main exceptions

Exception Name Reason Resolution
ResourceNotFoundException
Resource Definition is Not Found. Name:[]
[Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource Definition is Not Found. Name:[<Global Resource Name>]
The resource definition selected in [Destination] cannot be found. Verify the global resource specified in [Destination]
java.net.UnknownHostException This exception occurs when the PROXY server specified in the global resource cannot be found. Verify the condition of the PROXY server. Or verify [Proxy Host] of the global resource specified in the [Destination].
java.net.SocketTimeoutException
connect timed out
A time-out has occurred while connecting to Salesforce. Verify the network condition and Salesforce server condition. Or check [Connection timeout(sec)] of the global resource specified in the [Destination].
java.net.SocketTimeoutException
Read timed out
A time-out has occurred while waiting for a responce from the server after connecting to Salesforce. Verify the network condition and Salesforce server condition. Or check [Timeout(sec)] of the global resource specified in the [Destination].
com.sforce.soap.partner.fault.LoginFault Login to Salesforce has failed. Check the ExceptionCode or error message, and refer to the information about this type of error in Salesforce-related documents etc.
com.sforce.soap.partner.fault.InvalidFieldFault An item included in the executed SOQL is invalid. Check the ExceptionCode or error message, and refer to the information about this type of error in Salesforce-related documents etc.
com.sforce.soap.partner.fault.UnexpectedErrorFault An unexpected error has occured while processing to Salesforce. Check the ExceptionCode or error message, and refer to the information about this type of error in Salesforce-related documents etc.