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 an 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 on 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. Their Object Name references the lower-level datasets. These are listed in the “Field Type” drop-down after they are created.
4. The “CumulativeData” variable from the main DataBuilder step is referenced in the web service step that transmits the API's information.

1. Tool Name: This is the name given to the tool. This will be displayed in the design canvas as well as the variable selector
2. Description: A space for notes about the tool.
3. DataSource Object: This is the source of data for the Databuilder.
   1. This is required and is always a SQL/HANA tool.
      1. Hint the number of rows you feed into the databuilder from the subsequent SQL step determines the number of sections is output. This is more helpful when dealing with XML over JSON but keeps this in mind while generating JSON or XML the SQL statement and the database for the databuilder step.
4. Data Type: This determines the type of file that is generated.
5. Add as an Array: this will add an array to your JSON or XML.
   1. Arrays will be displayed in the Field Type drop-down
   2. If selected, it will insert the Array into the JSON or XML where it is located in the list.
6. Top-Level Element: This clears the JSON or XML data if it is contained in a loop, so subsequent processes do not build on top of the previous cycle.
   1. This is generally used to update one thing at a time. If the API used can be updated with one large JSON or XML file, this option can be un-selected.
7. Create New Object: The Object name of the JSON or XML structure.
   1. This can be used to create multiple levels of XML or JSON (see example below)
8. Preview Box: A preview of the JSON or XML that is being built.
9. Name-Value Pair:
   1. Field Name: The name of the name-value pair
   2. Field Type: This can either be String, Numeric, Boolean, or an Array built later in the workflow.
   3. Value: Normally a variable from the connected SQL/HANA step. These can also be hard-coded values.
10. Add Row or Delete: The down arrow will add a row below the current row. The “X” will delete that row.

Below is an example of how to build a basic JSON File. The data is coming from SAP but this concept applies to any API being used to pass data to.

• Start by getting all the data needed and process that through a loop as we only want to process one record at a time in this example.
  • Note Most APIs are case-sensitive.
• Once the data is sent into the loop you will limit it down to one record and add link it to the next step which is the data builder step
  • Note Top-Level Element is selected. In this example, we are adding one record at a time

• Once the data is mapped add another loop to process all lines. This will be built as an array. The Create New Object is filled in as it is needed to identify the array.

• Once the lines data builder step is built you will then return to the header data builder step and it will now appear in the field type dropdown. Select it and it will now add the array to the header data builder step once it processes.

• Once the JSON is built it the Cumulative data variable from the Header step can be used and entered into the body section of a Web Service 2 tool to then be sent through the API.