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 <> CSV


Author: Taiki Shimasaki


(info)日本語でのヘルプはこちらをクリック

 

Description: This plugin performs a bi-directional conversion between JSON file to CSV data and CSV file to JSON data. Frequently, AI-OCR returns their execution results in the format of JSON and this plugin may come in helpful for those who are not familiar with JSON but knows what CSV looks like.



Need help?

Technical contact to tech@argos-labs.com


May you search all operations,



Input (Required)


Operation:                          Select either JSON to CSV or CSV to JSON.

File Path:                             Specify the full path for the source file (.json or .csv)

                                                The plugin fails if no file has been found as specified

Directory Path:                 Specify the folder that your result file (converted file) to be stored

                                                If no folder the plugin just fails

 

Input (Optional)


Nested Data Key:             Enter the key (char string) for nested data in the source JSON file.

                                                Please see example below as to how to find the key for nested data

 

Advanced Input


Encode Format                 Default is UFT-8

File Name                           If wish to specify a file name for the output (converted) file please specify the file name here.

                                                When no file name has been specified the source file’s file name will be used.

File Name Validation     Checks the validity of the file name

                                                Options are

                                                                Return failure

                                                                Sanitize

If File Exists                        Decides the behavior of the automation when file name is already in existence

                                                Options are

                                                                Return Failure

                                                                Add (n) at the end

                                                                Overwrite

 

Output                                                 Converted file (.json or .csv)

 

Return Value                                     Full file-path of the converted file

                                                                For all String, CSV, and File

Return Code                                      0 for success

 

(info)日本語でのヘルプはこちらをクリック

 

How to set parameters


 


 Text from Image   


Example of Key for nested data (list).

In the below JSON data, there are two “keys” for nested data (list). They are marked with [ ].

The keys are monitors and disks.

{
  "platform": {
    "platform":
"Windows-10-10.0.18362-SP0",
    "machine": "AMD64",
    "processor": "Intel64 Family
6 Model 61 Stepping 4, GenuineIntel"
  },
  "monitors":
[
    {
      "name":
"\\\\.\\DISPLAY1",   
"width": 1440,   
"height": 900,     
"width_mm": 286,     
"height_mm": 179,  
"scale": 100
    }
  ],
  "cpu": {
    "count": 4,
    "percent": "53.8%"
  },
  "memory": {
    "total": "7.9G",
    "percent": "56.1%"
  },
  "disks":
[
    {
      "device": "C:\\",
      "total": "116.37G",
      "percent": "37.6%"
    }
  ]
}


Then the resulting CSV will look like





All Plugins