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 is No. • Description - Description of the field. • SQL Literal - Select Yes to insert the value of the field into a SQL statement without quotations (""), else select No. Default is no. • Min occurrence - Specifies the minimum number of times that the field(s) can occur in a given record. Select one of the following: – 0 – 1 – 2 • Max occurrence - Specifies the maximum number of times that the field(s) can occur in a given record. Select one of the following: – 0 – 1 – 2 – Unbounded • Default Value - If applicable, enter the default value. Default values can be applied to target field expressions. Data Type - Select the data type from the dropdown menu. Based on the selected data type, relevant properties are displayed. You must be connected to see the complete data type list. |
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 record for which you want to delete a field and click 
.
.To delete multiple fields, press Ctrl and select multiple fields or press Shift and select a range of fields, and then click 
.
.A message asking for confirmation is displayed.
3. Click Yes.
The selected fields 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 fields and click 
to move the fields up or click 
to move the fields down.
to move the fields up or click to move the fields down.Tip... Press Ctrl to select multiple fields or press Shift and select a range of fields.
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 fields and click 
.
.Tip... Press Ctrl to select multiple fields or press Shift and select a range of fields.
A message asking for confirmation is displayed.
3. Click Yes.
The selected fields 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 fields and click 
to move the fields up or click 
to move the fields down.
to move the fields up or click to move the fields down.Tip... Press Ctrl to select multiple fields or press Shift and select a range of fields.
3. Save the changes.
Last modified date: 02/09/2024