Back to Utilities Integrations
Handler · Version 2

Utility JSON To CSV

Download GitHub

About

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

Configurations
Name Description Sample
enable_debug_logging Enable debug logging if the value is set to 'Yes'. No
Parameters
Name Description Sample
JSON The JSON String to be converted to CSV {"table": [{"a": "1", "b": "2"},{"b": "2", "c": "3"}]}
Results
Name Description
CSV A CSV String that was converted from the given JSON
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.
Download GitHub

On This Page

Other Versions

Looking for a workflow engine? Learn more about the Kinetic Data Enterprise Workflow Platform. Check it out
Return to Top