Differences

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

--- bw2:sbo_sl_v26 [2021/02/11 18:20]
akoehler [Create the Lower-Level DataBuilder Step(s)]
+++ 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 is found **//[[bw2:Sending Data to the Service Layer|here]]//**.
+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 two sections of a JSON structure for an SAP Business One sales order.  The sections are the header and the rows.  Each section consists of a SQL statement to gather the needed information and the DataBuilder to format the information.  Once the pieces are constructed, the output is sent to the SAP Service Layer API in the WebService step.  Other APIs will work in a similar manner.
+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.
-{{  :bw:databuilder1.png?600  |}}
+{{ :bw2:bizweaversl26_5.png |}}
-===== Create Main DataBuilder Step =====
+===== Gather Header Information  =====
-{{  :bw:databuilder2.png?600  |}}
-This should always contain the first items of the data structure.
-  - Enter a workflow step name.
-  - Select the data source from the Datasource Object drop-down list.
-  - Select the desired data structure type to be created (JSON or XML).
-  - Leave the “Add as an array” checkbox cleared unless you know that the top-level object needs to be any array. This is uncommon.
-  - Select the "Top-level element" checkbox, assuming this is the top level (header) node of the structure.
-    - This option causes the "CumulativeData" step-variable to be cleared before starting to build a new structure.
-  - Enter the name of the top-level object.
-    - The requirements of the receiving API will determine this.
-    - In some cases, a top-level object name is not used; e.g. SAP Service Layer and BigCommerce.
-      - If a top-level object name is not used, leave the field blank.
-  - Create a row for each value to be included in the structure.
-  - Enter the output field name values in the right-side grid.
-    - The Field Name value will need to exactly match (including case) the value the API is expecting.
-  - Select the field type from the drop-down list.
-  - Press <**F4**> to get a list of variables from the associated Datasource Object and select the appropriate value.
-Continue this process for all desired fields in the top-level object.
-The data structure being built is displayed in the left-side panel as elements are added.
-The data structure cannot be altered in this area. The display is for information only.
+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) =====
-{{  :bw:databuilder3.png?600  |}}
+{{ :bw2:bizweaversl26_6.png |}}
-This will be the next section in the expected data structure. The process is the same as described in the “Main DataBuilder” step.
+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.
-For objects such as a set of rows, the display will only display a single entry. However, all data received as input will be included when the workflow executes.
+===== 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.
-All objects other than the main one will require an Object Name. This must exactly match (including case) what is expected by the API.
+  * Press F4 to select the Cumulative data variable from the databuilder step.
+{{ :bw2:bizweaversl26_7.png |}}
-===== Reference Lower-level Objects in the Main DataBuilder Step =====
+  * Once the basic structure is there, you can test run the workflow and check to ensure it runs successfully.
-Once the DataBuilder steps for the lower-level objects have been created, they can be referenced in the main DataBuilder step. This is what causes the entire data structure to be created when the workflow is executed.
+==== Sending Data to the Service Layer ====
+Information on sending data through the Service Layer is found **//[[bw2:Sending Data to the Service Layer|here]]//**.
-  - Click the “Field Type” drop-down in the main DataBuilder step. The names of the lower-level objects are displayed in addition to the standard field type values.
-  - Select the desired object.
-    - The Field Name and Value are automatically filled in.
-    - The lower-level object is displayed in the left-side data structure.
-{{  :bw:databuilder5.png?600  |}}
-Here is the resulting JSON that is sent in the API call.
-<code json>
-{
-"CardCode": "C20000",
-"DocDueDate": "20190313",
-"DocumentLines": [
-{
-"ItemCode": "A00001",
-"Quantity": 9,
-"LineTotal": 33.75
-},
-{
-"ItemCode": "A00001",
-"Quantity": 7,
-"LineTotal": 105
-}
-],
-"AddressExtension": [
-{
-"CItyB": "New York"
-}
-]
-}
-</code>
-===== Reference the Output of the Main DataBuilder Step in the API Call =====
-The output of the main DataBuilder step is used in the API call. This is done by using the “**CumulativeData**” variable from the Main DataBuilder step. An example is shown in the image below.
-{{  :bw:databuilder6.png?600  |}}

Wiki

User Tools

Site Tools

Differences

Page Tools