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


Figure 2: JSON Tool Properties - Store to Form


Figure 3: JSON Tool Properties - Store to Workflow Variable

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

  • No labels