Get value Version 3 (Java)

Action group: JSON

Description

The action returns the value from JSON through JSONPath.

Action icon

Settings of parameters

PropertyDescriptionTypeFilling exampleMandatory field
Parameters
JSONJSON for processingRobin.JSON
Yes
JSONPathJSONPath describes the path to the JSON element. It always starts with a „/“ character. The corresponding keys are listed below. Indexes are used to access array elements (counting starts from 0). For example, the path „/key/1“ indicates that we are trying to access the second element of the array, which is accessible by the key „key“.Robin.String
Yes
Results
ValueVariable containing value from JSON. The value is returned as a string.Robin.Object

Special conditions

None.

Example of use

Task

Get the lastName element value from a JSON-file test.json

{
	"firstname":"Joe",
	"lastname": "Jackson",
	"gender":"male",
	"age": 28,
	"address": {
		"streetAddress": "101",
		"city": "San Diego",
		"state": "CA"
	},
	"phonenumber": [
	{ "type": "home", "number": "9349282382"}
	]
}


Solution

Use the "Open", "Get value" actions. 

Implementation

  1. Assemble a robot scheme with the actions:


  2. Set the "Open" action parameters.


  3. Set the "Get value" action parameters.


  4. Click "Start" in the top panel.

Result

The program robot completed successfully. The value of the needed element was obtained.