Function Reference for SAP Business One Hana (Service Layer) Connector

In general, Functions are used by Visual Data Mapper to transform or generate target data within a map.

SAP Business One Hana (Service Layer) Connector provides several functions to aid with mappings in Visual Data Mapper.

XSLT queries are also provided, which can be used directly in XSLT data transformations instead of Visual Data Maps.

Category	Function Name	Description	Version
ODataQueryFunctions	`OData Query - Get Query Results`	Returns all results from the query.	1.0+
ODataQueryFunctions	`OData Query - Has Results Manual`	Returns all results from the query.	1.0+
ODataQueryFunctions	`OData Query - Has Results with Parts`	Returns `true` if the indicated query has results.	1.0+
ODataQueryFunctions	`OData Query Lookup`	Returns the value of the specified column in the query (if blank the first column is returned).	1.0+
ServiceLayer	`Date - Convert To B1 Date`	Attempts to convert the provided date string into B1-supported date string. Returns the date string or an invalid date message.	1.0+
ServiceLayer	`Date - Validate B1 Date`	Validates that the provided date is already in B1-supported date format. Outputs the date string as provided, or an invalid date message.	1.0+
ServiceLayer	`Query - Get Query Results`	Run a B1 query for the supplied Query Category name and Query name. Optionally supply parameters. Gets all results from the query.	1.0+
ServiceLayer	`Query - Has Results`	Returns `true` if the indicated query has results. Supports query parameters (optional).	1.0+
ServiceLayer	`Query Lookup`	Query Lookup	1.0+

Function Names

Category	Function Name	Description	Version
ODataQueryFunctions	`OData Query - Get Query Results`	Returns all results from the query.	1.0+

Category	Function Name	Description	Version
ODataQueryFunctions	`OData Query - Has Results Manual`	Returns all results from the query.	1.0+

Category	Function Name	Description	Version
ODataQueryFunctions	`OData Query - Has Results with Parts`	Returns `true` if the indicated query has results.	1.0+

Category	Function Name	Description	Version
ODataQueryFunctions	`OData Query Lookup`	Returns the value of the specified column in the query (if blank the first column is returned).	1.0+

Category	Function Name	Description	Version
ServiceLayer	`Date - Convert To B1 Date`	Attempts to convert the provided date string into B1-supported date string. Returns the date string or an invalid date message.	1.0+

Category	Function Name	Description	Version
ServiceLayer	`Date - Validate B1 Date`	Validates that the provided date is already in B1-supported date format. Outputs the date string as provided, or an invalid date message.	1.0+

Category	Function Name	Description	Version
ServiceLayer	`Query - Get Query Results`	Run a B1 query for the supplied Query Category name and Query name. Optionally supply parameters. Gets all results from the query.	1.0+

Category	Function Name	Description	Version
ServiceLayer	`Query - Has Results`	Returns `true` if the indicated query has results. Supports query parameters (optional).	1.0+

Category	Function Name	Description	Version
ServiceLayer	`Query Lookup`	Query Lookup	1.0+