Skip to main content

Validation

ISALPHA

​​❌ Cannot be used in filter queries

Checks if the input text contains only letters (a-zA-Z).

Syntax‌‌

ISALPHA(text, locale)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.
localeoptionalLocale, which defines the langulage/region. Locale is one of "ar", "ar-AE", "ar-BH", "ar-DZ", "ar-EG", "ar-IQ", "ar-JO", "ar-KW", "ar-LB", "ar-LY", "ar-MA", "ar-QA", "ar-QM", "ar-SA", "ar-SD", "ar-SY", "ar-TN", "ar-YE", "bg-BG", "cs-CZ", "da-DK", "de-DE", "el-GR", "en-AU", "en-GB", "en-HK", "en-IN", "en-NZ", "en-US", "en-ZA", "en-ZM", "es-ES", "fa-IR", "fr-CA", "fr-FR", "he", "hu-HU", "it-IT", "ku-IQ", "nb-NO", "nl-NL", "nn-NO", "pl-PL", "pt-BR", "pt-PT", "ru-RU", "sl-SI", "sk-SK", "sr-RS", "[email protected]", "sv-SE", "tr-TR", "uk-UA". Defaults to en-US.

ISALPHANUM

​​❌ Cannot be used in filter queries

Checks if the input text contains only letters and numbers (a-zA-Z0-9)

Syntax‌‌

ISALPHANUM(text, locale)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.
localeoptionalLocale, which defines the langulage/region. Locale is one of "ar", "ar-AE", "ar-BH", "ar-DZ", "ar-EG", "ar-IQ", "ar-JO", "ar-KW", "ar-LB", "ar-LY", "ar-MA", "ar-QA", "ar-QM", "ar-SA", "ar-SD", "ar-SY", "ar-TN", "ar-YE", "bg-BG", "cs-CZ", "da-DK", "de-DE", "el-GR", "en-AU", "en-GB", "en-HK", "en-IN", "en-NZ", "en-US", "en-ZA", "en-ZM", "es-ES", "fa-IR", "fr-CA", "fr-FR", "he", "hu-HU", "it-IT", "ku-IQ", "nb-NO", "nl-NL", "nn-NO", "pl-PL", "pt-BR", "pt-PT", "ru-RU", "sl-SI", "sk-SK", "sr-RS", "[email protected]", "sv-SE", "tr-TR", "uk-UA". Defaults to en-US

ISARRAY

​​❌ Cannot be used in filter queries

Checks if the input is an array (list of values) or not.

Syntax‌‌

ISARRAY(value)

NameTypeDescription
valuemandatoryCan be any valid expression as long as it resolves to an object value.

ISASCII

​​❌ Cannot be used in filter queries

Checks if the input text contains ASCII chars only or not.

Syntax‌‌

ISASCII(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISBIC

​​❌ Cannot be used in filter queries

Checks if the input text is a BIC (Bank Identification Code) or SWIFT code or not.

Syntax‌‌

ISBIC(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISBOOLEAN

​​❌ Cannot be used in filter queries

Checks if the input text is a boolean or not.

Syntax‌‌

ISBOOLEAN(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISCREDITCARD

​​❌ Cannot be used in filter queries

Checks if the input text is a credit card number or not.

Syntax‌‌

ISCREDITCARD(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISDATE

​​❌ Cannot be used in filter queries

Checks if the input text is a valid date (in ISO 8601 or RFC 2822 format) or not.

Syntax‌‌

ISDATE(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISDECIMAL

​​❌ Cannot be used in filter queries

Checks if the input text is decimal number (such as 0.25, .4, 3,56, 2.00065, 12.0) or not.

Syntax‌‌

ISDECIMAL(text, locale)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.
localeoptional

Locale, which defines the langulage/region. Locale is one of "ar", "ar-AE", "ar-BH", "ar-DZ", "ar-EG", "ar-IQ", "ar-JO", "ar-KW", "ar-LB", "ar-LY", "ar-MA", "ar-QA", "ar-QM", "ar-SA", "ar-SD", "ar-SY", "ar-TN", "ar-YE", "bg-BG", "cs-CZ", "da-DK", "de-DE", "el-GR", "en-AU", "en-GB", "en-HK", "en-IN", "en-NZ", "en-US", "en-ZA", "en-ZM", "es-ES", "fa-IR", "fr-CA", "fr-FR", "he", "hu-HU", "it-IT", "ku-IQ", "nb-NO", "nl-NL", "nn-NO", "pl-PL", "pt-BR", "pt-PT", "ru-RU", "sl-SI", "sk-SK", "sr-RS", "[email protected]", "sv-SE", "tr-TR", "uk-UA".

Defaults to en-US

ISEMAIL

​​❌ Cannot be used in filter queries

Checks if the input text is an email address or not.

Syntax‌‌

ISEMAIL(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISEMPTY

​​❌ Cannot be used in filter queries

Checks if the input text has any value or not.

Syntax‌‌

ISEMPTY(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISIBAN

​​❌ Cannot be used in filter queries

Checks if the input text is an IBAN (International Bank Account Number) or not.

Syntax‌‌

ISIBAN(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISIMEI

​​❌ Cannot be used in filter queries

Checks if the input text is a valid IMEI (International Mobile Equipment Identity) number or not.

Syntax‌‌

ISIMEI(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISINTEGER

​​❌ Cannot be used in filter queries

Checks if the input text is an integer or not.

Syntax‌‌

ISINTEGER(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISIP

​​❌ Cannot be used in filter queries

Checks if the input text is an IP address (version 4 or 6) or not.

Syntax‌‌

ISIP(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISISBN

​​❌ Cannot be used in filter queries

Checks if the input text is an ISBN (International Standard Book Number version 10 or 13) or not.

Syntax‌‌

ISISBN(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISISRC

​​❌ Cannot be used in filter queries

Checks if the input text is an ISRC (International Standard Recording Code) or not.

Syntax‌‌

ISISRC(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISISSN

​​❌ Cannot be used in filter queries

Checks if the input text is an ISSN (International Standard Serial Number) or not.

Syntax‌‌

ISISSN(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISLOWERCASE

​​❌ Cannot be used in filter queries

Checks if the input text is lowercase or not.

Syntax‌‌

ISLOWERCASE(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISMACADDRESS

​​❌ Cannot be used in filter queries

Checks if the input text is a MAC (media access control) address or not.

Syntax‌‌

ISMACADDRESS(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISMOBILEPHONE

​​❌ Cannot be used in filter queries

Checks if the input text is a mobile phone number (with a "+" and a country code, e.g., +12345678901 in E.164 format) or not.

Syntax‌‌

ISMOBILEPHONE(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISNUMERIC

​​❌ Cannot be used in filter queries

Checks if the input text contains only numbers or not.

Syntax‌‌

ISNUMERIC(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISOBJECT

​​❌ Cannot be used in filter queries

Checks if the input is an object or not.

Syntax‌‌

ISOBJECT(value)

NameTypeDescription
valuemandatoryCan be any valid expression as long as it resolves to an object value.

ISSTRONGPWD

​​❌ Cannot be used in filter queries

Checks if the input password is strong by checking whether it includes the minimum number of lowercase, uppercase letters, numbers, and symbols. Returns true if the password meets the minimum requirements, otherwise returns false.

Syntax‌‌

ISSTRONGPWD(password, minLength, minLowercase, minUppercase, minNumbers, minSymbols)

NameTypeDescription
passwordmandatoryCan be any valid expression as long as it resolves to a text/string value.
minLengthmandatoryMinimum length of the password. Can be any expression as long as it resolves to an integer value.
minLowercasemandatoryMinimum number of lowercase letters. Can be any expression as long as it resolves to an integer value.
minUppercasemandatoryMinimum number of uppercase letters. Can be any expression as long as it resolves to an integer value.
minNumbersmandatoryMinimum number of numbers. Can be any expression as long as it resolves to an integer value.
minSymbolsmandatoryMinimum number of symbols. Can be any expression as long as it resolves to an integer value.

ISUPPERCASE

​​❌ Cannot be used in filter queries

Checks if the input text is uppercase or not.

Syntax‌‌

ISUPPERCASE(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.

ISURL

​​❌ Cannot be used in filter queries

Checks if the input text is a URL or not.

Syntax‌‌

ISURL(text)

NameTypeDescription
textmandatoryCan be any valid expression as long as it resolves to a text/string value.