Solve API response issue with Enhanced JSON Tool

3 answers

1.  

   1

   0

   -1

   • Ian
   • Aug 07, 2024

   in the sample app in Enhanced JSON Tool Plugin . follow the pic example and switch response type to JSON in process 2, there's a beanshell there. Compare the beanshell with the JSONSample.txt under Resources in the App Composer. Think you can get the gist of it, then modify that in accordance to your JSON format.  

   •  Comment

   1. Fronsky

      • Aug 07, 2024

      Hi, tkx for your response!

      I am quite a newby, so a little bit dazzled about the different approach as suggested by John Smith. I try to follow and understand the example, but at the resource the link JSONsample.txt gives a 404. The file is missing.

      The demo app actual gives the same 404 result when starting the process :

      2232
      INFO 07 aug. 2024 11:13:28 org.joget.apps.app.service.AppDevUtil - Commit to Git repo by admin: Update package Enhanced_JSON_Tool_NEW. _
      2233
      INFO 07 aug. 2024 11:13:44 org.joget.marketplace.EnhancedJsonTool - GET : http://192.168.1.143:8080/jw/web/app/json_tool_dx_kb/resources/JSONsample.txt
      2234
      INFO 07 aug. 2024 11:13:44 org.joget.marketplace.EnhancedJsonTool - http://192.168.1.143:8080/jw/web/app/json_tool_dx_kb/resources/JSONsample.txt returned with status : 404

      When I try to follow the example, I come to undermentioned script, but gives a parsing error on line 9.

      ********

      import org.joget.workflow.model.service.*;
      import org.json.simple.JSONObject;    
      import org.json.simple.JSONArray;    
      import java.util.*; 

      Map parent = new HashMap();
      Collection arr = new ArrayList();

      for(Map obj : data.get("adressen")){
          //get any values from "value" array
          
          Map col = new HashMap();
          col.put("oospronkelijkBouwjaar", obj.get("oospronkelijkBouwjaar"));
      }
      //put the new map into "data"
      parent.put("data", arr.toArray());

      return parent;

      *********

      ERROR 07 aug. 2024 11:33:25 org.joget.marketplace.EnhancedJsonTool - Error executing script
      2247
      bsh.EvalError: Sourced file: inline evaluation of: ``import org.joget.workflow.model.service.*; import org.json.simple.JSONObject; . . . '' : The collection, array, map, iterator, or enumeration portion of a for statement cannot be null.

      
      

      
      

   2. Ian

      • Aug 07, 2024

      Oh right...it was awhile back...but I think the url path in the enhanced json plugin is wrong...the right path should be in the resources. In the resources, click on jsonsample.txt and you should see the url path. Copy that and paste it in the enhanced json tool in the process builder. And the default beanshell should work against that file.

   3. Ian

      • Aug 07, 2024

      I think your _embedded object is an array and it contains another array called addressen ? From the snippet code in the error...looks like it's abit wrong there

   CommentAdd your comment...
2.  

   1

   0

   -1

   • Fronsky
   • Aug 04, 2024

   Thank you for your help.

   I tried this, but gave undermentioned new error message. I probably forget some declaration or something?

   ERROR 04 aug. 2024 23:41:23 org.joget.marketplace.EnhancedJsonTool - Error executing script
   bsh.EvalError: Sourced file: inline evaluation of: ``import org.json.JSONObject; import org.json.JSONArray; String jsonResponse = . . . '' : Typed variable declaration : Error in method invocation: Method getVariable( java.lang.String ) not found in class'org.joget.workflow.model.WorkflowAssignment'

   
   

   •  Comment

   CommentAdd your comment...
3.  

   1

   0

   -1

   • John Smith
   • Aug 04, 2024

   hi,

   To handle the issue with the _embedded key in your JSON response, you can use a BeanShell script in the Enhanced JSON Tool. Here's a short script example:

   
   import org.json.JSONObject;
   import org.json.JSONArray;
   
   String jsonResponse = (String) workflowAssignment.getVariable("jsonResponse");
   
   JSONObject jsonObject = new JSONObject(jsonResponse);
   JSONObject embedded = jsonObject.getJSONObject("_embedded");
   JSONArray adressenArray = embedded.getJSONArray("adressen");
   JSONObject firstAddress = adressenArray.getJSONObject(0);
   
   String oorspronkelijkBouwjaar = firstAddress.getJSONArray("oorspronkelijkBouwjaar").getString(0);
   
   workflowAssignment.setVariable("oorspronkelijkBouwjaar", oorspronkelijkBouwjaar);
   

   This script gets the JSON response, navigates through the _embedded key, and extracts the oorspronkelijkBouwjaar value. Just add this script to the "Script" section of the Enhanced JSON Tool, bind the jsonResponse variable to your API response, and use the oorspronkelijkBouwjaar variable in your form.

   let me know how it goes

   •  Comment

   CommentAdd your comment...