The JSON Tool enables one to issue a JSON webservice call and to save the returned data into Joget's form data or/and into the process's workflow variable.
Figure 1: JSON Tool Properties - Configure JSON Tool
|JSON URL||URL to be called.|
Figure 2: JSON Tool Properties - Store to Form
|Form||Target form to store data to.|
|Base JSON Object Name for Multirow Data||Name of the object that contains an array to be based on.|
Mapping with JSON data with Form fields.
Figure 3: JSON Tool Properties - Store to Workflow Variable
|Workflow Variable Mapping|
In figure 2 and 3, one will need to specify on how to treat the returned data. The returned data may be saved as form data or/add to be saved into process's workflow variable. The example used in this article shows on how one can store multi-row data into a form data table.
Sample JSON API: http://localhost:8080/jw/web/json/apps/published/userviews
Sample JSON Result:
Figure 4: Sample JSON data saved in Joget form data table
You can download the test app from APP_json1-1-20151026181405.jwa.