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.

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 here.

• 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.

Once the workflow has completed a successful login, the remaining steps will use the Interact With Data option.

• 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 - 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 - 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. Add Cumulative data from the data builder step to Values field

• 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 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 will delete the indicated record id.

https://<YourServerName>:50000

Information on sending data through the Service Layer including attachments is found here.

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.

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.

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.

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.

• Once the basic structure is there, you can test run the workflow and check to ensure it runs sucessfully.