User Tools

Site Tools


action:Set_Variables_to_JSON

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
action:Set_Variables_to_JSON [2019/06/24 00:56]
peternlewis created
action:Set_Variables_to_JSON [2019/06/24 23:38] (current)
peternlewis
Line 1: Line 1:
 ====== Set Variables to JSON ====== ====== Set Variables to JSON ======
  
-The //Set Variables to JSON// action lets you set a set of variables from a [[manual:​JSON]] ​JSON dictionary.+The //Set Variables to JSON// ​(v9.0+) ​action lets you set a set of variables from a [[manual:​JSON]] dictionary.
  
 +{{ set-variables-to-json.png?​nolink&​591x157 | Set Variables to JSON  }}
 +
 +The action will take a specified prefix and a JSON container (dictionary or array) and will set variables based on the prefix and the field names or array indices to the corresponding values.
 +
 +For example, with prefix `JSON` and JSON dictionary `{ "​first"​ : "​John",​ "​last"​ : "​Smith"​ }`, the action will set variable `JSONfirst` to `John` and `JSONlast` to Smith.
 +
 +The prefix should either be empty, or be a valid variable name with optional trailing space.
 +
 +===== Action Options (Gear ⚙ Menu) =====
 +
 +You can control what text processing happens in the JSON field by selecting one of these options from the Gear Menu:
 +
 +* Process Text Normally (process text tokens and backslash characters)
 +* Process Text Tokens Only (process text tokens but not backslash characters)
 +* Process Nothing (process neither text tokens nor backslash characters)
 +
 +You can select Pretty JSON result mode, which affects the variable values for entries that are themselves JSON containers (See the [[manual:​JSON]] user manual section).
 +
 +You can select Strict JSON result mode, which affects the variable values for entries that are plain strings (See the [[manual:​JSON]] user manual section).
 +
 +And you can optionally have all the non-matching variables with the specified prefix removed (as long as the prefix is not empty).
 +
 +===== See Also =====
 +
 +See the [[manual:​JSON]] user manual section for more details on JSON.
 +
 +=== Actions ===
 +
 +* [[action:​Set_JSON_Value | Set JSON Value]]
 +* [[action:​Set_Dictionary_to_JSON | Set Dictionary to JSON]]
 +* [[:​Actions|See all Actions]]
 +
 +=== Functions ===
 +
 +* [[function:​JSONVALUE | JSONVALUE(jsonpath)]]
 +* [[function:​COUNT | COUNT()]]
 +* [[:​Functions|See all Functions]]
 +
 +=== Tokens ===
 +
 +* [[token:​JSONFromDictionary | JSONFromDictionary]]
 +* [[token:​JSONFromVariables | JSONFromVariables]]
 +* [[token:​JSONValue | JSONValue]]
 +* [[:​Tokens|See all Tokens]]
 +
 +=== Collections ===
 +
 +* [[collection:​JSON_Keys | JSON Keys]]
 +* [[:​Collections |See all Tokens]]
  
action/Set_Variables_to_JSON.1561352209.txt.gz · Last modified: 2019/06/24 00:56 by peternlewis