Use the isint function in APL to check whether a numeric value is an integer, meaning it has no fractional component. The function returns true for both positive and negative integer values and false for floating-point values, NaN, or infinity.

isint is useful for data validation and type-checking in observability queries. For example, you can use it to verify that computed fields or imported values are whole numbers before performing integer-specific operations such as array indexing or factorial-based calculations.

#For users of other query languages

If you come from other query languages, this section explains how to adjust your existing queries to achieve the same results in APL.

['sample-http-logs']
| extend is_int = isint(value)

['sample-http-logs']
| extend is_int = isint(value)

#Usage

#Syntax

isint(expression)

#Parameters

#Returns

true if the value is a positive or negative integer (no fractional part). false for non-integer real numbers, NaN, and infinity.

#Example

Use isint to check whether a value is of integer type.

Query

print a = isint(42), b = isint(4.2)

Run in Playground

Output

#List of related functions

• isfinite: Returns true for values that are neither infinite nor NaN. Use it for a broader check covering all valid float states.
• isinf: Returns true only for infinite values. Use it to detect overflow results specifically.
• isnan: Returns true only for NaN values. Use it to detect undefined computation results.
• round: Rounds a value to a given precision. Use it to produce integer-valued results before applying isint.
• sign: Returns the sign of a value. Use it alongside isint when you need both the sign and the integer-status of a value.