Write Job Data

Operation Name

Write Job Data

Function Overview

This operation is to insert or update the job record, using the upsert() call.
Destination object is "SlmJob" (slm__SlmJob__c), included in the AppExchange package.

This operation is using the following API.

Properties

Basic Settings
Item name Required/Optional Use of Variables Description Supplement
Name Required Not Available Enter the name that appears 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].
  
Status Required Not Available Select the status type.
  • [Start]:(default)
    Update the status to "Inprogress".
    Furthermore, update the start time.
  • [Update]
    Update the status to "Inprogress".
  • [Success]
    Update the status to "Success".
    Furthermore, update the end time.
  • [Failed]
    Update the status to "Failed".
    Furthermore, update the end time.
 
Parameter list - - Input the parameters of each column.  
Parameter list/Parameter name - - Display the Parameter name of the column.  
Parameter list/API - - Display the API name of the column.  
Parameter list/Type - - Display the type of the column.  
Parameter list/Value Optional Available Input the value.  
Comment
Item name Required/Optional Use of Variables Description Supplement
Comment Optional Not Available You can write a short description of this adapter.  

Schema

Input Schema

None.

Output Schema

None.

Usage on PSP Script

Cannot be used on PSP Script.

Available Component variables

Component variable name Description Supplement
id ID is stored.
  • The default value is null.
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.
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.
error_type When an error occurs, the type of the error is stored.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The content to be stored may change according to the version of DataSpider Servista.
error_message The error message for the error occurred is stored.
  • The value defaults to null.
  • The content to be stored may change according to the version of DataSpider Servista.
error_trace Stack trace of the occurred error is stored.
  • The value defaults to null.
  • The content to be stored may change according to the version of DataSpider Servista.

Field list of job object

About the fields of job object.
Parameter name Data type Length Required Description Remarks
Job Id Text 255 YES The External ID of the upsert() call.
Enter a unique value. For example, using execution Id and execution time.
Job Name Text 255 Enter a job name.
Will be used in the Job Manager screen.
  • Will be enabled when [Start] is selected from [Status].
Message Text Area 255 Enter a message such as processing count and error information.
Will be confirmed in the job details screen.
Remarks Text Area(Long) 32768 Enter a remarks such as data and error trace.
Will be confirmed in the job details screen.

Main exceptions

Exception Name Reason Resolution
com.sforce.ws.ConnectionException Failed to connect to the server. Check the URL and proxy setting specified in the global resource.
com.sforce.soap.partner.fault.LoginFault Authentication failed. Check the user/password specified in the global resource, and check access limitation for your organization.
com.sforce.soap.partner.fault.InvalidSObjectFault Log Manager for Salesforce Package is not installed in your organization, or specified user does not have access permission. Check your orgnization settings.

Notes