Utility CSV To JSON Version 1

This handler assumes that the first row of values in the CSV input is a row containing the column names. An exception will be raised to stop a potential unsuccesful conversion if the first row has any blank values in it, if the first row has duplicate values in it, or if a particular row has more values than the first row.

Examples

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

CSV Output a,b,c,d,e animal,boat,car,, ,,cat,dog, ,,,,eel

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

Parameters

Sample Configuration

Results

Changelog

UtilityCsvToJsonV1 (2012-05-31)

• Initial version. See README for details.

---

Related Handlers

Name Generator

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

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 CSV

This handler converts a JSON string into a CSV string.

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.