Description:

This step fetches 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, then click the Save button. Note: Click the "AI Predict" button to have the Copilot add new process steps that match your process description. 

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

• The JSON script used in this example is provided 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 specify the variable or global reference to store the JSON result. Click the Save button. Note: Click the "AI Predict" button to have the Copilot add new process steps that match your process description. 

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

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

https://jsonpath.com/ 

• The “Logging” configuration is necessary for documentation and also measures workflow progress and 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 execute it. Render the process instance. Click the “JsonPathGetValue” process step to view its properties. The step should retrieve 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: After import, please verify and complete the process steps for any missing configurations, including file path references and database connections. Then, save the definition to confirm the changes.

Click here to download the sample file.