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
| Name | Description |
|---|---|
| JSON URL | URL to be called. |

Figure 2: JSON Tool Properties - Store to Form
| Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| Form | |||||||
| Base JSON Object Name for Multirow Data | |||||||
| Field Mapping |
|

Figure 3: JSON Tool Properties - Store to Workflow Variable
| Name | Description | ||||||
|---|---|---|---|---|---|---|---|
| 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/workflow/package/list
Sample JSON Result: ?
{
"data": [
{
"packageName": "CRM",
"packageId": "crm"
},
{
"packageName": "Dashboard",
"packageId": "dashboard"
},
{
"packageName": "HR Expense App",
"packageId": "hr_expense"
},
{
"packageName": "ISR",
"packageId": "isr"
},
{
"packageName": "JSON App",
"packageId": "jsonApp"
},
{
"packageName": "Leave App",
"packageId": "leaveApp"
}
]
} |

Figure 4: Sample JSON data saved in Joget form data table