Delete Item

Operation Name

Delete Item

Function Overview

Deletes item that match with primary key received from input data in items that exist in Amazon DynamoDB tables.

In this operation, DeleteItem API or BatchWriteItem API is available. Refer to the following page about API specification.

Data Model

Table model type.

Properties

For the use of variables, refer to "Variable".
Basic settings
Item name Required/Optional Use of variables Description Remarks
Name Required Not available Enter the name to show 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 Remarks
Destination Required Not available Select a global resource.
  • [Add]:
    Adds a new global resource.
  • [Edit list]:
    Enables to edit the global resource setting on " Resource edit list" screen.
  
Table name Required Available Select or enter the name of table to perform delete item.  
Primary key list Required - Specifies primary key list of table specified in [Table name] or index specified in [Index name].  
Primary key list/Hash key Optional Not available Shows whether or not the table specified in [Table name] or index specified in [Index name].  
Primary key list/Range key Optional Not available Shows whether or not the range key attribute of the table specified in [Table name] or index specified in [Index name].  
Primary key list/Attribute name Required Available Shows whether or not the attribute name of table specified in [Table name] or attribute name of index specified in [Index name].
  • Shows specified attribute name to mapper schema.
Primary key list/Type Required Not available Select [Attribute name] type.
  • Shows as "<DynamoDB data type> (<inner data type>)" format.
    • DynamoDB data type:
      Data type supported by Amazon DynamoDB.
    • Inner data type:
      Data type used in inner DataSpider.
      For details, refer to "Inner data type".
Property action
Item name Description Remarks
Update table name list Receives table name in specified destination and sets to [Table name].  
Update primary key list Update primary key list of table specified in [Table name].
  • Enabled, if [Table name] is specified.
  • Extracts primary key data types from items which are retrieved by performing Scan on the table specified in [Table name].
  • Sets data types to [String (String)] regardless of the actual primary key types if there are no items in the table specified in [Table name].
Write settings
Item name Required/Optional Use of variables Description Remarks
Enable batch writing Optional Not available Select whether to enable batch writing or not.
  • [Checked]:
    Performs batch writing.
  • [Not checked]:(default)
    Does not perform batch writing.
  • If [Checked] is selected in [Enable batch writing], sends delete item request by maximum 25 cases.
Comment
Item name Required/Optional Use of variables Description Remarks
Comment Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.		  

Schema

Input Schema

Column number differs depending on the setting of [Primary key list].
For details on schema structure, refer to "Table model type schema".

Output Schema

None.

Loading Schema on Mapper

Schema is loaded automatically.
For details, refer to "Edit Schema".

Transaction

Transaction is not supported.

PSP Usage

PSP is supported.
For details on PSP, refer to "Parallel Stream Processing".

Available Component Variables

Component variable name Description Remarks
count Stores the number of sent delete request.
  • Default value is null.
message_category Stores the category of message code corresponding to the occurred error.
  • Default value is null.
message_code Stores the code of message code corresponding to the occurred error.
  • Default value is null.
message_level Stores the severity of message code corresponding to the occurred error.
  • Default value is null.
error_type Stores the error type of occurred error.
  • Default value is null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The value may vary depending on the DataSpider Servista version.
error_message Stores the error message of occurred error.
  • Default value is null.
  • The value may vary depending on the DataSpider Servista version.
error_trace Stores the trace information of occurred error.
  • Default value is null.
  • The value may vary depending on the DataSpider Servista version or the client application used.

Specification Limits

For specification limits common to each operations, refer to "Amazon DynamoDB Adapter Restriction".

Main Exceptions

Exception name Cause Solution
ResourceNotFoundException
Resource definition could not be found. Name:[]		 [Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition could not be found. Name:[<Global resource name>]		 Resource definition specified in [Destination] is not found. Check global resource specified in [Destination].
InvalidPropertyConfigurationException
<Property name> is not specified.		 [<Property name>] is not specified. Specify [<Property name>].

Notes