SourceFields parameters
- Last UpdatedSep 06, 2023
- 2 minute read
Refer to the following table for information on the parameters to configure for the source fields.
Note: If you are going to update the record in the external database by an ID field (possibly an auto-increment field that is not in the record), specify it here to use later in the Update Command (and Update Database Parameters).
|
Parameter |
Description |
|---|---|
|
Name |
The exact name of the column returned in the Select Command. |
|
Allow Nulls |
Determines whether to use the Default Value if a Null is returned from the Select Command. A null is classified as an empty string, or more specifically, the value between the Separation Character trimmed of spaces being empty. |
|
Data Type |
The data type of the field. If this parameter is set to DateTime, the only format accepted is “yyyy-MM-ddTHH:mm:ssZ” which is the ISO 8061 standard for date times. The value must be in UTC. |
|
Default Value |
This parameter is applicable only when the Allow Nulls is False. It specifies the value to use when a null is encountered. |
|
Schema Usage |
Specify as Required or Optional. For this integration, every field that is pivoted (that is, possible values returned from the Pivot Column parameter) is marked as Optional. The Grouping Columns and Passed Through Columns are defined as Required. With the use of the Table 2 example, DateField, NumericField and StringField are Optional, while SampleId, SampleDateTime, and Id are required. |
|
Max Length |
This is parameter is applicable only when the Data Type is String. It specifies the maximum length of the string. |
|
Date Time Mode |
(Utc or Local) – This is only applicable if the Data Type is DateTime. It signifies if the date being returned is Local time or Utc time. As AVEVA™ Production Management stores dates in UTC, it uses this to determine whether to convert the date before storing it. |