SAP Business One SQL (B1WebAPI) Connector Reference

Connect an integration to SAP Business One using the SAP Business One SQL (B1WebAPI) Connector for Saltbox. For the Hana version instead, see SAP Business One Hana (Service Layer) Connector for Saltbox.

Actions Reference provides details for actions used to build a workflow.
Function Reference provides a list of functions and different ways they can be used to build a mapping.
Workflow Trigger Reference provides details on how to configure advanced settings to fetch the data needed by a workflow.
- Format Settings Reference provides details about how to handle and pre-process trigger data.
Warnings Reference explain the details behind warnings found in Saltbox.
B1WebAPI Guides provide supporting walkthroughs for setting up and configuring B1WebAPI, which is required for this connector.

Release Notes for SAP Business One SQL (B1WebAPI) Connector

SAP Business One SQL (B1WebAPI) Connector updated - v7.15.1

v7.15.1 - September 5, 2023

Version 7.15.1 fixes an issue where BatchSubmit action incorrectly succeeds if the batch fails (68362).

SAP Business One SQL (B1WebAPI) Connector updated - v7.15.0

v7.15.0 - August 8, 2023

Version 7.15.0 adds support for LandedCosts object type to B1 Object actions.

SAP Business One SQL (B1WebAPI) Connector updated - v7.15.0

v7.15.0 - August 8, 2023

Version 7.15.0 adds support for LandedCosts object type to B1 Object actions.

SAP Business One SQL (B1WebAPI) Connector updated - v7.14.0

v7.14.0 - May 29, 2023

Version 7.14.0 adds actions to support UoM and UoM groups (requires upgrade of B1WebAPI webs). This version also fixes a bug when loading and posting oJournalVouchers objects.

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.5

v7.13.5 - February 27, 2023

Version 7.13.5 fixes a bug resulting in a connection error when the specified base URL ends with a forward slash (/) (64044).

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.4

v7.13.4 - November 16, 2022

Version 7.13.4 fixes a bug where SSL certificate validation was not working (61879).

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.3

v7.13.3 - November 14, 2022

Version 7.13.3 adds support for CSV output type to Bulk Data Query action.

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.2

v7.13.2 - September 19, 2022

Version 7.13.2 fixes a bug when using the trigger GetWorklfowMessagesv2 - "All" filter option did not select expected data (57263).

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.1

v7.13.1 - August 22, 2022

Version 7.13.1 updates config options for B1 Object Type on triggers and actions to improve usability.

SAP Business One SQL (B1WebAPI) Connector updated - v7.13.0

v7.13.0 - July 4, 2022

Version 7.13.0 adds support for beta functionality - dynamic schema generation.

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.4

v7.12.4 - May 9, 2022

Version 7.12.4 fixes a bug in the "Get List Of Workflows" trigger where it wouldn't exclude deleted messages (57147).

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.3

v7.12.3 - April 18, 2022

Version 7.12.3 includes updates to configuration settings, defaults and tooltips to improve usability and ease of setup.

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.2

v7.12.2 - April 4, 2022

Version 7.12.2 adds CardCode as a parameter to the Visual Data Mapper function GetItemPrice.

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.1

v7.12.1 - March 14, 2022

Version 7.12.1 fixes a bug in date variables where they were case sensitive (and now are not) (55350).

SAP Business One SQL (B1WebAPI) Connector updated - v7.12.0

v7.12.0 - March 9, 2022

Version 7.12.0 adds support for date variables such as {Today} and {Today-7}.

SAP Business One SQL (B1WebAPI) Connector updated - v7.11.1

v7.11.1 - March 7, 2022

Version 7.11.1 adds default settings to workflow triggers.

SAP Business One SQL (B1WebAPI) Connector updated - v7.11.0

v7.11.0 - February 28, 2022

Version 7.11.0 adds a new action to upload and install a metadata.zip package - Requires B1WebAPI v100.24.0.5 or higher.

SAP Business One SQL (B1WebAPI) Connector updated - v7.10.0

v7.10.0 - February 21, 2022

Version 7.10.0 adds support for Project Codes as B1ObjectType and new actions to support Financial Projects.

SAP Business One SQL (B1WebAPI) Connector updated - v7.9.0

v7.9.0 - February 14, 2022

Version 7.9.0 improves error messages encountered by the connector and adds additional support to early-access functionality.

SAP Business One SQL (B1WebAPI) Connector updated - v7.8.0

v7.8.0 - January 31, 2022

Version 7.8.0 adds support to set B1ObjectType dynamically in a workflow (53545).

SAP Business One SQL (B1WebAPI) Connector updated - v7.7.3

v7.7.3 - January 17, 2022

Version 7.7.3 resolves an error in BulkDataQueryMessageSource when output is JSON (53212).

SAP Business One SQL (B1WebAPI) Connector updated - v7.7.2

v7.7.2 - January 11, 2022

Version 7.7.2 resolves an issue in beta functionality that retrieves queries by category (52976).

SAP Business One SQL (B1WebAPI) Connector updated - v7.7.1

v7.7.1 - January 10, 2022

Version 7.7.1 fixes a bug where a trigger shows as successful even though it had an error (52849).

SAP Business One SQL (B1WebAPI) Connector updated - v7.7.0

v7.7.0 - January 4, 2022

Version 7.7.0 adds support for a new bulk data message source.

SAP Business One SQL (B1WebAPI) Connector updated - v7.6.0

v7.6.0 - December 21, 2021

Version 7.6.0 adds support for beta functionality related to remote data functions that retrieve query categories and queries by category.

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.4

v7.5.4 - November 29, 2021

Version 7.5.4 resolves a backward compatibility issue with the action Insert B1 Object Record (51372) and resolves a bug in error message reporting for soft failure (51341).

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.3

v7.5.3 - November 8, 2021

Version 7.5.3 adds the soft failure option to object "unit of work" actions.

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.2

v7.5.2 - October 25, 2021

Version 7.5.2 includes a patch to closed beta functionality. This version is compatible with production projects, and includes all previous bug fixes.

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.1

v7.5.1 - September 27, 2021

Version 7.5.1 fixes a bug in adding Attachments using the "Attachment2" object.

SAP Business One SQL (B1WebAPI) Connector updated - v7.5.0

v7.5.0 - September 13, 2021

Version 7.5.0 adds support for remote data functions "GetParameters" and "ExecuteDataFunctionAsStream". Remote data functions are a beta feature.

SAP Business One SQL (B1WebAPI) Connector updated - v7.4.1

v7.4.1 - August 23, 2021

Version 7.4.1 fixes a bug in Item Price actions when using specific dates and quantities. This version also improves support in other connectors that use B1WebAPI functions.

SAP Business One SQL (B1WebAPI) Connector updated - v7.4.0

v7.4.0 - August 16, 2021

Version 7.4.0 adds a new action to support object hydration within a workflow, and trigger options have been updated. This addresses a bug where workflow triggers resulted in silent errors only visible in SAP Business One.

SAP Business One SQL (B1WebAPI) Connector updated - v7.3.1

v7.3.1 - August 11, 2021

Version 7.3.1 improves test options and updates schemas.

SAP Business One SQL (B1WebAPI) Connector updated - v7.3.0

v7.3.0 - June 28, 2021

Version 7.3.0 adds support for Inventory Count, Timesheet and Inventory Posting endpoints.

SAP Business One SQL (B1WebAPI) Connector updated - v7.2.3

v7.2.3 - June 21, 2021

Version 7.2.3 fixes a bug where JPEG attachments become corrupt.

SAP Business One SQL (B1WebAPI) Connector updated - v7.2.2

v7.2.2 - May 31, 2021

Version 7.2.2 fixes a bug where workflow messages whose data contains the keyword "error" won't load in Saltbox.

SAP Business One SQL (B1WebAPI) Connector updated - v7.2.1

v7.2.1 - May 25, 2021

Version 7.2.1 resolves an issue when loading certain visual data mappings.

SAP Business One SQL (B1WebAPI) Connector updated - v7.2.0

v7.2.0 - May 10, 2021

Version 7.2.0 adds support for oGoodsReturnRequest, oPurchaseRequest and oReturnRequest objects.

SAP Business One SQL (B1WebAPI) Connector updated - v7.1.0

v7.1.0 - April 21, 2021

Version 7.1.0 adds a new Workflow Trigger "WorkflowMessage v2", which updates the message status in B1 upon failure.

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.4

v7.0.4 - March 10, 2021

Version 7.0.4 patches Purchase Quotation actions and schemas.

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.3

v7.0.3 - March 3, 2021

Version 7.0.3 adds support for Purchase Quotes in existing actions and message sources.

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.2

v7.0.2 - December 10, 2020

Version 7.0.2 patches an issue with the action "AttachmentUploadAndProcess".

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.1

v7.0.1 - October 28, 2020

Version 7.0.1 features clearer error messages in the cases of connection failure or transaction failure.

SAP Business One SQL (B1WebAPI) Connector updated - v7.0.0

v7.0.0 - October 21, 2020

Version 7.0.0 features changes to attachment actions which are not backward-compatible. Other features remain unaffected.

SAP Business One SQL (B1WebAPI) Connector updated - v6.5.0

v6.5.0 - October 15, 2020

Version 6.4.1 features schema files to support data mappings.

B1WebAPI Connector updated - v6.4.1

v6.4.1 - September 16, 2020

B1WebAPI Connector version 6.4.1 features improved support for special characters.