IS_VALID_JSON_SCHEMA

Returns true if the object provided matches the provided json schema, using the https://json-schema.org/ syntax.

Syntax 

IS_VALID_JSON_SCHEMA(object, any)

Usage examples 

Example 1

Input

1
{
2
"schema": {
3
"type": "object",
4
"properties": {
5
"abc": {
6
"type": "integer",
7
"minimum": 11
8
}
9
}
10
},
11
"my_action": {
12
"value1": {
13
"abc": 11
14
}
15
}
16
}

Formula

IS_VALID_JSON_SCHEMA(schema, my_action.value1)

Output

1
{
2
"value1": true
3
}
Was this helpful?