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 | 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. | ||||||
| Field Mapping | Mapping with JSON data with Form fields.
|
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/workflowapps/packagepublished/listuserviews
Sample JSON Result: ?
| Code Block | ||
|---|---|---|
| ||
{
"dataapps": [{
"id": "crm",
"name": "CRM",
"userviews": [{
"packageName"id": "crm_userview_sales",
"description": "",
"name": "CRM: Sales Force Automation",
"packageIdurl": "/jw/web/userview/crm/crm_userview_sales",
"version": 1
}],
{"version": 1
}, {
"packageNameid": "Dashboardhr_expense",
"name": "HR Expenses Claim App",
"packageIduserviews": "dashboard"
[{
}"id": "hr_expense_userview",
{"description": "",
"packageNamename": "HR ExpenseExpenses Claim App for Admin",
"packageIdurl": "/jw/web/userview/hr_expense/hr_expense_userview",
"version": 2
}],
"version": 2
}, {
"id": "isr",
"packageNamename": "ISR",Internal Service Request",
"userviews": [{
"packageIdid": "isr",
} "description": "",
{ "name": "Internal Service Request App",
"packageNameurl": "JSON App"/jw/web/userview/isr/isr",
"version": 1
}],
"version": 1
"packageId }, {
"id": "jsonAppims",
}"name": "Simple Invoicing",
"userviews": [{
"id": "ims",
"packageNamename": "LeaveSimple AppInvoicing",
"packageIdurl": "/jw/web/userview/ims/ims",
"leaveApp" "version": 1
}],
"version": 1
}]
} |
Figure 4: Sample JSON data saved in Joget form data table
You can download the test app from APP_json1-1-20151026181405.jwa.