Change Data Format

Change data format from one format to another

Component key: change-data-format

Description#

This component allows you to convert data between JSON, XML, CSV, YAML formats, and to serialize or deserialize objects to and from each formats.

For example, the "JSON to XML" action will convert a JSON string that looks like this:

{
"user": {
"name": "John Doe",
"dob": "19880101",
"phones": ["555-123-4567", "555-555-5555"]
}
}

into an XML string that looks like this:

<user>
<name>John Doe</name>
<dob>19880101</dob>
<phones>555-123-4567</phones>
<phones>555-555-5555</phones>
</user>

A "Deserialize XML" action, when run on the above XML, would convert the XML into an object whose keys can be referenced in subsequent steps.

Actions#

BINARY to CSV#

Convert BINARY to CSV | key: binaryToCsv

InputKeyNotes

Data

text
/ Required
dataBINARY data to convert to CSV

BINARY to JSON#

Convert BINARY to JSON | key: binaryToJson

InputKeyNotes

Data

text
/ Required
dataBINARY data to convert to JSON

BINARY to XML#

Convert BINARY to XML | key: binaryToXml

InputKeyNotes

Data

text
/ Required
dataBINARY data to convert to XML

BINARY to YAML#

Convert BINARY to YAML | key: binaryToYaml

InputKeyNotes

Data

text
/ Required
dataBINARY data to convert to YAML

CSV to BINARY#

Convert CSV to BINARY | key: csvToBinary

InputKeyNotesExample

Data

text
/ Required
dataCSV data to convert to BINARY
"person__firstname","person__lastname","dob"
"Bob","Johnson","1990-01-01"

CSV to JSON#

Convert CSV to JSON | key: csvToJson

InputKeyNotesExample

Data

text
/ Required
dataCSV data to convert to JSON
"person__firstname","person__lastname","dob"
"Bob","Johnson","1990-01-01"

CSV to XML#

Convert CSV to XML | key: csvToXml

InputKeyNotesExample

Data

text
/ Required
dataCSV data to convert to XML
"person__firstname","person__lastname","dob"
"Bob","Johnson","1990-01-01"

CSV to YAML#

Convert CSV to YAML | key: csvToYaml

InputKeyNotesExample

Data

text
/ Required
dataCSV data to convert to YAML
"person__firstname","person__lastname","dob"
"Bob","Johnson","1990-01-01"

Deserialize BINARY#

Deserialize BINARY data | key: deserializeFromBinary

InputKeyNotes

Data

text
/ Required
dataBINARY text to deserialize to it can be referenced in a subsequent step.

Deserialize CSV#

Deserialize CSV data | key: deserializeFromCsv

InputKeyNotesExample

Data

text
/ Required
dataCSV text to deserialize to it can be referenced in a subsequent step.
"person__firstname","person__lastname","dob"
"Bob","Johnson","1990-01-01"

Deserialize JSON#

Deserialize JSON data | key: deserializeFromJson

InputKeyNotesExample

Data

text
/ Required
dataJSON text to deserialize to it can be referenced in a subsequent step.
{
"person":{
"firstname":"Bob",
"lastname":"Johnson"
},
"dob":"1990-01-01"
}

Deserialize XML#

Deserialize XML data | key: deserializeFromXml

InputKeyNotesExample

Data

text
/ Required
dataXML text to deserialize to it can be referenced in a subsequent step.
<dob>1990-01-01</dob>
<person>
<firstname>Bob</firstname>
<lastname>Johnson</lastname>
</person>

Deserialize YAML#

Deserialize YAML data | key: deserializeFromYaml

InputKeyNotesExample

Data

text
/ Required
dataYAML text to deserialize to it can be referenced in a subsequent step.
---
person:
firstname: Bob
lastname: Johnson
dob: '1990-01-01'

JSON to BINARY#

Convert JSON to BINARY | key: jsonToBinary

InputKeyNotesExample

Data

text
/ Required
dataJSON data to convert to BINARY
{
"person":{
"firstname":"Bob",
"lastname":"Johnson"
},
"dob":"1990-01-01"
}

JSON to CSV#

Convert JSON to CSV | key: jsonToCsv

InputKeyNotesExample

Data

text
/ Required
dataJSON data to convert to CSV
{
"person":{
"firstname":"Bob",
"lastname":"Johnson"
},
"dob":"1990-01-01"
}

JSON to XML#

Convert JSON to XML | key: jsonToXml

InputKeyNotesExample

Data

text
/ Required
dataJSON data to convert to XML
{
"person":{
"firstname":"Bob",
"lastname":"Johnson"
},
"dob":"1990-01-01"
}

JSON to YAML#

Convert JSON to YAML | key: jsonToYaml

InputKeyNotesExample

Data

text
/ Required
dataJSON data to convert to YAML
{
"person":{
"firstname":"Bob",
"lastname":"Johnson"
},
"dob":"1990-01-01"
}

Pretty Print#

Format data to be more human-readable | key: prettyPrint

InputKeyNotes

Data

text
/ Required
dataData to pretty print

XML to BINARY#

Convert XML to BINARY | key: xmlToBinary

InputKeyNotesExample

Data

text
/ Required
dataXML data to convert to BINARY
<dob>1990-01-01</dob>
<person>
<firstname>Bob</firstname>
<lastname>Johnson</lastname>
</person>

XML to CSV#

Convert XML to CSV | key: xmlToCsv

InputKeyNotesExample

Data

text
/ Required
dataXML data to convert to CSV
<dob>1990-01-01</dob>
<person>
<firstname>Bob</firstname>
<lastname>Johnson</lastname>
</person>

XML to JSON#

Convert XML to JSON | key: xmlToJson

InputKeyNotesExample

Data

text
/ Required
dataXML data to convert to JSON
<dob>1990-01-01</dob>
<person>
<firstname>Bob</firstname>
<lastname>Johnson</lastname>
</person>

XML to YAML#

Convert XML to YAML | key: xmlToYaml

InputKeyNotesExample

Data

text
/ Required
dataXML data to convert to YAML
<dob>1990-01-01</dob>
<person>
<firstname>Bob</firstname>
<lastname>Johnson</lastname>
</person>

YAML to BINARY#

Convert YAML to BINARY | key: yamlToBinary

InputKeyNotesExample

Data

text
/ Required
dataYAML data to convert to BINARY
---
person:
firstname: Bob
lastname: Johnson
dob: '1990-01-01'

YAML to CSV#

Convert YAML to CSV | key: yamlToCsv

InputKeyNotesExample

Data

text
/ Required
dataYAML data to convert to CSV
---
person:
firstname: Bob
lastname: Johnson
dob: '1990-01-01'

YAML to JSON#

Convert YAML to JSON | key: yamlToJson

InputKeyNotesExample

Data

text
/ Required
dataYAML data to convert to JSON
---
person:
firstname: Bob
lastname: Johnson
dob: '1990-01-01'

YAML to XML#

Convert YAML to XML | key: yamlToXml

InputKeyNotesExample

Data

text
/ Required
dataYAML data to convert to XML
---
person:
firstname: Bob
lastname: Johnson
dob: '1990-01-01'