User Guide : Managing Schemas : Exploring Schema Editor : Managing Fields in Records
 
Share this page                  
Managing Fields in Records
You can add, delete, or reorder the fields in a record.
Adding Fields to a Record in JSON Schema
To add fields to a record, in the left pane, expand the tree and click the required record node (example, R1) and then click /download/attachments/25954037/Map_Source_Add_Icon.png?version=1&modificationDate=1493578526312&api=v2. A field is added to the grid and displays the following columns:
Column Name
Description
Field
Name of the field. To change the name, click the name and type the required name.
Description
Description about the field. Click within cell and type a description.
Type
From the drop-down list, select the required data type.
Note:  Only connectors that support record hierarchy has the Record data type available.
Size
From the drop-down list, select the data type size.
Properties
Click /download/attachments/25954037/Map_Mapping_PropertiesIcon.png?version=1&modificationDate=1493578526296&api=v2 or right-click on the row for which you want to specify the field properties, and click Properties. The Field Properties window is displayed. You can specify the following properties for a field:
• Field Required - Select Yes if the field is required. Else, select No.
• Default Expression - Edit directly in the cell or click ... to open the Expression Editor.
• Abstract - Select Yes if the field is required. Else, select No.
• SQL Literal - Select Yes if the field is required. Else, select No.
• Min occurrence - Select any of the following:
– 0
– 1
– 2
• Max occurrence - Select any of the following:
– 0
– 1
– 2
– Unbounded
• Default Value
• Data Type - Select the required data type. Based on the selected data type, the properties are displayed.
Deleting Fields in a Record in JSON Schema
To delete a field in the record:
1. In the left pane, expand All Record Types.
2. Click the required record for which you want to delete a field and click /download/attachments/25954037/Map_Mapping_DeleteField_Icon.png?version=1&modificationDate=1493578526202&api=v2.
To delete multiple fields, press the Ctrl key and select the required fields or press the Shift key and select a range of fields, and then click /download/attachments/25954037/Map_Mapping_DeleteField_Icon.png?version=1&modificationDate=1493578526202&api=v2.
A message asking for confirmation is displayed.
3. Click Yes.
The selected field(s) are deleted.
Reordering Fields in a Record in JSON Schema
To reorder the fields in a record:
1. In the left pane, expand All Record Types.
2. Click the required record node for which you want to reorder the fields.
3. In the right-pane grid, select the field that you want to move and click /download/attachments/25954037/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1493578526343&api=v2 to move the field(s) up or click /download/attachments/25954037/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1493578526327&api=v2 to move the field(s) down.
To move multiple fields, press the Ctrl key and select the required fields or press the Shift key and select a range of fields, and then click /download/attachments/25954037/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1493578526343&api=v2 or /download/attachments/25954037/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1493578526327&api=v2.
Adding Fields to a Record in XML Schema
To add fields to a record, in the left pane, expand the tree and click the required record node (example, R1). In the right-pane, click /download/attachments/25954037/Map_Source_Add_Icon.png?version=1&modificationDate=1493578526312&api=v2. A field is added to the grid and displays the following columns:
Column Name
Description
Field
Name of the field. To change the name, click the name and type the required name.
Description
Description about the field. Click within cell and type a description.
Type
From the drop-down list, select the required data type.
Note:  Only connectors that support record hierarchy has the Record data type available.
Size
From the drop-down list, select the data type size.
Properties
Click /download/attachments/25954037/Map_Mapping_PropertiesIcon.png?version=1&modificationDate=1493578526296&api=v2 or right-click on the row for which you want to specify the field properties, and click Properties. The Field Properties window is displayed. You can specify the following properties for a field:
• Field Required - Select Yes if the field is required. Else, select No.
• Default Expression - Edit directly in the cell or click ... to open the Expression Editor.
• Data Type - Select the required data type. Based on the selected data type, the properties are displayed.
Deleting Fields in a Record in XML Schema
To delete a field in the record:
1. In the left pane, expand All Records and click the required record node for which you want to delete a field.
2. In the right-pane, select the field that you want to delete and click /download/attachments/25954037/Map_Mapping_DeleteField_Icon.png?version=1&modificationDate=1493578526202&api=v2.
To delete multiple fields, press the Ctrl key and select the required fields or press the Shift key and select a range of fields, and then click /download/attachments/25954037/Map_Mapping_DeleteField_Icon.png?version=1&modificationDate=1493578526202&api=v2.
A message asking for confirmation is displayed.
3. Click Yes.
The selected field(s) are deleted.
Reordering Fields in a Record in XML Schema
To reorder the fields in a record:
1. In the left pane, expand All Records and click the required record node for which you want to reorder the fields.
2. In the right-pane, select the field that you want to move and click /download/attachments/25954037/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1493578526343&api=v2 to move the field(s) up or click /download/attachments/25954037/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1493578526327&api=v2 to move the field(s) down.
To move multiple fields, press the Ctrl key and select the required fields or press the Shift key and select a range of fields, and then click /download/attachments/25954037/Map_Source_UpArrow_Icon.png?version=1&modificationDate=1493578526343&api=v2 or /download/attachments/25954037/Map_Source_DownArrow_Icon.png?version=1&modificationDate=1493578526327&api=v2.
3. Save the changes.