Format Settings Reference for SAP Business One Hana (Service Layer) 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.

SAP Business One Hana (Service Layer) Connector triggers utilize the following message formats:

Message Format Description Version
Service Layer B1Query Converter DEPRECATED. Handle Service Layer Query data. When using query-based message sources, use this message format to automatically split messages based on query records. 1.0+
Service Layer B1Query Converter v2 Handle v2 Service Layer query data. When using v2 query-based message sources, use this message format to automatically split messages based on query records. 1.0+
Service Layer Converter Handle Service Layer’s message format. Converts standard Service Layer json data into message XML. 1.0+

Message Formats

Service Layer B1Query Converter

Message Format Description Version
Service Layer B1Query Converter DEPRECATED. Handle Service Layer Query data. When using query-based message sources, use this message format to automatically split messages based on query records. 1.0+

This applies to message sources: B1Query and WorkflowMessage.

Note that when splitting query results, this option is found in the Source Settings (“Split query result”), as opposed to within advanced raw message contents settings.

Service Layer B1Query Converter v2

Message Format Description Version
Service Layer B1Query Converter v2 Handle v2 Service Layer query data. When using v2 query-based message sources, use this message format to automatically split messages based on query records. 1.0+

This applies to message sources B1Query v2 and WorkflowMessage v2.

Note that when splitting query results, this option is found in the Source Settings (“Split query result”), as opposed to within advanced raw message contents settings.

Service Layer Converter

Message Format Description Version
Service Layer Converter Handle Service Layer’s message format. Converts standard Service Layer json data into message XML. 1.0+

This is the default message format for most Service Layer message sources. It’s used to translate SAP Business One Hana (Service Layer) messages (in json format) into message XML.