Format Settings Reference for Saltbox Core Connector

In general, Format Settings are used by workflow triggers to define how to handle and pre-process data that is fetched from a system. This setting is responsible for converting data from one format (such as csv or json) into Saltbox Message format (XML) so it can be processed by the workflow. Some Connectors apply a default Data Source Format automatically, while others require configuration. This depends on the Connector, and is outlined where appropriate below.

Refer to the details below.

Saltbox Core Connector triggers utilize the following message formats. Note that these message formats are also available to other triggers, such as when a dedicated message format is not supplied.

Message Format Description Version
Binary Data (Base64) Handle binary base64 data formats so they can be used in a workflow. For example, handle attachment files. 11.2+
CSV Handle CSV data. Convert a CSV string into workflow message XML. 1.0+
CSV that will be Split Apart Handle CSV data. Convert a CSV string into workflow message XML, then split this source data into multiple smaller messages (as per advanced options). 11.11+
Excel that will be Converted into XML Handle Excel source data and convert it into XML data before sending into the workflow. 11.21+
JSON Handle JSON data. Convert JSON data into workflow message XML. 1.0+
PGP Decryption (CSV) Handle PGP encrypted CSV. Decrypt and convert a PGP encrypted CSV string into workflow message XML. 11.1, 11.2
XML Handle XML strings. Use this option to validate that the source data is properly formed XML. Invalid XML will result in a failure in the raw message. 1.0+
XML (Deprecated) This option is deprecated: use XML instead. Use this option to validate that the source data is in proper XML format. Invalid XML will result in a failure in the raw message. 1.0+
XML that will be Converted into CSV Handle XML source data and convert it into CSV data before sending into the workflow. The resulting message will contain CSV data in the node / rawContent. 1.0+
XML that will be Split Apart Handle XML strings. Use this option to validate that the source data is properly formed XML, then split this source data into multiple smaller messages (as per advanced options). Invalid XML will result in a failure in the raw message. 1.8+

Message Formats

Binary Data (Base64)

Message Format Description Version
Binary Data (Base64) Handle binary base64 data formats so they can be used in a workflow. For example, handle attachment files. 11.2+

This message format was renamed from Base64Converter in versions 11.9. To upgrade, simply update to Saltbox Core Connector version 11.10 or higher; no configuration changes are necessary.

CSV

Message Format Description Version
CSV Handle CSV data. Convert a CSV string into workflow message XML. 1.0+

CSV that will be Split Apart

Message Format Description Version
CSV that will be Split Apart Handle CSV data. Convert a CSV string into workflow message XML, then split this source data into multiple smaller messages (as per advanced options). 11.11+

Excel that will be Converted into XML

Message Format Description Version
Excel that will be Converted into XML Handle Excel source data and convert it into XML data before sending into the workflow. 11.21+

JSON

Message Format Description Version
JSON Handle JSON data. Convert JSON data into workflow message XML. 1.0+

PGP Decryption (CSV)

Message Format Description Version
PGP Decryption (CSV) Handle PGP encrypted CSV. Decrypt and convert a PGP encrypted CSV string into workflow message XML. 11.1, 11.2

This message format was removed in version 11.3. Use the latest version of the SFTP Connector for PGP decryption support.

XML

Message Format Description Version
XML Handle XML strings. Use this option to validate that the source data is properly formed XML. Invalid XML will result in a failure in the raw message. 1.0+

XML (Deprecated)

Message Format Description Version
XML (Deprecated) This option is deprecated: use XML instead. Use this option to validate that the source data is in proper XML format. Invalid XML will result in a failure in the raw message. 1.0+

XML that will be Converted into CSV

Message Format Description Version
XML that will be Converted into CSV Handle XML source data and convert it into CSV data before sending into the workflow. The resulting message will contain CSV data in the node / rawContent. 1.0+

XML that will be Split Apart

Message Format Description Version
XML that will be Split Apart Handle XML strings. Use this option to validate that the source data is properly formed XML, then split this source data into multiple smaller messages (as per advanced options). Invalid XML will result in a failure in the raw message. 1.8+