isempty
This page explains how to use the isempty function in APL.
The isempty function returns true if the argument is an empty string or null. Use this function to filter out records with missing or empty string values, validate data completeness, or identify fields that need default values.
Usage
Syntax
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| value | scalar | Yes | The value to check for emptiness or null. |
Returns
Returns true if the value is an empty string or null, otherwise returns false.
Use case examples
Identify HTTP requests with missing or empty geographic information for data quality monitoring.
Query
Output
| has_empty_city | has_empty_country | status | incomplete_records |
|---|---|---|---|
| true | false | 200 | 1234 |
| true | true | 404 | 567 |
| false | true | 500 | 234 |
This query identifies requests with incomplete geographic data, helping assess data quality and identify potential issues with geo-IP lookups.
Find traces with missing service information to identify instrumentation gaps.
Query
Output
| empty_service | empty_kind | problematic_spans |
|---|---|---|
| false | true | 234 |
| true | false | 89 |
This query identifies spans with missing required fields, helping improve observability instrumentation by highlighting gaps in trace data.
Detect authentication attempts with missing user identifiers that might indicate anonymized or suspicious activity.
Query
Output
| status | failed_attempts | empty_id_attempts | anonymous_percentage |
|---|---|---|---|
| 401 | 1234 | 345 | 27.96 |
| 403 | 987 | 123 | 12.46 |
This query analyzes the percentage of failed authentication attempts without user IDs, helping security teams identify potential anonymous attack patterns.
List of related functions
- isnotempty: Returns true if a value isn't empty and not null. Use this for the inverse check of isempty.
- isnull: Checks only if a value is null. Use this when you specifically need to test for null without checking for empty strings.
- coalesce: Returns the first non-null or non-empty value. Use this to provide default values for empty fields.
- strlen: Returns the length of a string. Use this when you need to check if a string has content beyond just emptiness.