Wiki

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.

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

• Delete will delete the indicated record id.

https://<YourServerName>:50000

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