Skip to main content
info
This documentation is for version v2.5 of the product.
For the latest version(v2.7) documentation click here
Version: v2.5 print this page

ParseJSONCol

Parses JSON content in a given Col

Type

transform

Fields

NameTitleDescription
jsonColNameJSON Col NameColumn containing the JSON Content
inputColInput ColInput Columns
jsonFieldNamesJSON Field namesJSON Field names
jsonFieldTypesJSON Field TypeData Type of the JSON field

Examples

Input

txt
StringType
{"name":"Michael"}
{"name":"Andy","age":30}
{"name":"Justin","age":19}

Parameters

NameValue
JSON Col Nametxt
Input ColJSON Field namesJSON Field Type
txtnameStringType
txtageIntegerType

Output

txttxt_parsednameage
StringTypeStructType(StructField(name,StringType,true)StringTypeIntegerType
{"name":"Michael"}[Michael,null]Michael
{"name":"Andy","age":30}[Andy,30]Andy30
{"name":"Justin","age":19}[Justin,19]Justin19