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 
. A field is added to the grid and displays the following columns.
. A field is added to the grid and displays the following columns.To insert a field in the middle of a field list, select the row before which you want to add the field and click 
. A new field will be added before the selected row. If no row is selected, then the new field is added to the end of the field list. If all fields are selected and you insert a new field, the new field will be inserted at the end of the field list.
. A new field will be added before the selected row. If no row is selected, then the new field is added to the end of the field list. If all fields are selected and you insert a new field, the new field will be inserted at the end of the field list.The same behavior occurs when you right-click and select Add Field or when you use the <Insert> key.
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  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 
.
.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 
.
.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 
to move the field(s) up or click 
to move the field(s) down.
to move the field(s) up or click 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 
or 
.
or .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 
. A field is added to the grid and displays the following columns.
. A field is added to the grid and displays the following columns.To insert a field in the middle of a field list, select the row before which you want to add the field and click 
. A new field will be added before the selected row. If no row is selected, then the new field is added to the end of the field list. If all fields are selected and you insert a new field, the new field will be inserted at the end of the field list. The same behavior occurs when you right-click and select Add Field or when you use the <Insert> key.
. A new field will be added before the selected row. If no row is selected, then the new field is added to the end of the field list. If all fields are selected and you insert a new field, the new field will be inserted at the end of the field list. The same behavior occurs when you right-click and select Add Field or when you use the <Insert> key. 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  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 
.
.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 
.
.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 
to move the field(s) up or click 
to move the field(s) down.
to move the field(s) up or click 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 
or 
.
or .3. Save the changes.
Last modified date: 08/02/2023