Retrieve values from JSON

Retrieve values from a provided JSON. This page documents the inputs, outputs, and outcomes of the Retrieve values from JSON Wrk Action. For JSONPath syntax, JSONPath NG extensions, and worked examples, see Working with JSONPath.

Application

• JSON

Inputs (what you have)

Name	Description	Data Type	Required?	Example
JSON Text	Text in JSON format that you are looking to retrieve values from	Text (Long)	Yes	{"key":"value"}
JSON path	The JSON path to the object or value in the text you would like to retrieve.	Text (Long)	Yes	{"Field1":"$.key"}
Custom Outputs name	The name of the Custom Output in which to add the JSON value	Text (Short)	Yes	Field1
Format outputs as an array?	Format outputs as an array	True/False	No	True

Note: the value of inputs can either be a set value in the configuration of the Wrk Action within the Wrkflow, or a variable from the Data Library section. These variables in the Data Library section are the outputs of previous Wrk Actions in the Wrkflow.

Outputs (what you get)

Name	Description	Data Type	Required?	Example
Custom Outputs	A new field to add the value from the input JSON. This field name must match the value in New field name	Text (Long)	Yes	Field1

Outcomes

Name	Description
Success	This status is selected if details are extracted from the JSON.
No result	This status is selected in the event of the following scenarios:None of the provided Custom Outputs found keys in the provided JSON
Unsuccessful	This status is selected in the event of the following scenarios:The input text is not in JSON formatting and could not be converted.