This document described the use of the Bizweaver DataBuilder tool. This tool is used to create JSON and XML data structures for use with web service APIs.

The following documents contain additional information that may be helpful with the development of Bizweaver workflows.

• WebService Tool

You will need to know, or have examples of , the data structures the API is expecting. This includes element (field names) and child objects within the structure. Keep in mind that names will generally require an exact match, including case.

An easy way to view the data structures used for SAP Business One is to create a small workflow that executes a GET on the object in question. The workflow will have two WebService2 steps: a login step and a GET step. The GET step references the target object (e.g. SalesOrders). The GET step will return the data structure for the object in the “Output String.” This is also an easy way to create a template file for the object in your environment as it will include any user-defined fields as well.

More information dealing with SAP Service Layer can be found here

1. Input will generally be from a SQL Reader step.
2. The example used in this page is for JSON. The same general process is also used for XML.

1. Create an input (SQL Reader) step for each dataset that will be needed. An example would be order header and order lines.
2. Create a DataBuilder step for each dataset.
3. Once all DataBuilder steps are created, add the lower-level datasets to the main dataset. The lower-level datasets are referenced by their Object Name. These are listed in the “Field Type” drop-down after they are created.
4. The “CumulativeData” variable from the main DataBuilder step in referenced in the web service step that transmits the information to the API.