| Info |
|---|
This function is one of Plugins Operation.You can find the movie in ARGOS RPA+ video tutorial. |
| JSON Select |
|---|---|
Please note the JSON Select plugin was designed to handle some special .json files that contain multiple-nested-layer structure with recursive columns. This type of .json files are often seen in output files from AI-OCR solutions such as Rossum and Xtracta. |
Usage Guide with Sample JSON code.
| Code Block | ||
|---|---|---|
| ||
= 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.
| Note | ||
|---|---|---|
| ||
* "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"
| Note | ||
|---|---|---|
| ||
* "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. |
Return Code
Code | Meaning |
|---|---|
| 0 | Execution successful |
| 2 | Execution failed |