Type
Check that a value has the expected type or format: numbers, dates and times, emails, URLs, IP addresses, UUIDs, JSON, and business identifiers such as IBAN, BIC, SIRET, EAN, ISBN or EU VAT numbers. Typical uses: validate form fields, check the rows of an import before loading them.
type is_booltype is_enumtype is_chartype is_datetype is_decimaltype is_emailtype is_urltype is_ipv4type is_ipv6type is_uuidtype is_jsontype is_ibantype is_bictype is_luhntype is_sirentype is_sirettype is_phone_frtype is_hourtype is_timetype is_hour_without_sectype is_integertype is_numbertype is_bytetype is_small_inttype is_medium_inttype is_inttype is_big_inttype is_floattype is_doubletype is_timestamptype is_valid_datetype is_valid_datetype is_valid_timetype is_valid_timestamptype is_valid_timestamptype is_varchartype is_nirtype is_eantype is_isbntype is_vat_eutype is_phone_e164

type is_bool <value> <bool1> <bool2>


Description

    Check if a value is equal to 'bool1' or 'bool2' and return a boolean.

Parameters

    value:   The value - String - required
    bool1:   The first boolean - String - required
    bool2:   The second boolean - String - required
admin
type is_bool 1 1 0
mentdb
1
Used in use cases (5 recipes)

    Data validation developer › Validate a webhook payload
    Script developer › Business types on the parameters of a service
    Algorithms in MQL › Fibonacci with a memo stored in a node
    The MQL language in depth › Booleans and feature flags typed by hand
    Data validation developer › Validate an IoT device registration
Often used with

    and  ·  type is_ipv4  ·  atom get  ·  case  ·  execute  ·  script create  ·  script delete  ·  type is_enum

type is_enum <value> <values>


Description

    Check if a value is one of the values of the enum and return a boolean.

Parameters

    value:   The value - String - required
    values:   The values - String - required
admin
type is_enum 1 1,2,3
mentdb
1
Used in use cases (15 recipes)

    MQL beginner › Your first web service, called with execute
    Backend & web service developer › Bulk import endpoint with a line by line report
    Data validation developer › Validate a webhook payload
    JSON & document store developer › Validate a payload against field rules and answer 422
    Script developer › A script with typed parameters rejects bad calls
    Execution modes › JSON results computed in parallel
    and 9 more in the Use cases
Often used with

    script create  ·  execute  ·  script delete  ·  string regexp_extract  ·  try  ·  json doc  ·  type is_varchar  ·  atom get

type is_char <value> <size>


Description

    Check if the size of the string or character sent as parameter is correct.

Parameters

    value:   The value - String - required
    size:   The authorized character size - Number - required
admin
type is_char 1 1
mentdb
1
Used in use cases (2 recipes)

    Data validation developer › Validate a webhook payload
    Integrator & ETL developer › Publish a SQL table as a JSON web service
Often used with

    cm get  ·  exception  ·  script create  ·  sql connect  ·  sql disconnect  ·  sql encode  ·  sql to json  ·  string equals_ignore_case

type is_date <date>


Description

    Check if a value is a valid date in English format (example: 1980-06-18), returning a boolean (0 for false, 1 for true).

Parameters

    date:   The date - String - required
admin
type is_date "1980-06-18"
mentdb
1
Used in use cases (3 recipes)

    Data validation developer › Sign-up form: dates, hours and password
    JSON & document store developer › Validate a payload against field rules and answer 422
    Script developer › Stack and delay options of a batch script
Often used with

    string regexp_replace  ·  case  ·  continue  ·  date hour  ·  date systime  ·  json doc  ·  json fields  ·  json iarray

type is_decimal <stringDecimal> <digitBeforeTheDecimalPoint> <digitAfterTheDecimalPoint>


Description

    Check if a value is a decimal number and return a boolean.

Parameters

    stringDecimal:   The string in decimal format - String - required
    digitBeforeTheDecimalPoint:   The number of digits before the decimal point - Number - required
    digitAfterTheDecimalPoint:   The number of digits after the decimal point - Number - required
admin
type is_decimal 12.23 4 5
mentdb
1
Used in use cases (7 recipes)

    Data validation developer › Infer SQL column types from CSV samples
    Script developer › A script with typed parameters rejects bad calls
    Web service developer › POST: create an order with validation
    CRUD & data API developer › A write API with business rules in one transaction
    Files & archives manager › Store a base64 attachment, check it, read it, archive it
    Data validation developer › A shared catalogue of data quality rules
    and 1 more in the Use cases
Often used with

    atom get  ·  script create  ·  script delete  ·  string regexp_extract  ·  type is_varchar  ·  execute  ·  json doc  ·  json iobject

type is_email <emailAddress>


Description

    Check if a value is an email address and return a boolean

Parameters

    emailAddress:   The email - String - required
admin
type is_email "jim@innov-ai.com"
mentdb
1
Used in use cases (14 recipes)

    Backend & web service developer › Bulk import endpoint with a line by line report
    Data validation developer › Supplier onboarding validation report
    JSON & document store developer › Validate a payload against field rules and answer 422
    Script developer › Read a script back to build a form
    Web service developer › POST: create an order with validation
    The MQL language in depth › Loops: continue, break, retry with backoff and parallel
    and 8 more in the Use cases
Often used with

    json doc  ·  atom get  ·  json iarray  ·  not  ·  json iobject  ·  script create  ·  script delete  ·  string regexp_replace

type is_url <url>


Description

    Check if a value is an URL (http, https, ftp, ftps, sftp) with a host.

Parameters

    url:   The URL - String - required
admin
type is_url "https://www.mentdb.org/doc?id=1"
mentdb
1
Used in use cases (5 recipes)

    Data validation developer › Supplier onboarding validation report
    Script developer › Business types on the parameters of a service
    Web & API developer › Build and validate a JSON API response
    Web & API developer › Encode an HTTP request: Basic auth, query string, safe HTML
    Web & API developer › Pagination with a Link header and an ETag
Often used with

    atom get  ·  json doc  ·  json iarray  ·  json iobject  ·  string url_encode  ·  type is_bic  ·  type is_iban  ·  type is_phone_fr

type is_ipv4 <ip>


Description

    Check if a value is an IPv4 address.

Parameters

    ip:   The IP address - String - required
admin
type is_ipv4 "192.168.1.254"
mentdb
1
Used in use cases (4 recipes)

    Data validation developer › Validate a webhook payload
    Script developer › Business types on the parameters of a service
    Web & API developer › Parse an access log line into a JSON event
    Data validation developer › Validate an IoT device registration
Often used with

    type is_bool  ·  string regexp_extract  ·  type is_ipv6  ·  type is_json  ·  type is_varchar  ·  and  ·  atom get  ·  env set var

type is_ipv6 <ip>


Description

    Check if a value is an IPv6 address.

Parameters

    ip:   The IP address - String - required
admin
type is_ipv6 "2001:db8::1"
mentdb
1
Used in use cases (2 recipes)

    Data validation developer › Validate a webhook payload
    Data validation developer › Validate an IoT device registration
Often used with

    type is_bool  ·  type is_ipv4  ·  type is_varchar  ·  and  ·  string equals_ignore_case  ·  string hmac_sha256  ·  type is_big_int  ·  type is_byte

type is_uuid <uuid>


Description

    Check if a value is an UUID.

Parameters

    uuid:   The UUID - String - required
admin
type is_uuid "3f2b8c1e-6a0d-4e5b-9c7a-1d2e3f4a5b6c"
mentdb
1
Used in use cases (3 recipes)

    Data validation developer › Validate a webhook payload
    Web service developer › API key and limits in server parameters
    Web & API developer › Build and validate a JSON API response
Often used with

    string uuid  ·  exception  ·  execute  ·  json doc  ·  json iarray  ·  json iobject  ·  not  ·  parameter add

type is_json <json>


Description

    Check if a value is a strict JSON (object, array or scalar).

Parameters

    json:   The JSON - String - required
admin
type is_json "{\"a\":[1,2,true]}"
mentdb
1
Used in use cases (4 recipes)

    Backend & web service developer › Signed webhook receiver with replay protection
    Data validation developer › Validate a webhook payload
    Script developer › Business types on the parameters of a service
    Event developer › Route the dropped files by type and content
Often used with

    script create  ·  script delete  ·  atom get  ·  execute  ·  log write  ·  not  ·  string hmac_sha256  ·  string regexp_extract

type is_iban <iban>


Description

    Check if a value is an IBAN (country length and mod 97 checksum, spaces allowed).

Parameters

    iban:   The IBAN - String - required
admin
type is_iban "FR76 3000 6000 0112 3456 7890 189"
mentdb
1
Used in use cases (6 recipes)

    Data validation developer › Supplier onboarding validation report
    Script developer › Business types on the parameters of a service
    Data quality analyst › Format checks of supplier records
    Security engineer › Field-level encryption of an IBAN with key escrow
    Data validation developer › Test the checks of a form with generated SIRET, VAT numbers, IBAN, emails and phones
    Data quality analyst › Data quality flags as a bitmask, today versus yesterday
Often used with

    type is_email  ·  type is_siret  ·  type is_phone_fr  ·  type is_valid_date  ·  atom get  ·  not  ·  string regexp_replace  ·  type is_bic

type is_bic <bic>


Description

    Check if a value is a BIC / SWIFT code (8 or 11 characters).

Parameters

    bic:   The BIC - String - required
admin
type is_bic "BNPAFRPPXXX"
mentdb
1
Used in use cases (2 recipes)

    Data validation developer › Supplier onboarding validation report
    Script developer › Business types on the parameters of a service
Often used with

    atom get  ·  type is_iban  ·  type is_phone_fr  ·  type is_siret  ·  type is_url  ·  env set var  ·  execute  ·  json doc

type is_luhn <number>


Description

    Check the Luhn checksum (credit card number, SIREN, SIRET...), spaces allowed.

Parameters

    number:   The number - String - required
admin
type is_luhn "4111 1111 1111 1111"
mentdb
1
Used in use cases (1 recipe)

    Data validation developer › Supplier onboarding validation report
Often used with

    atom get  ·  json doc  ·  json iarray  ·  json iobject  ·  string mid  ·  type is_bic  ·  type is_email  ·  type is_iban

type is_siren <siren>


Description

    Check if a value is a French SIREN (9 digits + Luhn), spaces allowed.

Parameters

    siren:   The SIREN - String - required
admin
type is_siren "732 829 320"
mentdb
1
Used in use cases (2 recipes)

    Data validation developer › Supplier onboarding validation report
    Data validation developer › French company VAT number and social security key
Often used with

    type is_siret  ·  atom get  ·  bi-  ·  json doc  ·  json iarray  ·  json iobject  ·  math mod  ·  string left

type is_siret <siret>


Description

    Check if a value is a French SIRET (14 digits + Luhn), spaces allowed.

Parameters

    siret:   The SIRET - String - required
admin
type is_siret "732 829 320 00074"
mentdb
1
Used in use cases (6 recipes)

    Data validation developer › Supplier onboarding validation report
    Script developer › Business types on the parameters of a service
    Data quality analyst › Format checks of supplier records
    Data validation developer › French company VAT number and social security key
    Data validation developer › Test the checks of a form with generated SIRET, VAT numbers, IBAN, emails and phones
    Data quality analyst › Completeness, validity and uniqueness scorecard of suppliers
Often used with

    type is_iban  ·  type is_phone_fr  ·  type is_email  ·  atom get  ·  is null or empty  ·  not  ·  string regexp_replace  ·  type is_bic

type is_phone_fr <phone>


Description

    Check if a value is a French phone number (0X, +33, 0033, DROM +262 +590 +594 +596; spaces, dots, dashes allowed).

Parameters

    phone:   The phone number - String - required
admin
type is_phone_fr "+262 692 12 34 56"
mentdb
1
Used in use cases (4 recipes)

    Data validation developer › Supplier onboarding validation report
    Script developer › Business types on the parameters of a service
    Data quality analyst › Completeness, validity and uniqueness scorecard of suppliers
    Data validation developer › Test the checks of a form with generated SIRET, VAT numbers, IBAN, emails and phones
Often used with

    type is_siret  ·  type is_iban  ·  atom get  ·  type is_bic  ·  type is_email  ·  type is_url  ·  and  ·  env set var

type is_hour <stringHour>


Description

    Check if a value is in time format (example: 12:35:56)

Parameters

    stringHour:   The time - String - required
admin
type is_hour "12:35:56"
mentdb
1
Used in use cases (1 recipe)

    Data validation developer › Sign-up form: dates, hours and password
Often used with

    string bcrypt_hash  ·  string bcrypt_verify  ·  string left  ·  type is_date  ·  type is_hour_without_sec  ·  type is_time  ·  type is_timestamp  ·  type is_valid_date

type is_time <stringHour>


Description

    Check if a value is in time format (example: 12:35:56)

Parameters

    stringHour:   The time - String - required
admin
type is_time "12:35:56"
mentdb
1
Used in use cases (1 recipe)

    Data validation developer › Sign-up form: dates, hours and password
Often used with

    string bcrypt_hash  ·  string bcrypt_verify  ·  string left  ·  type is_date  ·  type is_hour  ·  type is_hour_without_sec  ·  type is_timestamp  ·  type is_valid_date

type is_hour_without_sec <stringHour>


Description

    Check if a value is in time format (example: 12:35). If the value is not in time format, or if it contains seconds, this function returns false.

Parameters

    stringHour:   The time - String - required
admin
type is_hour_without_sec "12:35:56"
mentdb
0
Used in use cases (2 recipes)

    Data validation developer › Sign-up form: dates, hours and password
    Script developer › Business types on the parameters of a service
Often used with

    type is_valid_date  ·  atom get  ·  env set var  ·  execute  ·  script create  ·  script delete  ·  string bcrypt_hash  ·  string bcrypt_verify

type is_integer <value> <size>


Description

    Return true if 'value' is an integer with at most 'size' digits (a leading minus sign is allowed).

Parameters

    value:   The value - String - required
    size:   The maximum number of digits - Number - required
admin
type is_integer 1456 5
mentdb
1
Used in use cases (23 recipes)

    MQL beginner › Your first script with typed parameters
    Backend & web service developer › Health check endpoint for the load balancer
    Data validation developer › Infer SQL column types from CSV samples
    JSON & document store developer › Validate a payload against field rules and answer 422
    Script developer › A script with typed parameters rejects bad calls
    Execution modes › Errors propagate through nested executes
    and 17 more in the Use cases
Often used with

    script create  ·  script delete  ·  execute  ·  string regexp_extract  ·  try  ·  atom get  ·  exception  ·  json doc

type is_number <value>


Description

    Return true if 'value' is a number, otherwise return 0.

Parameters

    value:   The value - String - required
admin
type is_number 1456
mentdb
1
Used in use cases (14 recipes)

    MQL beginner › Check typed quantities: try inside a loop
    Backend & web service developer › Publish a typed web service with its parameter and stack options
    Data validation developer › Infer SQL column types from CSV samples
    Async developer › Push a script to the stack and watch it close
    The MQL language in depth › MQL syntax, nesting and numeric traps
    Excel reporting analyst › Migrate a legacy XLS price list to XLSX, formulas included
    and 8 more in the Use cases
Often used with

    script create  ·  script delete  ·  and  ·  date now  ·  execute  ·  stack  ·  string regexp_extract  ·  wait

type is_byte <value>


Description

    Check if a value is a byte and return a boolean.

Parameters

    value:   The value - String - required
admin
type is_byte 13
mentdb
1
Used in use cases (2 recipes)

    Data validation developer › Infer SQL column types from CSV samples
    Data validation developer › Validate an IoT device registration
Often used with

    type is_big_int  ·  and  ·  json doc  ·  json iobject  ·  json parse_obj  ·  type is_bool  ·  type is_decimal  ·  type is_double

type is_small_int <value>


Description

    Check if a value is a small integer and return a boolean.

Parameters

    value:   The value - String - required
admin
type is_small_int 13000
mentdb
1
Used in use cases (2 recipes)

    Data validation developer › Infer SQL column types from CSV samples
    Script developer › Business types on the parameters of a service
Often used with

    atom get  ·  env set var  ·  execute  ·  json doc  ·  json iobject  ·  json parse_obj  ·  script create  ·  script delete

type is_medium_int <value>


Description

    Check if a value is a medium integer and return a boolean.

Parameters

    value:   The value - String - required
admin
type is_medium_int 130000
mentdb
1
Used in use cases (1 recipe)

    Data validation developer › Infer SQL column types from CSV samples
Often used with

    json doc  ·  json iobject  ·  json parse_obj  ·  type is_big_int  ·  type is_byte  ·  type is_decimal  ·  type is_double  ·  type is_float

type is_int <value>


Description

    Check if a value is an integer and return a boolean.

Parameters

    value:   The value - String - required
admin
type is_int 1300000
mentdb
1
Used in use cases (4 recipes)

    Data validation developer › Infer SQL column types from CSV samples
    CRUD & data API developer › A write API with business rules in one transaction
    Algorithms in MQL › Recursion: a script that calls itself
    Algorithms in MQL › Fibonacci with a memo stored in a node
Often used with

    execute  ·  script create  ·  script delete  ·  date current_ms  ·  type is_decimal  ·  and  ·  arith factorial  ·  bi*

type is_big_int <value>


Description

    Check if a value is a big integer and return a boolean.

Parameters

    value:   The value - String - required
admin
type is_big_int 1300000
mentdb
1
Used in use cases (2 recipes)

    Data validation developer › Infer SQL column types from CSV samples
    Data validation developer › Validate an IoT device registration
Often used with

    type is_byte  ·  and  ·  json doc  ·  json iobject  ·  json parse_obj  ·  type is_bool  ·  type is_decimal  ·  type is_double

type is_float <value>


Description

    Check if a value is a float number and return a boolean.

Parameters

    value:   The value - String - required
admin
type is_float 1300000.4
mentdb
1
Used in use cases (1 recipe)

    Data validation developer › Infer SQL column types from CSV samples
Often used with

    json doc  ·  json iobject  ·  json parse_obj  ·  type is_big_int  ·  type is_byte  ·  type is_decimal  ·  type is_double  ·  type is_int

type is_double <value>


Description

    Check if a value is a double number and return a boolean.

Parameters

    value:   The value - String - required
admin
type is_double 1300000.4
mentdb
1
Used in use cases (27 recipes)

    Backend & web service developer › Publish a typed web service with its parameter and stack options
    Data validation developer › Infer SQL column types from CSV samples
    Script developer › Patch a script with its generated update request
    Execution modes › execute runs in a new environment
    Web service developer › Publish the four methods and document their URLs
    Async developer › Push a script to the stack and watch it close
    and 21 more in the Use cases
Often used with

    script create  ·  script delete  ·  execute  ·  bd*  ·  file delete  ·  group add  ·  group grant script  ·  group remove

type is_timestamp <value>


Description

    Check if a value is in timestamp format (example: '2009-06-18 12:00:00') and return a boolean.

Parameters

    value:   The value - String - required
admin
type is_timestamp "2009-06-18 12:00:00"
mentdb
1
Used in use cases (2 recipes)

    Data validation developer › Sign-up form: dates, hours and password
    Data validation developer › Validate an IoT device registration
Often used with

    type is_valid_timestamp  ·  and  ·  string bcrypt_hash  ·  string bcrypt_verify  ·  string left  ·  type is_big_int  ·  type is_bool  ·  type is_byte

type is_valid_date <dateToValidate>


Description

    Check if a date is valid and return a boolean.

Parameters

    dateToValidate:   The date - String - required
admin
type is_valid_date "1980-06-18"
mentdb
1

type is_valid_date <dateToValidate> <format>


Description

    Check if a date is valid and return a boolean.

Parameters

    dateToValidate:   The date - String - required
    format:   The date format - String - required
admin
type is_valid_date "1980-06-18" "yyyy-MM-dd"
mentdb
1
Used in use cases (5 recipes)

    Backend & web service developer › Bulk import endpoint with a line by line report
    Data validation developer › Sign-up form: dates, hours and password
    Script developer › Business types on the parameters of a service
    Data quality analyst › Format checks of supplier records
    Data quality analyst › Data quality flags as a bitmask, today versus yesterday
Often used with

    not  ·  type is_email  ·  type is_iban  ·  atom get  ·  execute  ·  script create  ·  script delete  ·  type is_hour_without_sec

type is_valid_time <timeToValidate>


Description

    Check if a time is valid and return a boolean.

Parameters

    timeToValidate:   The time (12:00:01) - String - required
admin
type is_valid_time "12:00:01"
mentdb
1
Used in use cases (1 recipe)

    Data validation developer › Sign-up form: dates, hours and password
Often used with

    string bcrypt_hash  ·  string bcrypt_verify  ·  string left  ·  type is_date  ·  type is_hour  ·  type is_hour_without_sec  ·  type is_time  ·  type is_timestamp

type is_valid_timestamp <timestampToValidate>


Description

    Check if a timestamp is valid and return a boolean.

Parameters

    timestampToValidate:   The timestamp - String - required
admin
type is_valid_timestamp "1980-06-18 12:00:01"
mentdb
1

type is_valid_timestamp <timestampToValidate> <format>


Description

    Check if a timestamp is valid and return a boolean.

Parameters

    timestampToValidate:   The timestamp - String - required
    format:   The format (ex: yyyy MM dd HH:mm:ss) - String - required
admin
type is_valid_timestamp "1980-06-18 12:00:01" "yyyy-MM-dd HH:mm:ss"
mentdb
1
Used in use cases (2 recipes)

    Data validation developer › Sign-up form: dates, hours and password
    Data validation developer › Validate an IoT device registration
Often used with

    type is_timestamp  ·  and  ·  string bcrypt_hash  ·  string bcrypt_verify  ·  string left  ·  type is_big_int  ·  type is_bool  ·  type is_byte

type is_varchar <value> <size>


Description

    Check if the size of the string or character sent as parameter is correct.

Parameters

    value:   The value - String - required
    size:   The authorized character size - Number - required
admin
type is_varchar 1 1
mentdb
1
Used in use cases (22 recipes)

    MQL beginner › Your first script with typed parameters
    Backend & web service developer › Bulk import endpoint with a line by line report
    Data validation developer › Validate a webhook payload
    Script developer › A script with typed parameters rejects bad calls
    Execution modes › sub_include: build include requests with current values
    Web service developer › POST: create an order with validation
    and 16 more in the Use cases
Often used with

    script create  ·  script delete  ·  execute  ·  string regexp_extract  ·  try  ·  atom get  ·  type is_enum  ·  exception

type is_nir <nir>


Description

    Check a French social security number (NIR): 13 characters and the key 97 - (number mod 97); Corsica 2A and 2B

Parameters

    nir:   The number (spaces allowed) - String - required
admin
type is_nir "2 55 08 14 168 025 38"
mentdb
1
Wrong key
admin
type is_nir "2 55 08 14 168 025 39"
mentdb
0

type is_ean <code>


Description

    Check an EAN-8, EAN-13, UPC-A or GTIN-14 barcode (checksum)

Parameters

    code:   The barcode - String - required
admin
type is_ean "4006381333931"
mentdb
1

type is_isbn <isbn>


Description

    Check an ISBN-10 or ISBN-13 (hyphens allowed)

Parameters

    isbn:   The ISBN - String - required
admin
type is_isbn "978-2-07-036822-8"
mentdb
1
admin
type is_isbn "2-07-036822-X"
mentdb
1

type is_vat_eu <vat>


Description

    Check an EU intra-community VAT number: format of each country, checksum for FR, BE, DE and IT

Parameters

    vat:   The VAT number with the country code - String - required
admin
type is_vat_eu "FR 40 303 265 045"
mentdb
1
admin
type is_vat_eu "DE136695976"
mentdb
1
Used in use cases (1 recipe)

    Data validation developer › Test the checks of a form with generated SIRET, VAT numbers, IBAN, emails and phones
Often used with

    fake rows  ·  string substr  ·  type is_email  ·  type is_iban  ·  type is_phone_fr  ·  type is_siret

type is_phone_e164 <phone>


Description

    Check an international phone number in E.164 format: + then 8 to 15 digits (spaces, dots, hyphens and parentheses allowed)

Parameters

    phone:   The phone number - String - required
admin
type is_phone_e164 "+262 692 12 34 56"
mentdb
1
Missing country code
admin
type is_phone_e164 "0692123456"
mentdb
0