Use the UpdateWith Block to update existing hierarchical records where one or more child records are contained within the parent record. You can, for example, use an UpdateWith Block to process a Sales Order and use the Add Block to add new Items. See Hierarchical Data.
Note: Operation results from an UpdateWith Block are not available for use in subsequent Blocks.
The behavior when child data is omitted from an UpdateWith operation may vary by Connector. For example, if you use an UpdateWith Block to modify a country, but do not add any of that country's states, the existing states may all be deleted or they may be left alone. Consult the documentation for the specific Connector to determine how such scenarios are handled.
When configuring an UpdateWith Block you need to:
- Select the parent entity that you want to update
- Configure Block Properties Matching Criteria Tab
- Add supported related entities. See Block Properties Include Tab — Hierarchical Entities.
- Map the fields to update in the target record.
- Configure Error Handling.
Note: Change Block Operation Type and Batch Processing are not supported for target Blocks associated with hierarchical data.
Block Properties — General Tab
Block Properties — Matching Criteria Tab
Use the Block Properties Matching Criteria Tab to specify one or more fields in your source and target data that must match to select records for this operation.
For target Blocks that support hierarchical data, use the Include tab to select related entities that you wish to write to the target datastore. For example, if your hierarchy is Country, State, City, Business, and the entity selected for this Block is Country, select State, City, and Business to indicate that you also want to modify that data for each Country. To include the related child information, use one or more Add Blocks inside this Block. See Block Properties Include Tab — Hierarchical Entities.
Block Properties — Fields Tab
From the Block Properties Fields Tab, you can:
- Create links between source and target data fields, including fields from the relationships that you specified in the Query Block or Fetch Block:
- Source fields from parent entities are available in all Blocks.
- Source fields from child entities are only available within a For Each Child Block for that child relationship. See Mapping Hierarchical Data Fields.
- Target fields for entities with one to one relationships with the entity selected on the General tab display only if the related entities are selected on the Include tab for the target operation Block, such as CreateWith or UpdateWith.
- Autolink one or more source and target fields that have the same name, compatible data types, and are not read-only. Fields for child entities do not Autolink. You may need to clear some fields linked by Autolink, such as any modifiedon or createdon datetime fields. See Autolinking.
- Create simple or complex formulas to transform source data. See Formula Editor.
- View detailed information about any field in your source or target using the Info icon .
When using the Fields tab, you can:
- Use column filters to find specific data in the source or target pane as described in Using The Filter Dialog.
- Select any column head to sort all fields in the pane by that column.
Note: When you first open the Fields tab, the icon displays and the Errors/ Warnings tab indicates that there are Errors and Warnings. This is expected behavior. Errors and Warnings display for the General and Fields tabs until all required data has been entered and the Validate button has been selected. See Block And Map Errors And Warnings.
Block Properties — Error Handling Tab
Use the Error Handling options to enable or disable logging Error messages in the Execution History log when a Block operation encounters a problem. For the UpdateWith Block, errors can be logged as follows:
- When an operation fails — If the record cannot be updated, 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 updated, and an error is logged.
See Block Properties Error Handling Tab for additional information.
If this setting is checked, an error from any part of the data, parent or child, generates a record error and no more Blocks execute for that record. If the setting is unchecked, no error is written to the log and the Map continues running with the text of the error available in the Result Fields.
Note: For most runtime errors, the error handling setting on the CreateWith, UpdateWith, or UpsertWith Block supersedes the error handling set on any Add Blocks within it, even if the problem is generated by one of the fields in the Add Block.
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.