For example, you might want to add a JSON Data Bank to view the results and/or a JSON Assertor to validate the results. Using Output Tools to View and Process Query ResultsĪny tools that operate on JSON can be added as outputs to a MongoDB Query tool. The following query returns only the sku field for product id 101 from the products collection. The following query returns all fields of product id 101 from the products collection. The following query returns all the items in the product collection. If empty, the default value will be used. Specifies the projection in the strict mode of the MongoDB Extended JSON language (see the MongoDB Documentation for details). Specifies the query in the strict mode of the MongoDB Extended JSON language (see the MongoDB Documentation for details). Specifies the name of the MongoDB collection to query. Specifies the name of the MongoDB database to query

You can configure the following settings. Once a MongoDB Query tool is added to a suite, you can add any JSON tool as an output. Before the tool can be run, you must configure the MongoDB connection, as well as the query you want to run. You can also add them as Virtualize provisioning action tools. You can add MongoDB Query tools as standalone tools with the SOAtest Add Test wizard. Apply the changes and restart SOAtest/Virtualize.Īdd the mongodbquerytool.jar file to the property in your settings properties file.Browse to the mongodbquerytool.jar file and click Open.Choose System Properties and click Add JARs.The tool can be installed from the UI or the command line. This tool requires SOAtest/Virtualize 9.5 or later.The following MongoDB versions are supported:.

Mongodb json query