This component provides a comprehensive set of utility functions to validate, read, modify, and transform JSON data. It is designed to bridge the gap between raw JSON strings and structured data formats, offering both basic manipulation and advanced transformation capabilities.
Ensure data integrity before processing with built-in diagnostic tools:
JSON_Validate: Validates whether the input text is a valid JSON structure.
JSON_IsEmpty: Checks whether a JSON object {} or array [] is empty.
JSON_GetType: Detects and returns the root JSON type.
Retrieve specific data points without manual parsing:
JSON_Value_By_Path: Retrieves a specific value from JSON based on a provided path.
JSON_Array_Length_By_Path: Returns the total number of elements in a JSON array at a specified path.
JSON_Keys_By_Path: Extracts all keys from a JSON object at a path and returns them as a CSV string.
Dynamically alter JSON structures within your logic flows:
JSON_AddOrUpdate: Adds a new value or updates an existing one at a specific JSON path.
JSON_RemoveKey: Safely removes a key or value from the JSON using a given path.
JSON_Merge: Merges two JSON objects, with an option to let values from the second JSON override the first.
Manage the visual structure and size of your payloads:
JSON_Beautify: Formats JSON with proper indentation for human readability.
JSON_Minify: Removes all unnecessary whitespace to reduce JSON size for optimized transmission.
The component specializes in converting complex JSON into tabular-friendly formats:
Transforms a JSON array of objects into TOON format by dynamically extracting columns and rows.
Includes built-in validation and error handling for reliable processing.
Transforms structured JSON data into standard CSV (Comma-Separated Values) format.
Nested Support: Handles deeply nested objects and arrays.
Array Expansion: Automatically expands nested arrays into multiple CSV rows to ensure comprehensive data representation.