Item name |
Required/Optional |
Use of Variables |
Description |
Supplement |
Obtaining results after waiting for the completion of the operation |
Optional |
Not Available |
The processes are asynchronously executed at the server side after issuing a request.
Select whether or not to monitor the situation until the server-side processings are finished, and to obtain the results.
- [Checked]:(default)
Wait until the processes are finished, and then obtain the results.
- [Not Checked]:
Obtain the results immediately after the request, without waiting for the processes to be finished.
|
- Valid only when selecting API 29.0 or earlier.
|
Wait Time before the start of monitoring (sec) |
Optional |
Available |
Enter the waiting time, until the beginning of monitoring, in seconds. |
- Valid only when selecting API 29.0 or earlier.
- Will be valid and required only when [Obtaining results after waiting for the completion of the operation] is checked.
- The default value is "3".
|
Monitoring Interval (sec) |
Optional |
Available |
Enter the monitoring intervals. |
- Valid only when selecting API 29.0 or earlier.
- Will be valid and required only when [Obtaining results after waiting for the completion of the operation] is checked.
- The default value is "10".
|
Element Name |
Column Name |
Description |
Supplement |
row |
- |
Repeats as many times as the number of picklist values to be inserted. |
|
column |
fullName |
Gives the picklist values. |
|
default |
Gives the default (true,false). |
- Please give a value only for items bearing this field.
|
color |
Gives the color of the graph. |
- Gives in hexadecimal form.
- Please give a value only for items bearing this field.
|
allowEmail |
Gives the email permission (true,false). |
- Applied for the "Status" of the "Quote", etc.
- Please give a value only for items bearing this field.
|
closed |
Gives the completion flag (true,false). |
- Applied for "Status" of "Case" and "ToDo(Task)", "Stage" of "Opportunity", etc.
- Please give a value only for items bearing this field.
|
converted |
Gives the already started transaction (true,false). |
- Applied for the "Lead Status" of the "Lead", etc.
- Please give a value only for items bearing this field.
|
cssExposed |
Gives the usable within self service (true,false). |
- Applied for the "Reason" of the "Case", etc.
- Please give a value only for items bearing this field.
|
description |
Gives the description. |
- Applied for the "Stage" of the "Opportunity", etc.
- Please give a value only for items bearing this field.
|
forecastCategory |
Gives the sales forecast category.
- Omitted
- Pipeline
- BesCase
- Forecast
- Closed
|
- Applied for the "Stage" of the "Opportunity", etc.
- Please give a value only for items bearing this field.
- Case sensitive. Giving a category that does not exist will lead to an update failure.
|
highPriority |
Gives the high priority (true,false). |
- Applied for the "Priority" of the "ToDo(Task)", etc.
- Please give a value only for items bearing this field.
|
probability |
Gives the probability. |
- Applied for the "Stage" of the "Opportunity", etc.
- Please give a value only for items bearing this field.
|
reverseRole |
Gives the role from the counterpart's view. |
- Applied for the "ReverseRole" of the "PartnerRole", etc.
- Please give a value only for items bearing this field.
|
reviewed |
Gives the already reviewed flag (true,false). |
- Applied for the "Status" of the "Solution", etc.
- Please give a value only for items bearing this field.
|
won |
Gives the won flag (true,false). |
- Applied for the "Stage" of the "Opportunity", etc.
- Please give a value only for items bearing this field.
|
Element Name |
Column Name |
Description |
Supplement |
row |
- |
Repeats as many times as the number of data given to the input schema. |
|
column |
fullName |
The picklist value, given to the input schema, is output. |
|
default |
The default (true, false), given to the input schema, is output. |
|
color |
The color of the graph, given to the input schema, is output. |
|
allowEmail |
The email permission (true, false), given to the input schema, is output. |
|
closed |
The completion flag (true, false), given to the input schema, is output. |
|
converted |
The already started transaction (true, false), given to the input schema, is output. |
|
cssExposed |
The usable within self service (true,false), given to the input schema, is output. |
|
description |
The description, given to the input schema, is output. |
|
forecastCategory |
The sales forecast category, given to the input schema, is output. |
|
highPriority |
The high priority (true,false), given to the input schema, is output. |
|
probability |
The probability, given to the input schema, is output. |
|
reverseRole |
The role from the counterpart's view, given to the input schema, is output. |
|
reviewed |
The already reviewed flag (true,false), given to the input schema, is output. |
|
won |
The won flag (true,false), given to the input schema, is output. |
|
RESULT_inputRowNumber |
The number, based on the position of the node in the data which was given to the input schema, is output. |
|
RESULT_ASYNC_done |
The completion flag (true,false) of the processing results(AsyncResult) is output. |
- In the below mentioned cases, the Salesforce adapter will output the status code and message.
In this case, null will be output for [RESULT_ASYNC_done] and [RESULT_ASYNC_id], and [Error] will be output for [RESULT_ASYNC_state].
- SALESFORCE_ADAPTER_ILLEGAL_DATA_TYPE
This is set when the defined item's attribute and the input data type do not match. For example, when a non-numerical character row is entered to the [probability].
- SALESFORCE_ADAPTER_REQUIRED_FIELD
This is set when a value is not given to a required schema. For example, when null is entered to the [fullName].
- SALESFORCE_ADAPTER_ENUMERATED_TYPE_NOT_MATCH
This is set when a value, given to an enumeration type schema, is invalid. For example, when a non-existing category is entered to the [forecastCategory].
|
RESULT_ASYNC_id |
The ID of the processing results(AsyncResult) is output. |
RESULT_ASYNC_message |
The message of the processing results(AsyncResult) is output. |
RESULT_ASYNC_state |
The state of the processing results(AsyncResult) is output.
- [Queued]:The process has not begun.
- [InProgress]:Currently processing.
- [Completed]:The process has completed.
- [Error]:The process was not successful.
|
RESULT_ASYNC_statusCode |
The status code of the processing results(AsyncResult) is output. |
Element Name |
Column Name |
Description |
Supplement |
row |
- |
Repeats as many times as the number of data given to the input schema. |
|
column |
fullName |
The picklist value, given to the input schema, is output. |
|
default |
The default (true, false), given to the input schema, is output. |
|
color |
The color of the graph, given to the input schema, is output. |
|
allowEmail |
The email permission (true, false), given to the input schema, is output. |
|
closed |
The completion flag (true, false), given to the input schema, is output. |
|
converted |
The already started transaction (true, false), given to the input schema, is output. |
|
cssExposed |
The usable within self service (true,false), given to the input schema, is output. |
|
description |
The description, given to the input schema, is output. |
|
forecastCategory |
The sales forecast category, given to the input schema, is output. |
|
highPriority |
The high priority (true,false), given to the input schema, is output. |
|
probability |
The probability, given to the input schema, is output. |
|
reverseRole |
The role from the counterpart's view, given to the input schema, is output. |
|
reviewed |
The already reviewed flag (true,false), given to the input schema, is output. |
|
won |
The won flag (true,false), given to the input schema, is output. |
|
RESULT_inputRowNumber |
The number, based on the position of the node in the data which was given to the input schema, is output. |
|
RESULT_success |
The success flag (true,false) of the processing results(SaveResult) is output. |
- In the below mentioned cases, the Salesforce adapter will output the status code and message.
In this case, null will be output for [RESULT_ASYNC_done] and [RESULT_ASYNC_id], and [Error] will be output for [RESULT_ASYNC_state].
- SALESFORCE_ADAPTER_ILLEGAL_DATA_TYPE
This is set when the defined item's attribute and the input data type do not match. For example, when a non-numerical character row is entered to the [probability].
- SALESFORCE_ADAPTER_REQUIRED_FIELD
This is set when a value is not given to a required schema. For example, when null is entered to the [fullName].
- SALESFORCE_ADAPTER_ENUMERATED_TYPE_NOT_MATCH
This is set when a value, given to an enumeration type schema, is invalid. For example, when a non-existing category is entered to the [forecastCategory].
|
RESULT_fullName |
The FullName of the processing results(SaveResult) is output. |
RESULT_message |
The Message of the processing results(SaveResult) is output. |
RESULT_statusCode |
The StatusCode of the processing results(SaveResult) is output. |
Component Variable Name |
Description |
Supplement |
read_count |
The number of passed data is stored. |
- The default value is null.
|
insert_count |
The number of data that was successful in the insertion processing is stored. |
- The default value is null.
|
error_count |
The number of data that was unsuccessful in the insertion processing is stored. |
- The default value is null.
|
inprogress_count |
The number of data in processing is stored. |
- The default value is null.
- If [Checked] is selected in [Obtaining results after waiting for the completion of the operation], this becomes 0.
- Stored only when selecting API 29.0 or earlier.
|
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.
|
Number in the Image |
Name |
Description |
Supplement |
(1) |
Table Name |
Select the table whose structure to be shown. |
|
(2) |
Table Information |
Display the available operations on the selected table. |
|
(3) |
Length |
Display the Number of Digit of item |
|
(4) |
External ID |
Display whether or not the object item is set as an external ID. |
|
(5) |
Createble |
Display whether or not it can be set a value when adding data. |
|
(6) |
Updatable |
Display whether or not it can be set a value when updating data. |
|
(7) |
Nullable |
Display whether or not it can be set NULL when adding or updating data. |
|
(8) |
Default value |
Display whether or not Salesforce automatically set a default value when adding data. |
|
(9) |
Reference To |
Display the referring object name if the item is in reference relationship or master-servant relationship. |
|
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]. |
jp.co.headsol.salesforce.adapter.exception.SalesforceAdapterIllegalArgumentException |
Invalid value is set for the property of Salesforce adapter. |
Check the error message, and verify the settings. |
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. |