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.
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
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
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
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.
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
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
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
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.
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
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
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
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).
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
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
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
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.
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
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
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
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
Check if a value is an email address and return a boolean
Parameters
emailAddress: The email - String - required
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
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
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.
Check if a value is an URL (http, https, ftp, ftps, sftp) with a host.
Parameters
url: The URL - String - required
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
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
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.
Check if a value is an IPv4 address.
Parameters
ip: The IP address - String - required
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
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_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.
Check if a value is an IPv6 address.
Parameters
ip: The IP address - String - required
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
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_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.
Check if a value is an UUID.
Parameters
uuid: The UUID - String - required
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
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
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).
Check if a value is a strict JSON (object, array or scalar).
Parameters
json: The JSON - String - required
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
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
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).
Check if a value is an IBAN (country length and mod 97 checksum, spaces allowed).
Parameters
iban: The IBAN - String - required
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
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_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).
Check if a value is a BIC / SWIFT code (8 or 11 characters).
Parameters
bic: The BIC - String - required
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
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
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.
Check the Luhn checksum (credit card number, SIREN, SIRET...), spaces allowed.
Parameters
number: The number - String - required
number: The number - String - required
admin
type is_luhn "4111 1111 1111 1111"
mentdb
1
Often used with
atom get · json doc · json iarray · json iobject · string mid · type is_bic · type is_email · type is_iban
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.
Check if a value is a French SIREN (9 digits + Luhn), spaces allowed.
Parameters
siren: The SIREN - String - required
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
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 · 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.
Check if a value is a French SIRET (14 digits + Luhn), spaces allowed.
Parameters
siret: The SIRET - String - required
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
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_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).
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
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
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_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)
Check if a value is in time format (example: 12:35:56)
Parameters
stringHour: The time - String - required
stringHour: The time - String - required
admin
type is_hour "12:35:56"
mentdb
1
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
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)
Check if a value is in time format (example: 12:35:56)
Parameters
stringHour: The time - String - required
stringHour: The time - String - required
admin
type is_time "12:35:56"
mentdb
1
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
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.
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
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
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_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).
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
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
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
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.
Return true if 'value' is a number, otherwise return 0.
Parameters
value: The value - String - required
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
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
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.
Check if a value is a byte and return a boolean.
Parameters
value: The value - String - required
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
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_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.
Check if a value is a small integer and return a boolean.
Parameters
value: The value - String - required
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
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
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.
Check if a value is a medium integer and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_medium_int 130000
mentdb
1
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
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.
Check if a value is an integer and return a boolean.
Parameters
value: The value - String - required
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
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*
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.
Check if a value is a big integer and return a boolean.
Parameters
value: The value - String - required
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
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_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.
Check if a value is a float number and return a boolean.
Parameters
value: The value - String - required
value: The value - String - required
admin
type is_float 1300000.4
mentdb
1
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
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.
Check if a value is a double number and return a boolean.
Parameters
value: The value - String - required
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
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
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.
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
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
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_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.
Check if a date is valid and return a boolean.
Parameters
dateToValidate: The date - String - required
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.
Check if a date is valid and return a boolean.
Parameters
dateToValidate: The date - String - required
format: The date format - String - required
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
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
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.
Check if a time is valid and return a boolean.
Parameters
timeToValidate: The time (12:00:01) - String - required
timeToValidate: The time (12:00:01) - String - required
admin
type is_valid_time "12:00:01"
mentdb
1
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
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.
Check if a timestamp is valid and return a boolean.
Parameters
timestampToValidate: The timestamp - String - required
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.
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
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
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_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.
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
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
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
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
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
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)
Check an EAN-8, EAN-13, UPC-A or GTIN-14 barcode (checksum)
Parameters
code: The barcode - String - required
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)
Check an ISBN-10 or ISBN-13 (hyphens allowed)
Parameters
isbn: The ISBN - String - required
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
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
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
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
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)
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
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
