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

column

The 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}]'

Name 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.