gettype()

Applies to: ✅ Microsoft FabricAzure Data ExplorerAzure MonitorMicrosoft Sentinel

Returns the runtime type of its single argument.

The runtime type may be different than the nominal (static) type for expressions whose nominal type is dynamic; in such cases gettype() can be useful to reveal the type of the actual value (how the value is encoded in memory).

Syntax

gettype(value)

Learn more about syntax conventions.

Parameters

Name Type Required Description
value scalar ✔️ The value for which to find the type.

Returns

A string representing the runtime type of value.

Examples

Expression Returns
gettype("a") string
gettype(111) long
gettype(1==1) bool
gettype(now()) datetime
gettype(1s) timespan
gettype(parse_json('1')) int
gettype(parse_json(' "abc" ')) string
gettype(parse_json(' {"abc":1} ')) dictionary
gettype(parse_json(' [1, 2, 3] ')) array
gettype(123.45) real
gettype(guid(12e8b78d-55b4-46ae-b068-26d7a0080254)) guid
gettype(parse_json('')) null