Change Data Format Component

Change data from one format to another

Component key: change-data-format

Description

The change data format component allows you to convert data between common formats, like JSON, XML, CSV, and YAML, and to serialize (turn an object into a string) or deserialize (turn a string into an object) each supported format.

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

CSV to JSON

Convert CSV to JSON | key: csvToJson

Input	Notes	Example
Input Data code / Required	Notes CSV data to convert to JSON	Example "person__first","person__last","dob""Bob","Johnson","1990-01-01"

Output Example Payload

{  "data": "{\n  \"person\": {\n    \"first\": \"Bob\",\n    \"last\": \"Johnson\"\n  },\n  \"dob\": \"1990-01-01\"\n}",  "contentType": "application/json"}

---

CSV to XML

Convert CSV to XML | key: csvToXml

Input	Notes	Example
Input Data code / Required	Notes CSV data to convert to XML	Example "person__first","person__last","dob""Bob","Johnson","1990-01-01"

Output Example Payload

{  "data": "<dob>1990-01-01</dob>\n<person>\n  <first>Bob</first>\n  <last>Johnson</last>\n</person>",  "contentType": "text/xml"}

---

CSV to YAML

Convert CSV to YAML | key: csvToYaml

Input	Notes	Example
Input Data code / Required	Notes CSV data to convert to YAML	Example "person__first","person__last","dob""Bob","Johnson","1990-01-01"

Output Example Payload

{  "data": "---\nperson:\n  first: Bob\n  last: Johnson\ndob: '1990-01-01'",  "contentType": "text/yaml"}

---

Deserialize BINARY

Deserialize BINARY data | key: deserializeFromBinary

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

Output Example Payload

{  "data": {    "person": {      "first": "Bob",      "last": "Johnson"    },    "dob": "1990-01-01"  }}

---

Deserialize CSV

Deserialize CSV data | key: deserializeFromCsv

Input	Notes	Example
Input Data code / Required	Notes CSV text to deserialize to it can be referenced in a subsequent step.	Example "person__first","person__last","dob""Bob","Johnson","1990-01-01"
Input CSV Header boolean	Notes Specify if your CSV contains a header row.	Example

Output Example Payload

{  "data": {    "person": {      "first": "Bob",      "last": "Johnson"    },    "dob": "1990-01-01"  }}

---

Deserialize JSON

Deserialize JSON data | key: deserializeFromJson

Input	Notes	Example
Input Data code / Required	Notes JSON text to deserialize to it can be referenced in a subsequent step.	Example { "person": { "first": "Bob", "last": "Johnson" }, "dob": "1990-01-01"}

Output Example Payload

{  "data": {    "person": {      "first": "Bob",      "last": "Johnson"    },    "dob": "1990-01-01"  }}

---

Deserialize JSON Lines (.jsonl)

Transform .jsonl data to a JavaScript array | key: deserializeJsonl

Input	Notes	Example
Input JSONL Data code / Required	Notes	Example ["Name", "Session", "Score", "Completed"]["Gilbert", "2013", 24, true]["Alexa", "2013", 29, true]["May", "2012B", 14, false]["Deloise", "2012A", 19, true]

---

Deserialize XML

Deserialize XML data | key: deserializeFromXml

Input	Notes	Example
Input Data code / Required	Notes XML text to deserialize to it can be referenced in a subsequent step.	Example <dob>1990-01-01</dob><person> <first>Bob</first> <last>Johnson</last></person>

Output Example Payload

{  "data": {    "person": {      "first": "Bob",      "last": "Johnson"    },    "dob": "1990-01-01"  }}

---

Deserialize YAML

Deserialize YAML data | key: deserializeFromYaml

Input	Notes	Example
Input Data code / Required	Notes YAML text to deserialize to it can be referenced in a subsequent step.	Example ---person: first: Bob last: Johnsondob: '1990-01-01'

Output Example Payload

{  "data": {    "person": {      "first": "Bob",      "last": "Johnson"    },    "dob": "1990-01-01"  }}

---

JavaScript Object to CSV

Convert JavaScript Object to CSV | key: binaryToCsv

Input	Notes
Input Data code / Required	Notes JavaScript Object data to convert to CSV

Output Example Payload

{  "data": "\"person__first\",\"person__last\",\"dob\"\n\"Bob\",\"Johnson\",\"1990-01-01\"",  "contentType": "text/csv"}

---

JavaScript Object to JSON

Convert JavaScript Object to JSON | key: binaryToJson

Input	Notes
Input Data code / Required	Notes JavaScript Object data to convert to JSON

Output Example Payload

{  "data": "{\n  \"person\": {\n    \"first\": \"Bob\",\n    \"last\": \"Johnson\"\n  },\n  \"dob\": \"1990-01-01\"\n}",  "contentType": "application/json"}

---

JavaScript Object to XML

Convert JavaScript Object to XML | key: binaryToXml

Input	Notes
Input Data code / Required	Notes JavaScript Object data to convert to XML

Output Example Payload

{  "data": "<dob>1990-01-01</dob>\n<person>\n  <first>Bob</first>\n  <last>Johnson</last>\n</person>",  "contentType": "text/xml"}

---

JavaScript Object to YAML

Convert JavaScript Object to YAML | key: binaryToYaml

Input	Notes
Input Data code / Required	Notes JavaScript Object data to convert to YAML

Output Example Payload

{  "data": "---\nperson:\n  first: Bob\n  last: Johnson\ndob: '1990-01-01'",  "contentType": "text/yaml"}

---

JSON to CSV

Convert JSON to CSV | key: jsonToCsv

Input	Notes	Example
Input Data code / Required	Notes JSON data to convert to CSV	Example { "person": { "first": "Bob", "last": "Johnson" }, "dob": "1990-01-01"}

Output Example Payload

{  "data": "\"person__first\",\"person__last\",\"dob\"\n\"Bob\",\"Johnson\",\"1990-01-01\"",  "contentType": "text/csv"}

---

JSON to XML

Convert JSON to XML | key: jsonToXml

Input	Notes	Example
Input Data code / Required	Notes JSON data to convert to XML	Example { "person": { "first": "Bob", "last": "Johnson" }, "dob": "1990-01-01"}

Output Example Payload

{  "data": "<dob>1990-01-01</dob>\n<person>\n  <first>Bob</first>\n  <last>Johnson</last>\n</person>",  "contentType": "text/xml"}

---

JSON to YAML

Convert JSON to YAML | key: jsonToYaml

Input	Notes	Example
Input Data code / Required	Notes JSON data to convert to YAML	Example { "person": { "first": "Bob", "last": "Johnson" }, "dob": "1990-01-01"}

Output Example Payload

{  "data": "---\nperson:\n  first: Bob\n  last: Johnson\ndob: '1990-01-01'",  "contentType": "text/yaml"}

---

Pretty Print

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

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

---

Serialize JSON Lines (.jsonl)

Serialize an array of JavaScript objects into .jsonl | key: serializeJsonl

Input	Notes
Input Array of JavaScript Objects to serialize string / Required	Notes Must be a reference to an array of JavaScript objects

---

XML to CSV

Convert XML to CSV | key: xmlToCsv

Input	Notes	Example
Input Data code / Required	Notes XML data to convert to CSV	Example <dob>1990-01-01</dob><person> <first>Bob</first> <last>Johnson</last></person>

Output Example Payload

{  "data": "\"person__first\",\"person__last\",\"dob\"\n\"Bob\",\"Johnson\",\"1990-01-01\"",  "contentType": "text/csv"}

---

XML to JSON

Convert XML to JSON | key: xmlToJson

Input	Notes	Example
Input Data code / Required	Notes XML data to convert to JSON	Example <dob>1990-01-01</dob><person> <first>Bob</first> <last>Johnson</last></person>

Output Example Payload

{  "data": "{\n  \"person\": {\n    \"first\": \"Bob\",\n    \"last\": \"Johnson\"\n  },\n  \"dob\": \"1990-01-01\"\n}",  "contentType": "application/json"}

---

XML to YAML

Convert XML to YAML | key: xmlToYaml

Input	Notes	Example
Input Data code / Required	Notes XML data to convert to YAML	Example <dob>1990-01-01</dob><person> <first>Bob</first> <last>Johnson</last></person>

Output Example Payload

{  "data": "---\nperson:\n  first: Bob\n  last: Johnson\ndob: '1990-01-01'",  "contentType": "text/yaml"}

---

YAML to CSV

Convert YAML to CSV | key: yamlToCsv

Input	Notes	Example
Input Data code / Required	Notes YAML data to convert to CSV	Example ---person: first: Bob last: Johnsondob: '1990-01-01'

Output Example Payload

{  "data": "\"person__first\",\"person__last\",\"dob\"\n\"Bob\",\"Johnson\",\"1990-01-01\"",  "contentType": "text/csv"}

---

YAML to JSON

Convert YAML to JSON | key: yamlToJson

Input	Notes	Example
Input Data code / Required	Notes YAML data to convert to JSON	Example ---person: first: Bob last: Johnsondob: '1990-01-01'

Output Example Payload

{  "data": "{\n  \"person\": {\n    \"first\": \"Bob\",\n    \"last\": \"Johnson\"\n  },\n  \"dob\": \"1990-01-01\"\n}",  "contentType": "application/json"}

---

YAML to XML

Convert YAML to XML | key: yamlToXml

Input	Notes	Example
Input Data code / Required	Notes YAML data to convert to XML	Example ---person: first: Bob last: Johnsondob: '1990-01-01'

Output Example Payload

{  "data": "<dob>1990-01-01</dob>\n<person>\n  <first>Bob</first>\n  <last>Johnson</last>\n</person>",  "contentType": "text/xml"}

---