SAP Business One Hana (Service Layer) Connector updated
Version 1.24.0
SAP Business One Hana (Service Layer) Connector version 1.24.0 adds new actions to support SQL Query functionality in Service Layer for B1 v10, as well as support for beta functionality.
New Features
Service Layer for SAP Business One version 10 supports SQL queries separate from standard “B1 Query” and “B1 Query Category” functionality. These actions are only supported for SAP Business One version 10.
Actions:
Create a SQL Query (version 10 only)- Create a new SQL Query in SAP Business One (B1). This action only works with B1 v10 FP 2011 or later. Data manipulation statements using DML are not allowed.Delete a SQL Query (version 10 only)- Delete an existing SQL Query with the specified key. This action only works with B1 v10 FP 2011 or later.Get a List of SQL Queries (version 10 only)- Get a list of SQL Queries, as filtered using advanced options. This action only works with B1 v10 FP 2011 or later.Get a SQL Query (version 10 only)- Get an existing SQL Query with the specified key. This action only works with B1 v10 FP 2011 or later.Get SQL Query Results (version 10 only)- Execute and get all results from the specified SQL query. Parameters may be supplied, if required by the query.Update a SQL Query (version 10 only)- Update an existing SQL Query in SAP Business One (B1). This action only works with B1 v10 FP 2011 or later.
Workflow Trigger Message Source:
Get SQL Query Results (version 10 only)- Execute and get all results from the specified SQL query. Parameters may be supplied, if required by the query. Query results may be split into multiple messages using Message Format Settings.
Early Adopter/Beta functionality:
- Added support for remote data functions that retrieve query categories and queries by category.
Updates
none
Bug Fixes
none
Requirements
As of version 1.21.0, Application server version 2.8 or later is required. To verify, go to System Information > Status Check and verify the Application server version. Shown below, the Application server is a higher/newer version and so can be used with this version of the SAP Business One Hana (Service Layer) Connector.
If your engine is on an older version, contact your implementation consultant for next steps.
References
For more Connector details, see: SAP Business One Hana (Service Layer) Connector Details