JSON Parsing Parameters
The parameters in this section configure how CFS parses JSON.
For example, consider the following JSON:
{
"DREREFERENCE": "reference",
"FIELDS": [{
"NAME": "myFirstField",
"VALUE": "myFirstFieldValue"
}, {
"NAME": "mySecondField",
"FIELDS": [{
"NAME": "mySubFieldName",
"VALUE": "mySubFieldValue",
"ATTRIBUTES": [{
"NAME": "attribute",
"VALUE": "attributeValue"
}
]
}
]
}
],
"DRECONTENT": ["document content"]
}
The following configuration parses the JSON into documents. This configuration extracts fields and sub-fields recursively, because the FieldSections parameter refers to the name of the section in which it is set:
[JSONParsing] ReferencePath=DREREFERENCE ContentPaths=DRECONTENT ExpandArrays=true FieldSections=Field [Field] Path=FIELDS NamePath=NAME ValuePath=VALUE ExpandArrays=true FieldSections=Field AttributeSections=Attribute [Attribute] Path=ATTRIBUTES NamePath=NAME ValuePath=VALUE ExpandArrays=true
CFS produces the following document:
#DREREFERENCE reference #DREFIELD myFirstField="myFirstFieldValue" #DREFIELD mySecondField/mySubFieldName="mySubFieldValue" #DREFIELD mySecondField/mySubFieldName/@attribute="attributeValue" #DRECONTENT document content #DREENDDOC