Skip to end of metadata
Go to start of metadata

This function is one of Plugins Operation.You can find the movie in ARGOS RPA+ video tutorial.



JSON Select

When used in combination with REST API plugin, JSON Select plugin can manipulate the JSON file that are usually returned as response to REST API requests. JSON Select modifies the JSON file and extract certain values in certain format.

Need help?

Technical contact to tech@argos-labs.com


May you search all operations,





Usage Guide with Sample JSON code.
= Example JSON
            {
                "page": 1,
                "per_page": 3,
                "total": 12,
                "total_pages": 4,
                "pagedata": {
                    "data": [
                        {
                            "id": 1,
                            "name": "cerulean",
                            "year": 2000,
                            "color": "#98B2D1",
                            "pantone_value": "We"
                        },
                        {
                            "id": 2,
                            "name": "fuchsia rose",
                            "year": 2001,
                            "color": "#C74375",
                            "pantone_value": "Freedom"
                        },
                        {
                            "id": 3,
                            "name": "true red",
                            "year": 2002,
                            "color": "#BF1932",
                            "pantone_value": "Soul"
                        }
                    ]
                },
                'jpn': {
                    "data": {
                        "shippingDay": "2019-04-02",
                        "mansionName": "新宿ビル"
                    },
                    "status": 200
                }






1) Execute with xpath "total"

 > result is "12"


2)Execute with xpath "pagedata/data[2]/id"

 > result is "3"


3) Execute with xpath "pagedata/data"

 > result are

  • "id","name","year","color","pantone_value"
  • 1,"cerulean",2000,"#98B2D1","We"
  • 2,"fuchsia rose",2001,"#C74375","Freedom"
  • 3,"true red",2002,"#BF1932","Soul"


4) Execute with xpath "pagedata/invalid" with "Raise Except Flag"

 > return Error


5) Execute with xpath "pagedata/invalid" without "Raise Except Flag"

 > return Error

==> no need this option.

* "Opt Output Format" is only "csv"


6) Execute with xpath "pagedata/data" with "Get length"

> result are "3"


7) Execute with xpath "pagedata/data" with "AND Filter", "id=2" (this "AND Filter" can be mupliple)

 > result are

  • "id","name","year","color","pantone_value"
  • 2,"fuchsia rose",2001,"#C74375","Freedom"


8) Execute with xpath "pagedata/data" with "OR Filter", "id=2", "OR Filter", "id=3"

  (this "AND Filter" can be mupliple)

 > result are

  • "id","name","year","color","pantone_value"
  • 2,"fuchsia rose",2001,"#C74375","Freedom"
  • 3,"true red",2002,"#BF1932","Soul"


* "Find all Opt" option is gathers all data matching key value.

* "Cell key" option is defined then this column value is valid (exists and not empty).

* "Exclude index" option is 1 and "Exclude value" is "Item" then in csv result first column value is "Item" rows are excluded.