JsonDecode / String Layer
Parse JSON strings into structured data objects. Similar to Python's json.loads(), JavaScript's JSON.parse(), or R's fromJSON(). Converts valid JSON strings into their corresponding data structures.
Supports all JSON data types:
- Objects ({...})
- Arrays ([...])
- Strings
- Numbers
- Booleans
- null
Common applications:
- Processing API responses
- Parsing web service data
- Reading configuration files
- Extracting nested data structures
- Working with document databases
- Analyzing event logs
- Processing IoT device data
Example transformations:
- '{"name":"John"}' → {name: "John"}
- '[1,2,3]' → [1, 2, 3]
- '{"active":true}' → {active: true}
- '{"data":null}' → {data: null}
Note: Invalid JSON strings or parsing errors result in null values. UTF-8 encoding is assumed for string content.
Table
0
0
Table
Select
columnThe string column containing JSON data. Common formats:
- API responses: '{"status":"ok","data":[...]}'
- Configuration: '{"settings":{"mode":"auto"}}'
- Event data: '{"timestamp":"2024-01-31","type":"login"}'
- Nested structures: '{"user":{"profile":{"age":30}}}'
- Arrays: '[{"id":1},{"id":2}]'
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn
matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.