Flatten JSON

Description:	Iterates through all the properties of a JSON object and converts them into top level properties of the Event. Properties of nested json objects are also converted to top level properties.
Available Filters:	Event Filters: - Event Type - Event Field Field Filters: - Field Name - Field Value
Settings:	None.
Transformation Considerations:	The fields must be in valid JSON format, else an error is displayed.

Sample Transformation 1

Scenario: Separate the nested JSON fields of the JSON object, category, for all Events of the catalog.book Event Type.

Filters:

• Event Type = catalog.book
• Fields = All fields with name = category

Settings:
None.

Result: When you test the Transformation, each property of the category object is created as a property of the catalog.book Event.

Sample Transformation 2

Senario: Flatten the properties of the address JSON object and all nested objects within it, and convert these to top level Event properties.

Filters:
Event Type = Employee
Fields = All fields with name = address

Settings:
None.

Result: When you test the Transformation, each field of the address object is created as a property of the Employee Event.

---

Revision History