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
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
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
If File Exists Decides the behavior of the automation when file name is already in existence
Add (n) at the end
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
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.
Then the resulting CSV will look like