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

Input	Key	Notes
Data text / Required	data	BINARY data to convert to CSV

---

BINARY to JSON

Convert BINARY to JSON | key: binaryToJson

Input	Key	Notes
Data text / Required	data	BINARY data to convert to JSON

---

BINARY to XML

Convert BINARY to XML | key: binaryToXml

Input	Key	Notes
Data text / Required	data	BINARY data to convert to XML

---

BINARY to YAML

Convert BINARY to YAML | key: binaryToYaml

Input	Key	Notes
Data text / Required	data	BINARY data to convert to YAML

---

CSV to BINARY

Convert CSV to BINARY | key: csvToBinary

Input	Key	Notes	Example
Data text / Required	data	CSV data to convert to BINARY	"person__firstname","person__lastname","dob" "Bob","Johnson","1990-01-01"

---

CSV to JSON

Convert CSV to JSON | key: csvToJson

Input	Key	Notes	Example
Data text / Required	data	CSV data to convert to JSON	"person__firstname","person__lastname","dob" "Bob","Johnson","1990-01-01"

---

CSV to XML

Convert CSV to XML | key: csvToXml

Input	Key	Notes	Example
Data text / Required	data	CSV data to convert to XML	"person__firstname","person__lastname","dob" "Bob","Johnson","1990-01-01"

---

CSV to YAML

Convert CSV to YAML | key: csvToYaml

Input	Key	Notes	Example
Data text / Required	data	CSV data to convert to YAML	"person__firstname","person__lastname","dob" "Bob","Johnson","1990-01-01"

---

Deserialize BINARY

Deserialize BINARY data | key: deserializeFromBinary

Input	Key	Notes
Data text / Required	data	BINARY text to deserialize to it can be referenced in a subsequent step.

---

Deserialize CSV

Deserialize CSV data | key: deserializeFromCsv

Input	Key	Notes	Example
Data text / Required	data	CSV 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

Input	Key	Notes	Example
Data text / Required	data	JSON 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

Input	Key	Notes	Example
Data text / Required	data	XML 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

Input	Key	Notes	Example
Data text / Required	data	YAML 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

Input	Key	Notes	Example
Data text / Required	data	JSON data to convert to BINARY	{ "person":{ "firstname":"Bob", "lastname":"Johnson" }, "dob":"1990-01-01" }

---

JSON to CSV

Convert JSON to CSV | key: jsonToCsv

Input	Key	Notes	Example
Data text / Required	data	JSON data to convert to CSV	{ "person":{ "firstname":"Bob", "lastname":"Johnson" }, "dob":"1990-01-01" }

---

JSON to XML

Convert JSON to XML | key: jsonToXml

Input	Key	Notes	Example
Data text / Required	data	JSON data to convert to XML	{ "person":{ "firstname":"Bob", "lastname":"Johnson" }, "dob":"1990-01-01" }

---

JSON to YAML

Convert JSON to YAML | key: jsonToYaml

Input	Key	Notes	Example
Data text / Required	data	JSON 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

Input	Key	Notes
Data text / Required	data	Data to pretty print

---

XML to BINARY

Convert XML to BINARY | key: xmlToBinary

Input	Key	Notes	Example
Data text / Required	data	XML 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

Input	Key	Notes	Example
Data text / Required	data	XML 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

Input	Key	Notes	Example
Data text / Required	data	XML 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

Input	Key	Notes	Example
Data text / Required	data	XML 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

Input	Key	Notes	Example
Data text / Required	data	YAML data to convert to BINARY	--- person: firstname: Bob lastname: Johnson dob: '1990-01-01'

---

YAML to CSV

Convert YAML to CSV | key: yamlToCsv

Input	Key	Notes	Example
Data text / Required	data	YAML data to convert to CSV	--- person: firstname: Bob lastname: Johnson dob: '1990-01-01'

---

YAML to JSON

Convert YAML to JSON | key: yamlToJson

Input	Key	Notes	Example
Data text / Required	data	YAML data to convert to JSON	--- person: firstname: Bob lastname: Johnson dob: '1990-01-01'

---

YAML to XML

Convert YAML to XML | key: yamlToXml

Input	Key	Notes	Example
Data text / Required	data	YAML data to convert to XML	--- person: firstname: Bob lastname: Johnson dob: '1990-01-01'

---