...

Understanding JSON Data Bank

This tool enables you to extract certain JSON values (for example, from a request or response message) so that they can be used in another place. The JSON Data Bank tool can be chained to any other tool that outputs JSON. It can extract any information from the JSON and make that information available for later use. 

For example, you can configure a test suite that tests a bank’s service transactions. Test 1 of that test suite can log on to the service using a User ID, then the JSON response would return a session ID back to Test 1. Test 2 of that test suite can be configured to use the session ID from Test 1 to perform transactions. You can configure any of the tests in a test suite to use JSON response parameters as JSON request parameters.

Users typically configure a JSON Data Bank in SOAtest by accessing the "Use Data Source Wizard" while parameterizing a value in a tool such as the REST Client or Messaging Client tool. This provides a quick, intuitive, and largely automated way to extract data from one tool and use it another. You simply go to the tool where you want to insert extracted data, then use a wizard to specify what data (for example, from what tool) you want to extract. This is the usage model demonstrated in the Storing Results to Be Used in Subsequent Tests tutorial. This same method can be used to extract data that is used to set a variable. Alternatively, you can manually configure a JSON Data Bank tool to extract data from one tool, then manually configure other tools to use the extracted values.

You can use a JSON Data Bank in Virtualize, for example, to extract a value from an incoming request and use it to populate an element of the response to be sent when that request is received. You can configure JSON Data Banks automatically when using wizards to create virtual assets from traffic. In addition, you can use the "Use Data Source Wizard" to extract a value and use it as a parameterized value in a response. For Message Responders, you can extract values from the incoming request (body or header); for other tools (like tools used in action suites), you can extract values from another tool in the suite. Another option is to manually add a JSON Data Bank tool (as an output to an existing tool) that extracts the desired data, then configure other tools to use the extracted data.

Video Tutorial

In this video, you'll learn how to extract values from JSON responses and reuse them in other tests.

Configuring JSON Data Bank Using the Data Source Wizard

...

To use the "Use Data Source Wizard" wizard to configure a JSON Data Bank:

1. (Not applicable for use with Message Responders) Ensure that you have a test suite or action set with at least two tools.

2. In the configuration panel for the tool that you want use the extracted value, select one of the available Form views.
3. Go to the message element that you want to use the extracted value, then select Parameterized and Use Data Source Wizard from the available menus.
   
4. In the wizard that opens:
   1. For test and action suite tools, select the tool you want to extract a value from. The menu at the top of the panel will contain all tools in the test or responder suite that occur before the current tool you are configuring. For example, if you are configuring tool 4, tools 1, 2, and 3 will appear in this menu along with any data sources that may be available.

   2. Under For Message Responders, select the incoming request message that you want to extract a value from, then specify whether you want to extract values from the message body or message header. Under Expected Message, indicate what element(s) you want to extract, then click Add. The right panel lists the values you have configured for extraction and shows the name of the data source column where each value will be stored (if you keep the default setting).

...

You can also manually chain the JSON Data Bank tool to a tool within the test, Responder, or Action suite. To configure the JSON Data Bank as a chained tool, complete the following:(Not applicable for use with Message Responders)

1. Ensure that you have a test suite or action set with at least two tools.

2. Right-click the node for the tool associated with the data you want to extract (for example, if you want to extract a value from an incoming request or outgoing response, choose the Message Responder that handles those messages), then choose Add Output.

3. In the Add Output wizard, indicate where you want to extract the value fromfrom (for example, Incoming Request, Transport Header, Incoming Attachment, Outgoing Response, and so on), select JSON Data Bank from the list of tools, then click Finish. A JSON Data Bank node displays below the tool.

4. Configure the tool as follows:

   1. Use the available controls to specify what element you want to extract. To extract an element, select a value from the JSON tree and click Extract Element. The value you added displays in the Selected Element list with a Data Source Column name containing the name of the tool the value came from, as well as the extracted value.
      

      Info
      icon false title Working with the Expected Message
      The left panel displays the expected JSON response used to create a template from which you can select elements. If JSON Data Bank receives a valid JSON message (for example, from traffic or as defined in the client tool it is attached to), this panel will be populated automatically. Alternatively, you can copy a sample message into the Literal or Tree tabs. Note that the expected JSON does not get saved by default; if you want to save it, enable the Save Expected JSON option.

   2. If you later want to modify the element referenced by the extraction, click Modify, then modify it as desired. See JSON Selector Reference for details.

   3. Repeat steps a and b as needed to configure any additional extractions you want performed.
   4. In the bottom area of the JSON Data Bank configuration panel, customize the options as desired. See Tool Options for details.

...

• Save expected JSON: Specifies whether or not to save the expected JSON.
• Allow alteration: Specifies whether to allow the alteration of an extraction. When this option is selected, an Extract tab and an Alter tab display beneath the Selected Element list. To alter an extraction, enable Allow alteration, click the Alter tab, add an extraction by clicking Extract Element, and then modify the extraction by clicking Modify. The Modify dialog opens and contains the following options:

• XPath: Displays the selected XPath. See JSON Selector Reference for details.

• Alteration Type: Allows you to select how the Value you enter alters the JSON. Selecting Append will add the altered value to the end of the extraction. Selecting Prepend will add the altered value to the beginning of the extraction. Selecting Replace With will replace the entire extraction with the altered value you specify.
• Alteration Value: Allows you to specify either a fixed or parameterized value using a data source.
• Extract empty elements as: Specifies whether or not empty elements will be extracted. When this option is enabled, you can use the adjacent text field to specify a text string that indicates what "placeholder" value should be added for every empty extracted element.
  • This option applies when the extracted element is an empty string. For example, JSON { "name" : "" } has an empty string for "name".
  • Note that additional configuration is required if you use this option; see Handling Empty/Missing Elements to Maintain the Integrity of the JSON Response
• Extract missing elements as: Specifies whether or not missing elements will be extracted. When this option is enabled, you can use the adjacent text field to specify a text string that indicates what "placeholder" value should be added for every missing extracted element.
  • This option applies when the extraction fails to locate any matching nodes.
  • Note that additional configuration is required if you use this option; see Handling Empty/Missing Elements to Maintain the Integrity of the JSON Response.

 Viewing the Data Bank Variables Used During Test Execution

You can configure the Console view (Window> Show View> Console) to display the data bank variables used during test execution. For details, see Monitoring Variable Usage.

Handling Empty/Missing Elements to Maintain the Integrity of the JSON Response

Anchor
Handling Empty/Missing Elements to Maintain the Integrity of the JSON Response Handling Empty/Missing Elements to Maintain the Integrity of the JSON Response

...