Differences

This shows you the differences between two versions of the page.

--- bw2:sbo_sl_v26 [2021/02/11 11:51]
akoehler [Interact With Data Steps]
+++ bw2:sbo_sl_v26 [2022/08/23 14:26] (current)
akoehler
@@ Line 1: / Line 1: @@
 ===== SAP Business One Service Layer using Bizweaver v2.6 and higher =====
-Accessing SAP Business One using the Service Layer is a two-step process. The first step (Login) responds with two cookies. These cookies are then used in any subsequent web service calls in the current processing cycle.
+Accessing SAP Business One using the Service Layer is a two-step process. The first step (Log in) responds with two cookies. These cookies are then used in any subsequent web service calls in the current processing cycle.
 <WRAP center round tip 60%>
-Accessing SAP Business One via the Service Layer is available for HANA on v9.3 only.  It is available for both HANA and SQL Server beginning with SAP Business One v10 PL02.
+Accessing SAP Business One via the Service Layer is available for HANA on v9.3 only.  It is available for both HANA and SQL Server, beginning with SAP Business One v10 PL02.
 </WRAP>
@@ Line 56: / Line 56: @@
     * Select the fields that need to be updated.
     * Enter the values for the selected fields.
-  * **When updating records in SAP it is best to update the whole record as opposed to doing a target update. As in most cases, SAP Service Layer will overwrite data in the record instead of adding it to the end.**
+  * **When updating records in SAP, it is best to update the whole record instead of doing a target update. As in most cases, SAP Service Layer will overwrite data in the record instead of adding it to the end.**
 ===Delete===
   * **Delete** will delete the indicated record id.
@@ Line 65: / Line 65: @@
 ==== Working with the Service Layer ====
+Information on sending data through the Service Layer including attachments is found **//[[bw2:Sending Data to the Service Layer|here]]//**.
+====== Sample Building JSON for SAP Business One Service Layer ======
+===== Workflow =====
+This workflow builds one section of a JSON structure for an SAP Business One sales order.  The section is just the rows as the header information will be entered into the Web Service step.  Each section consists of a SQL statement to gather the needed information and the DataBuilder to format it.  Once the pieces are constructed, the output is sent to the SAP Service Layer API in the WebService step.  Other APIs will work similarly.
+{{ :bw2:bizweaversl26_5.png |}}
+===== Gather Header Information  =====
+In this example, we are using the SQL/Tool to gather all the relevant header information. This will be entered directly into the WebService step using the SAP Service Layer Connector.
+===== Create the Lower-Level DataBuilder Step(s) =====
+{{ :bw2:bizweaversl26_6.png |}}
+This will be the next section in the expected data structure needed by the SAP Service layer. The object name will not be entered as the SAP Service Layer Connector will provide when submitting the data.
+===== Reference Lower-level Objects in the WebServices Step =====
+Once the DataBuilder steps for the lower-level objects have been created, they can be referenced in the WebServices step. This is what causes the entire data structure to be created when the workflow is executed.
+  * Press F4 to select the Cumulative data variable from the databuilder step.
+{{ :bw2:bizweaversl26_7.png |}}
+  * Once the basic structure is there, you can test run the workflow and check to ensure it runs successfully.
+==== Sending Data to the Service Layer ====
 Information on sending data through the Service Layer is found **//[[bw2:Sending Data to the Service Layer|here]]//**.

Wiki

User Tools

Site Tools

Differences

Page Tools