JSON Input
Description:
JSON input is a step in the Input Plugin for Process Studio Workflows. The JSON Input step plugin step can read relevant portions out of JSON structures dynamically f rom f ield values in the stream or parameters, referring to f iles or Urls. Secondly, users can also define f iles and urls as static values. The step outputs portions of the JSON structures as rows.
Configurations:
| No. | Field Name | Description |
|---|---|---|
| File Tab: | Here you enter basic connection information for accessing a resource. | |
| 1 | Step name | Specify the name of this step as it appears in the workflow workspace. |
| 2 | Source is from a previous step | Enable checkbox to retrieve the source from a previously defined field. |
| 3 | Select field | Choose the field containing the source file from a dropdown list. |
| 4 | Use field as file names | Enable checkbox if source is a filename. |
| 5 | Read source as URL | Enable checkbox if source should be accessed as a URL. |
| 6 | Do not pass field downstream | Enabling checkbox will not pass this field downstream. This improves performance and memory utilization with large JSON fields. |
| 7 | File or directory | Specify the location of the source if the source is not defined in a field. |
| 8 | Regular expression | Specify a regular expression. All filenames that match this regular expression are selected if a directory is specified. |
| 9 | Exclude regular expression | Specify a regular expression. All filenames that match this regular expression are excluded if a directory is specified. |
| 10 | Button: Show filename | Click Button to display the file names selected. |
| Content Tab: | Enables you to configure which data to collect. | |
| 1 | Ignore empty file | Enable checkbox to skip empty files---when unchecked, instances of empty files causes the process to fail and stop. |
| 2 | Do not raise an error if no files | Enable checkbox to avoid failure when there is no file to process. When unchecked the workflow to fails when there is no file to process. |
| 3 | Ignore missing path | When unchecked, causes the workflow to fail when the JSON path is missing---then checked, avoids failure when there is no JSON path. |
| 4 | Limit | Sets a limit on the number of records generated from the step when set greater than zero. |
| 5 | Include filename in output | Adds a string field with the filename in the result. |
| 6 | Rownum in output | Adds an integer field with the row number in the result. |
| 7 | Add files to result files name If checked, adds processed files to the result file list. | |
| Fields Tab: | ||
| 1 | Name | Specify the name of the output field. |
| 2 | Attribute Specify the attribute to read. | |
| 3 | Type | Specify the data type to convert to. |
| 4 | Format | Specify the format or conversion mask to use in the data type conversion. |
| 5 | Length | Specify the length of the output data type. |
| 6 | Precision | Specify the precision of the output data type. |
| 7 | Currency | Specify the currency symbol to use during data type conversion. |
| 8 | Decimal | Specify the numeric decimal symbol to use during data type conversion. |
| 9 | Group | Specify the numeric grouping symbol to use during data type conversion. |
| 10 | Trim type | Specify the type of trimming to use during data type conversion. |
| 11 | Repeat | Choose from (Y/N). Specify Y to Repeat the column value of the previous row if the column value is empty (null). |
| Additional output fields Tab: | ||
| 1 | Short filename field | Specify the field name for short filename. |
| 2 | Extension field | Specify the field name for filename extension. |
| 3 | Path field | Specify the f ield name for file path. |
| 4 | Size field | Specify the the size of the file. |
| 5 | Is hidden field | Specify fromY/N. Y to hide field. Default is N. |
| 6 | Last modification field | Specify the field name for the last modification. |
| 7 | Uri field | Specify the fieldname for Uri (e.g. file:///C:/temp/file.txt). |
| 8 | Root uri field | Specify the f ieldname for Root Uri (e.g. file:///C:/). |