Keyboard Maestro includes comprehensive support for JSON (JavaScript Object Notation), which is a formalized lightweight data-interchange format.
JSON objects consist of one of:
[ 1, "2", 3, "4" ]
.{ "one" : 1, "two" : "2" }
. The Key must be a properly formatted, double quoted, string."hello"
. Strings can contain various backslash-escaped characters, including "
, /
, \
, b
(backspace), f
(form feed), n
(linefeed), r
(carriage return), t
(tab), and u
followed by four hex digits to make a unicode character.true
- boolean truefalse
- boolean falsenull
- null (missing or absent value)JSON terminology refers to dictionaries as “objects”, but also the whole thing as a JSON object, so generally within Keyboard Maestro it will be referred to as a JSON dictionary when talking about a specific dictionary formatted part of a JSON object, and object when it could be any of the various forms. A JSON container would be an array or a dictionary.
Keyboard Maestro introduces the concept of a JSON Path. This is similar to the concept of an XPath, and there are other similar but unrelated JSON path concepts around, and they have similar intentions, but none of these are the same, or have the same syntax.
In Keyboard Maestro, for a variable named J
, and JSON Path might look like:
J[2+3].fieldname{%Variable%FieldName%}
This would assume that variable J holds a JSON array, and would extract the fifth element. Then it would assume that contains a dictionary and look for the field named “fieldname”. Within that, it would assume that contains a dictionary and look for a field named by the variable FieldName.
After the variable name, the format of the path is any of:
{ field name }
notation.Array indices are 1-based. Negative indices count from the end of the array. The 0 index of an array access will return the count of the number of entries in the array. When evaluating the index, the context sensitive COUNT() function will return the number of elements in the array.
Keyboard Maestro will use arrays and dictionaries more or less interchangeably, so:
will all return the third element of an array, or the dictionary value for key “3”. An important distinction is that the first one is a numeric calculation, the second one is plain text, and the third one is token text.
Many of Keyboard Maestro’s operations that produce a result from JSON have two flags associated with them: Compact or Pretty; Strict or Not-Strict.
For example, if the variable J contains the text { "a" : 3, "b" : null }
, then the result of %JSONValueCompact%J%
will be:
{"a":3,"b":null}
whereas the result of %JSONValuePretty%J%
will be:
{ "a" : 3, "b" : null }
The exact indentation should not be assumed, it might be any number of spaces or tabs.
The Strict flag relates only to JSON results that are trivial JSON strings, eg JSON "result"
.
"result"
).null
.
For example, if the variable J contains the text { "a" : 3, "b" : "hello\n\"there\"\n" }
, then the result of %JSONValueStrict%J.b%
will be:
"hello\n\"there\"\n"
whereas the result of %JSONValue%J.b%
will be:
hello "there"
The Strict/Non-Strict flag will have no effect unless the result is a trivial JSON string - if the result is a JSON object or array, or a number or true
, false,
or null
, the result will be the same either way - objects and arrays will be inherently strict, and numbers and true/false/null will be unadorned.
The default result format is Compact, Non-Strict.
There are actions to set dictionaries or variables from JSON containers, as well as an action to set a field within a JSON object to a specified value.
JSON objects must be properly legal to be processed. In particular keys to objects must be strings, which means strings must be quoted with double quotes. { a : 3 }
is not valid, it must be { "a" : 3 }
.
Decimal numbers may be processed by the system JSON APIs, which will store them as floating point, and floating point cannot store all decimal numbers with full fidelity. For example, if variable J
contains [{ "a" : 3.45 }]
, then %JSONValue%J[1]%
may result in {"a":3.4500000000000002}
. If you need precision when dealing with JSON values, avoid decimal numbers.
Although 3
and "a"
are technically legal JSON, in Non-Strict mode with cases of ambiguity, Keyboard Maestro will not consider a value or variable to contain JSON unless it is a container, ie an array or dictionary, which starts (without any leading white space) with a {
or [
, and ends with a matching bracket followed by optional white space.