Skip to main content
Kinetic Community

Utility JSON to CSV

This handler converts a JSON string into a CSV string.

Downloads

By downloading this file, you acknowledge that you agree to our Terms of Service

Task 3: utility_json_to_csv_v1.zip

Task 4: utility_json_to_csv_v2.zip

Detailed Description

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

Name Description
JSON The JSON String to be converted to a CSV string.

Sample Configuration

Parameter Example Configuration
JSON <%=@answers['json string']%>

Results

Name Description
CSV A CSV String that was converted from the given JSON - see description

Change Log

Version Date Description
V2 2016-09-27 Updated for different CSV version in Task 4 (because of different ruby version)
V1 2011-05-24 Initial Version