Utility JSON To CSV VERSION 2


This handler makes some assumptions about the format of the JSON structure. It expects an array of objects to be the value of the root of the JSON object. In the example below the root object has a label of "table", this label is arbitrary and unused by the handler. This handler also expects the array of objects to contain only simple objects, not nested arrays or nested objects.

Examples

Below is an example of a JSON input string and the corresponding CSV output generated by this handler.

JSON Input { "table" : [ { "a" : "animal", "b" : "boat", "c" : "car" }, { "c" : "cat", "d" : "dog" }, { "e" : "eel" } ] }

CSV Output

a,b,c,d,e

animal,boat,car,,

,,cat,dog,

,,,,eel


Parameters

NameDescription
JSONThe JSON String to be converted to CSV

Sample Configuration

NameDescription
JSON{"table": [{"a": "1", "b": "2"},{"b": "2", "c": "3"}]}

Results

NameSample Result
CSVA CSV String that was converted from the given JSON

Changelog

No Changelog Available.