Skip to main content
change-data-format icon

Change Data Format Connector

Connector Changelog

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.

Deserialize XML action

Actions​

Convert To Boolean​

Convert a value to a boolean | key: convertToBoolean

InputNotesExample
The value to be converted to a boolean

Convert To Integer​

Convert a value to an int | key: convertToInt

InputNotesExample
The value to be converted to a integer

Convert To Number​

Convert a value to a number | key: convertToNumber

InputNotesExample
The value to be converted to a number

Convert To String​

Convert a value to a string | key: convertToString

InputNotesExample
The value to be converted to a string

CSV to JSON​

Convert CSV to JSON | key: csvToJson

InputNotesExample
Data

CSV data to convert to JSON

"person__first","person__last","dob"
"Bob","Johnson","1990-01-01"
CSV Header

Specify if your CSV contains a header row.

true
Un-Flatten CSV Keys

When enabled, keys with double-underscores will be parsed as nested objects. For example, 'person__first,person__last' will become '{ person: { first, last } }' rather than '{ person__first, person__last }'

false
Example Payload for CSV to JSON⤓
Loading…

CSV to XML​

Convert CSV to XML | key: csvToXml

InputNotesExample
Data

CSV data to convert to XML

"person__first","person__last","dob"
"Bob","Johnson","1990-01-01"
CSV Header

Specify if your CSV contains a header row.

true
Un-Flatten CSV Keys

When enabled, keys with double-underscores will be parsed as nested objects. For example, 'person__first,person__last' will become '{ person: { first, last } }' rather than '{ person__first, person__last }'

false
Example Payload for CSV to XML⤓
Loading…

CSV to YAML​

Convert CSV to YAML | key: csvToYaml

InputNotesExample
Data

CSV data to convert to YAML

"person__first","person__last","dob"
"Bob","Johnson","1990-01-01"
CSV Header

Specify if your CSV contains a header row.

true
Un-Flatten CSV Keys

When enabled, keys with double-underscores will be parsed as nested objects. For example, 'person__first,person__last' will become '{ person: { first, last } }' rather than '{ person__first, person__last }'

false
Example Payload for CSV to YAML⤓
Loading…

Deserialize BINARY​

Deserialize BINARY data | key: deserializeFromBinary

InputNotesExample
Data

BINARY text to deserialize so it can be referenced in a subsequent step.

Example Payload for Deserialize BINARY⤓
Loading…

Deserialize CSV​

Deserialize CSV data | key: deserializeFromCsv

InputNotesExample
Data

CSV text to deserialize so it can be referenced in a subsequent step.

"person__first","person__last","dob"
"Bob","Johnson","1990-01-01"
CSV Header

Specify if your CSV contains a header row.

true
Un-Flatten CSV Keys

When enabled, keys with double-underscores will be parsed as nested objects. For example, 'person__first,person__last' will become '{ person: { first, last } }' rather than '{ person__first, person__last }'

false
Example Payload for Deserialize CSV⤓
Loading…

Deserialize JSON​

Deserialize JSON data | key: deserializeFromJson

InputNotesExample
Data

JSON text to deserialize so it can be referenced in a subsequent step.

{
  "person": {
    "first": "Bob",
    "last": "Johnson"
  },
  "dob": "1990-01-01"
}
Example Payload for Deserialize JSON⤓
Loading…

Deserialize JSON Lines (.jsonl)​

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

InputNotesExample
JSONL Data
["Name", "Session", "Score", "Completed"]
["Gilbert", "2013", 24, true]
["Alexa", "2013", 29, true]
["May", "2012B", 14, false]
["Deloise", "2012A", 19, true]

Deserialize URL-encoded Form Data​

Deserialize Form Data (x-www-form-urlencoded) | key: deserializeFormData

InputNotesExample
Data

Form data to deserialize so it can be referenced in a subsequent step.

foo=bar&baz=123
Example Payload for Deserialize URL-encoded Form Data⤓
Loading…

Deserialize XML​

Deserialize XML data | key: deserializeFromXml

InputNotesExample
Data

XML text to deserialize so it can be referenced in a subsequent step.

<dob>1990-01-01</dob>
<person>
  <first>Bob</first>
  <last>Johnson</last>
</person>
Parse numbers as strings?

Interpret numbers as strings?

false
Example Payload for Deserialize XML⤓
Loading…

Deserialize YAML​

Deserialize YAML data | key: deserializeFromYaml

InputNotesExample
Data

YAML text to deserialize so it can be referenced in a subsequent step.

---
person:
  first: Bob
  last: Johnson
dob: '1990-01-01'
Example Payload for Deserialize YAML⤓
Loading…

JavaScript Object to CSV​

Convert JavaScript Object to CSV | key: binaryToCsv

InputNotesExample
Data

JavaScript Object data to convert to CSV

Example Payload for JavaScript Object to CSV⤓
Loading…

JavaScript Object to JSON​

Convert JavaScript Object to JSON | key: binaryToJson

InputNotesExample
Data

JavaScript Object data to convert to JSON

Example Payload for JavaScript Object to JSON⤓
Loading…

JavaScript Object to XML​

Convert JavaScript Object to XML | key: binaryToXml

InputNotesExample
Data

JavaScript Object data to convert to XML

Example Payload for JavaScript Object to XML⤓
Loading…

JavaScript Object to YAML​

Convert JavaScript Object to YAML | key: binaryToYaml

InputNotesExample
Data

JavaScript Object data to convert to YAML

Example Payload for JavaScript Object to YAML⤓
Loading…

JSON to CSV​

Convert JSON to CSV | key: jsonToCsv

InputNotesExample
Data

JSON data to convert to CSV

{
  "person": {
    "first": "Bob",
    "last": "Johnson"
  },
  "dob": "1990-01-01"
}
Example Payload for JSON to CSV⤓
Loading…

JSON to XML​

Convert JSON to XML | key: jsonToXml

InputNotesExample
Data

JSON data to convert to XML

{
  "person": {
    "first": "Bob",
    "last": "Johnson"
  },
  "dob": "1990-01-01"
}
Example Payload for JSON to XML⤓
Loading…

JSON to YAML​

Convert JSON to YAML | key: jsonToYaml

InputNotesExample
Data

JSON data to convert to YAML

{
  "person": {
    "first": "Bob",
    "last": "Johnson"
  },
  "dob": "1990-01-01"
}
Example Payload for JSON to YAML⤓
Loading…

Pretty Print​

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

InputNotesExample
Data

Data to pretty print

Serialize JSON Lines (.jsonl)​

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

InputNotesExample
Array of JavaScript Objects to serialize

Must be a reference to an array of JavaScript objects

Serialize URL-encoded Form Data​

Serialize Form Data (x-www-form-urlencoded) | key: serializeFormData

InputNotesExample
Data

Form data to deserialize so it can be referenced in a subsequent step.

Example Payload for Serialize URL-encoded Form Data⤓
Loading…

XML to CSV​

Convert XML to CSV | key: xmlToCsv

InputNotesExample
Data

XML data to convert to CSV

<dob>1990-01-01</dob>
<person>
  <first>Bob</first>
  <last>Johnson</last>
</person>
Parse numbers as strings?

Interpret numbers as strings?

false
Example Payload for XML to CSV⤓
Loading…

XML to JSON​

Convert XML to JSON | key: xmlToJson

InputNotesExample
Data

XML data to convert to JSON

<dob>1990-01-01</dob>
<person>
  <first>Bob</first>
  <last>Johnson</last>
</person>
Parse numbers as strings?

Interpret numbers as strings?

false
Example Payload for XML to JSON⤓
Loading…

XML to YAML​

Convert XML to YAML | key: xmlToYaml

InputNotesExample
Data

XML data to convert to YAML

<dob>1990-01-01</dob>
<person>
  <first>Bob</first>
  <last>Johnson</last>
</person>
Parse numbers as strings?

Interpret numbers as strings?

false
Example Payload for XML to YAML⤓
Loading…

YAML to CSV​

Convert YAML to CSV | key: yamlToCsv

InputNotesExample
Data

YAML data to convert to CSV

---
person:
  first: Bob
  last: Johnson
dob: '1990-01-01'
Example Payload for YAML to CSV⤓
Loading…

YAML to JSON​

Convert YAML to JSON | key: yamlToJson

InputNotesExample
Data

YAML data to convert to JSON

---
person:
  first: Bob
  last: Johnson
dob: '1990-01-01'
Example Payload for YAML to JSON⤓
Loading…

YAML to XML​

Convert YAML to XML | key: yamlToXml

InputNotesExample
Data

YAML data to convert to XML

---
person:
  first: Bob
  last: Johnson
dob: '1990-01-01'
Example Payload for YAML to XML⤓
Loading…