Description:

This step is used to fetch the JSON Result value

Usage:

Example:

Let’s build and execute the “jsonPathGetValueDef” example.          

• Create a new definition called “JsonPathGetValueDef” and open the definition in designer mode. 
• Drag the “updateVariable” and “JsonPathGetValue” steps to the canvas. 
• Connect the dots between the “Start” and other steps, as shown above.
• Define a variable or a global to store the result. 
• Click the “updateVariable” step to configure its “Required” properties. Provide a name for the step. Click the Save button. Note: Click the "AI Predict" button for the Copilot to add new process steps that match your process description. 

• Select the “Advanced” tab. Select the “Yes” option for the “Has Expression” field. Click the button below to update multiple variables. Click the Add Row (+) button to insert an empty row. Provide the variable name and value. Use the add row buttons to insert multiple variables and values. 

• The JSON script used in this example is included below. 

{"store": 
{"book": 
[{"category": "reference", "author": "Nigel Rees", "title": "Sayings of the Century", "price": 8.95},
{"category": "fiction", "author": "Evelyn Waugh", "title": "Sword of Honour", "price": 12.99},
{"category": "fiction", "author": "Herman Melville", "title": "Moby Dick", "isbn": "0-553-21311-3", "price": 8.99},
{"category": "fiction", "author": "J. R. R. Tolkien", "title": "The Lord of the Rings", "isbn": "0-395-19395-8", "price": 22.99}],          "bicycle": {"color": "red", "price": 19.95}},"expensive": 10
}

• Click the "JsonPathGetValue" step to configure its "Required" properties. Give the step a name and provide the variable or global reference to hold the JSON result. Click the Save button. Note: Click the "AI Predict" button for the Copilot to add new process steps that match your process description. 

• Click the "JsonPathGetValue" step to configure its "Optional" properties. Provide JSON Path expression and the variable or global reference for the JSON result. Click the button to map multiple JSON path expressions with variable or global references. You can retrieve JSON values using either single or multiple path expressions, but not both. Here $.Row[*].length path expression returns the total count of the records available in the SQL result set. Click the Save button. 

• You can refer to this website for more information on JSONPath expression syntax. 

https://jsonpath.com/ 

• The “Logging” setting configuration is necessary for documentation and also measures the workflow progress and the percent complete. This is achieved by configuring the step state and percent fields individually, as shown in the images below. Configure the “Logging” using the following properties.

• Save the process definition, create a new instance, and then execute it. Render the process instance. Click the “JsonPathGetValue” process step to view its properties. The step should get the JSON result value.

Definition Sample:

You may download the sample definition(s) from the link here and later import them (drag-and-drop) to your FlowWright Process Definition (XML file) or Form Definition (HTML file) page.

NOTE: Please verify and complete the process steps for any missing configurations, such as file path references and database connections, after import. Then, save the definition to confirm the changes.

Click here to download the sample file.