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

Sample Configuration

Results

Changelog

Utility JSON to CSV V2.1 (2018-07-02)

• Updated dependencies.rb to skip loading JSON in Task 4 because it is already loaded by default

Utility JSON to CSV V2 (2016-09-27)

• Updated for new version of CSV in Task 4

Utility JSON to CSV V1 (2010-05-24)

• Initial version. See README for details.

---

Related Handlers

Name Generator

Generates a simple name like: frosty-tree-15.

Utility CSV To JSON

This handler converts a CSV string into a JSON string.

Utility CSV To XML

Converts a CSV string to an XML string

Utility Determine Next Occurrence

This handler determines the next occurence based on a provided start time and other recurrence information

Utility Json Parse

This handler parses a JSON string with a given path and returns the data found at the path

Utility JSON To HTML

This handler converts a JSON string into a HTML table.

Utility JSON to Results

Converts JSON to XML result.

Utility JSON To XML

This handler converts a JSON string into an XML string.

Utility Random Password Generate

Generates a human readable random password - intended to be immediately changed once used.