You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Definition

The JSON Tool enables one to issue a JSON web service call, and to save the returned data into Joget's form data and/or into the process's workflow variable.


Figure 1: JSON Tool Properties - Configure JSON Tool

NameDescription
JSON URLURL to be called.
Call Type 
POST Method 
POST Parameters 
Custom JSON Payload 
Request Headers 
No Response Expected 
Debug Mode 

 

Figure 2: JSON Tool Properties - Store to Form

NameDescription
FormTarget form to store data to.
Base JSON Object Name for Multirow DataName of the object that contains an array to be based on.
Field Mapping

Mapping with JSON data with Form fields.

NameDescription
Field NameForm field ID
JSON Object NameJSON property name

 

Figure 3: JSON Tool Properties - Store to Workflow Variable

NameDescription
Workflow Variable Mapping
NameDescription
Workflow VariableWorkflow Variable Name.
JSON Object NameJSON property name.

 

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: 

{
    "apps": [{
        "id": "crm",
        "name": "CRM",
        "userviews": [{
            "id": "crm_userview_sales",
            "description": "",
            "name": "CRM: Sales Force Automation",
            "url": "/jw/web/userview/crm/crm_userview_sales",
            "version": 1
        }],
        "version": 1
    }, {
        "id": "hr_expense",
        "name": "HR Expenses Claim App",
        "userviews": [{
            "id": "hr_expense_userview",
            "description": "",
            "name": "HR Expenses Claim App for Admin",
            "url": "/jw/web/userview/hr_expense/hr_expense_userview",
            "version": 2
        }],
        "version": 2
    }, {
        "id": "isr",
        "name": "Internal Service Request",
        "userviews": [{
            "id": "isr",
            "description": "",
            "name": "Internal Service Request App",
            "url": "/jw/web/userview/isr/isr",
            "version": 1
        }],
        "version": 1
    }, {
        "id": "ims",
        "name": "Simple Invoicing",
        "userviews": [{
            "id": "ims",
            "name": "Simple Invoicing",
            "url": "/jw/web/userview/ims/ims",
            "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.

 

 

 

  • No labels