Delete Block
Use a Delete Block to delete records from the specified datastore. When configuring a Delete Block, you need to:
- Select the entity from which you want to delete records
- Configure the Block Properties Matching Criteria Tab so TIBCO Scribe® Online can locate and delete the correct records.
Block Properties — General Tab
From the Block Properties General Tab, you can change the Block Label, add a description, set batch processing options, and select the entity to use for this operation.
Set Batch Processing Options
Note: Error handling options configured on the Error Handling tab are disabled if Batch Processing is enabled on the Block Properties General tab. When Batch Processing is enabled, the following text is displayed on the Error Handling tab:
Batch processing is enabled, records with errors are processed by subsequent Blocks.
If your Connection supports batch, or bulk, processing, the Batch Processing option is available.
Note: For Salesforce Connections, see TIBCO Scribe® Online Connector For Salesforce for additional information.
- Select the Process This Operation In Batches Of checkbox.
- Select the size of the batch; from 1 to 10,000.
When the Solution runs, the source records are stored and then processed in batches of the specified number of records for this Block.
Block Properties — Matching Criteria Tab
Use the Block Properties Matching Criteria Tab to specify one or more fields in your source and target data to use for selecting records to delete.
Block Properties — Error Handling Tab
Note: Error handling options configured on the Error Handling tab are disabled if Batch Processing is enabled on the Block Properties General tab. When Batch Processing is enabled, the following text is displayed on the Error Handling tab:
Batch processing is enabled, records with errors are processed by subsequent Blocks.
Use the Error Handling options to enable or disable processing this record when a Block operation encounters a problem. For the Delete Block, errors can be logged as follows:
- When an operation fails — If the record cannot be deleted, an error is logged.
- If no matches are found — If the record being processed does not match the criteria in the Matching Criteria tab, it is not deleted, and an error is logged.
See Block Properties Error Handling Tab for additional information.
Block Properties — Errors And Warnings Tab
If there are any errors or warnings for this Block, the Errors and Warnings tab displays the number of errors or warnings in the tab name. See Block And Map Errors And Warnings.
Once you have corrected the errors, select the Validate button to update the Errors and Warnings tab.