This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
action:Set_JSON_Value [2019/06/24 02:07] peternlewis |
action:Set_JSON_Value [2023/09/15 04:19] (current) peternlewis |
||
---|---|---|---|
Line 5: | Line 5: | ||
{{ set-json-value.png?nolink&591x294 | Set JSON Value }} | {{ set-json-value.png?nolink&591x294 | Set JSON Value }} | ||
- | The action will take a specified JSON path, referencing a location within a variable which contains a JSON object, and set the value. | + | The action will take a specified [[:manual:JSON#JSON_Paths|JSON path]], referencing a location within a variable which contains a JSON object, and set the value. |
For example, with variable “J” containing `{ "first" : "John", "last" : "Smith" }`, the action can set the fist name field `J.first` (or `J{first}`) to a new name. | For example, with variable “J” containing `{ "first" : "John", "last" : "Smith" }`, the action can set the fist name field `J.first` (or `J{first}`) to a new name. | ||
The value will be considered a JSON object if it starts with a `[` or `{` and ends with the matching closing bracket and optional white space. Otherwise, the value will be considered a string (Non-Strict mode), or must be a valid JSON value (Strict Mode). | The value will be considered a JSON object if it starts with a `[` or `{` and ends with the matching closing bracket and optional white space. Otherwise, the value will be considered a string (Non-Strict mode), or must be a valid JSON value (Strict Mode). | ||
+ | |||
+ | If the value is `%Delete%`, then the JSON key or array entry will be deleted (v11.0+). | ||
===== Action Options (Gear ⚙ Menu) ===== | ===== Action Options (Gear ⚙ Menu) ===== | ||
Line 29: | Line 31: | ||
=== Actions === | === Actions === | ||
- | * [[action:Set_Variables_to_JSON|Set Variables to JSON]] | + | * [[action:Set_Variables_to_JSON | Set Variables to JSON]] |
- | * [[action:Set_Dictionary_to_JSON |Set Dictionary to JSON]] | + | * [[action:Set_Dictionary_to_JSON | Set Dictionary to JSON]] |
* [[:Actions|See all Actions]] | * [[:Actions|See all Actions]] | ||
+ | |||
+ | === Functions === | ||
+ | |||
+ | * [[function:JSONVALUE | JSONVALUE(jsonpath)]] | ||
+ | * [[function:COUNT | COUNT()]] | ||
+ | * [[:Functions|See all Functions]] | ||
=== Tokens === | === Tokens === | ||
- | * [[:Tokens |See all Tokens]] | + | * [[token:JSONFromDictionary | JSONFromDictionary]] |
+ | * [[token:JSONFromVariables | JSONFromVariables]] | ||
+ | * [[token:JSONValue | JSONValue]] | ||
+ | * [[:Tokens|See all Tokens]] | ||
+ | |||
+ | === Collections === | ||
+ | |||
+ | * [[collection:JSON_Keys | JSON Keys]] | ||
+ | * [[:Collections |See all Tokens]] | ||