DataWorks:Sensors Data data source

Converter type

Feature description

Sample setting

Parameter description

Date2Str

Converts data of the DATE type to data of the STRING type.

// Sample code
"dataConverters":[
    {
        "type": "Date2Str",
        "param": {
            "pattern":"yyyy-MM-dd"
        }
    }
]

pattern (optional): The date format of the data after conversion.

Date2Long

Converts data of the DATE type to data of the LONG type.

"dataConverters":[
    {
        "type": "Date2Long"
    }
]

N/A.

Number2Str

Converts data of the NUMBER type to data of the STRING type.

// Sample code
"dataConverters":[
    {
        "type": "Number2Str"
    }
]

N/A.

Str2Long

Converts data of the STRING type to data of the LONG type.

// Sample code
"dataConverters":[
    {
        "type": "Str2Long"
    }
]

N/A.

Str2Date

Converts data of the STRING type to data of the DATE type.

// Sample code
"dataConverters":[
    {
        "type": "Str2Date",
        "param": {
            "pattern":"yyyy-MM-dd",
            "formats":["yyyyMMdd","yyyyMMddHHmmss"]
        }
    }
]

• pattern (optional): The date and time format of the data after conversion. Valid values: yyyy-MM-dd, yyyy-MM-dd HH:mm:ss, yyyy-MM-dd HH:mm:ss.SSS yyyy-MM, yyyyMM, yyyyMMddHHmmss, and yyyyMMddHHmmssSSS.

• formats (optional): The supported date and time formats for data of the STRING type. This parameter allows you to specify more date and time formats if the values of the pattern parameter do not meet your requirements.

BigInt2Date

Converts data of the BIGINT type to data of the DATE type.

// Sample code
"dataConverters":[
    {
        "type": "BigInt2Date"
    }
]

N/A.

Str2Int

Converts data of the STRING type to data of the INT type.

// Sample code
"dataConverters":[
    {
        "type": "Str2Int"
    }
]

N/A.

Str2Double

Converts data of the STRING type to data of the DOUBLE type.

// Sample code
"dataConverters":[
    {
        "type": "Str2Double"
    }
]

N/A.

Str2BigDecimal

Converts data of the STRING type to data of the BIGDECIMAL type.

// Sample code
"dataConverters":[
    {
        "type": "Str2BigDecimal"
    }
]

N/A.

IfNull2Default

Converts the NULL value to the constant value specified by the default parameter, and then converts the constant value to data of a specified data type by using the sub-converters embedded in the IfNull2Default converter.

// Sample code
// Converts a NULL value or an empty string to the 2021-07-01 string, converts the string to time in the yyyy-MM-dd format, and then converts the time to the timestamp in milliseconds of the LONG type. 
"dataConverters":[
    {
        "type": "IfNull2Default",
        "param": {
            "default": "2021-07-01",
            "dataConverters": [
                {
                    "type": "Str2Date",
                    "param": {
                        "pattern":"yyyy-MM-dd"
                    }
                },
                {
                    "type": "Date2Long"
                }
            ]
        }
    }
]

dataConverters: the sub-converters that are used to convert the default constant value to data of a specified data type. You can specify multiple embedded sub-converters to perform data type conversions for multiple times.

NotNull2Null

Converts a non-NULL value to the NULL value.

// Sample code
"dataConverters":[
    {
        "type": "NotNull2Null"
    }
]

N/A.

IfElse

Checks whether a field value meets a specified IF condition. If the field value meets the condition, the return value is indicated by the value parameter. Otherwise, the return value is indicated by the else parameter.

// Sample code
"dataConverters":[
                  {
                    "type": "IfElse",
                    "param": {
                      "if": "return true;",
                      "value":"if(resolvedValues.get(\"check_card_type\") == 'NAN' && value == null ){return true;} if(resolvedValues.get(\"check_card_type\") == 'ID card'){  if(java.util.regex.Pattern.compile(regEx).matcher(value).find() && java.lang.Integer.parseInt(value.substring(6, 10)) >=1900 && java.lang.Integer.parseInt(value.substring(6, 10)) <= nowYear){return true;}} return null;",
                      "sharedPool":"var nowYear = java.time.LocalDate.now().getYear(); var regEx = \"(110|120|310|510|150|650|540|640|450|230|220|210|120|140|630|370|410|320|340|320|340|330|350|360|430|420|440|460|620|610|520|530)\\\\d{7}(0[1-9]|1[0-2])(0[1-9]|[1-2][0-9]|3[0-1])\\\\d{3}(\\\\d|X)\"; "
                    }
                  }
                ]

• if: the IF condition. The information that you enter is parsed in JavaScript. Make sure that the result is of the BOOLEAN type. The field to which data is written in the Sensors Data data source, the value that is obtained by the plug-in, the param parameter of the data converter, and the parsed fields in the map data structure can be passed to the expression. You can use the targetColumnName, value, param, and resolvedValues parameters to obtain these values.

• value: the return value if the IF condition is met. The information that you enter is parsed in JavaScript. The field to which data is written in the Sensors Data data source, the value that is obtained by the plug-in, the param parameter of the data converter, and the parsed fields in the map data structure can be passed to the expression. You can use the targetColumnName, value, param, and resolvedValues parameters to obtain these values.

• else: the return value if the IF condition is not met. The information that you enter is parsed in JavaScript. The field to which data is written in the Sensors Data data source, the value that is obtained by the plug-in, the param parameter of the data converter, and the parsed fields in the map data structure can be passed to the expression. You can use the targetColumnName, value, param, and resolvedValues parameters to obtain these values.

• sharedPool: the variables or constant values that can be used in the if, value, and else parameters. The information that you enter is parsed in JavaScript.

IfNull2Column

Converts the NULL value to the value of the targetColumnName parameter.

// Sample code
"dataConverters": [
    {
        "type": "IfNull2Column",
        "param": {
            "targetColumnName":"age1"
        }
    }
]

targetColumnName: the name of the field in Sensors Data.