Differences

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

--- bw2:sbo_sl_v26 [2021/02/10 17:27]
akoehler created
+++ bw2:sbo_sl_v26 [2022/08/23 14:26] (current)
akoehler
@@ Line 1: / Line 1: @@
-===UnderConstruction===
+===== 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 (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.
+</WRAP>
+The difference in Bizweaver v2.6 is that a Service Layer global connection can be used to manage much of the detail work.  Configuring a Service Layer global connection is described **//[[bw2:global_connections#sap_service_layer_connections|here]]//**.
+==== Login Step ====
+{{ :bw2:bizweaversl26_1.png |}}
+  * Select **SAP Service Layer** in the "Select Service" drop-down list.
+  * Select **Authenticate** in the next drop-down to the right.
+  * Select the **Authentication Required** checkbox.
+  * Select your previously defined Service Layer connection in the "Select Connection" drop-down.
+  * Click the **Validate Login** link to confirm that your connection is working.  If the response is not //True//, check your connection information and try again.
+==== Interact With Data Steps ====
+Once the workflow has completed a successful login, the remaining steps will use the **Interact With Data** option.
+{{ :bw2:bizweaversl26_2.png |}}
+  * Select **SAP Service Layer** in the "Select Service" drop-down list.
+  * Select **Interact With Data** in the next drop-down to the right.
+    * No other information is needed in this section as the log-in step has provided the needed credentials.
+  * Select an action from the four options
+===Query===
+    * **Query** - This will only select (read) data from the selected object
+      * In the **Record ID** field, you can enter the primary key for the Object for **Orders** it would be **DocNum**
+      * Selecting any of the Feilds in the "Name Column" will filter results to select only those fields when querying. The Feilds can be seen in the textbox below **Text in the box can be modified**.
+      * When you select fields and save when the tool is reentered, it will only show the selected fields.
+        * To select more fields, refresh the object list and select or remove fields as needed.
+      * **When Query is selected, and fields are selected to limit the query, and you switch to another option, it will clear the query limitations, and the fields need to be unselected and reselected to limit the query again.**
+===Add Record===
+    * **Add Record** - This will add new records to SAP.
+      * Select **Refresh Object List** to populate the object list.
+      * Select the desired object from the list
+      * Enter the relevant variable or data in the "Value" field
+      * **Lines** - when adding lines, you have to select the relevant option in the field list for **Orders** it is **DocumentLines**
+        * To add lines, the databuilder is needed to format the data into JSON. Once the data is built, it can be entered into the **Value** column for the lines. See example below
+Note the lack of array name. The service layer tool will add the array name, so the only thing needed is the array data.
+{{ :bw2:bizweaversl26_3.png |}}
+**Add Cumulative data from the data builder step to Values field**
+{{ :bw2:bizweaversl26_4.png |}}
+       * When you select fields and save when the tool is reentered, it will only show the selected fields.
+       * To select more fields, refresh the object list and select or remove fields as needed
+===Patch===
+  * **Patch** is used to update a record in SAP.
+    * Enter the record id that needs updating.
+    * 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 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.
+<WRAP center round tip 60%>
+More information on the various objects and methods is available on your HANA server using this URL in a browser on your network.  <file>https://<YourServerName>:50000</file>
+</WRAP>
+==== 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