Overview
This node, named 'Parse Data Text', generates a fixed-width TXT file from parsed JSON data based on a provided schema. It is useful for transforming structured JSON data into a formatted text output, often required for legacy systems or data exchange formats that rely on fixed-width text files. For example, it can convert parsed data from an API or database into a fixed-width text report or data file according to a predefined schema.
Use Case Examples
- Converting parsed JSON data from an API response into a fixed-width text file for legacy system import.
- Generating a fixed-width text report from parsed data for archival or data exchange purposes.
Properties
| Name | Meaning |
|---|---|
| Schema (Expression) | The JSON schema defining the fixed-width text format, including header, line, and footer definitions, used to format the parsed data into fixed-width text. |
| Parsed Data (Expression) | The parsed JSON data to be formatted into fixed-width text according to the schema. |
Output
JSON
txt- The generated fixed-width text string based on the parsed data and schema.
Dependencies
- No external dependencies beyond standard JSON parsing and date formatting.
Troubleshooting
- Schema parameter is empty or invalid JSON: Ensure the schema expression is correctly set and returns valid JSON.
- Parsed data parameter is empty or not an object: Verify the parsed data expression returns valid JSON object or array.
- Date formatting errors: The node supports specific date formats (e.g., 'YYYYMMDD', 'YYYY-MM-DD'); ensure date fields conform to these formats.
- Length and padding issues: Schema length fields must be correctly defined; decimal lengths are supported for numeric formatting.