E9.2 Groovy Script Returning Formatted Json Help

[dtujo2022]

So I have gotten the hang of create custom formatted json within a Groovy script, but what I am struggling with is returning the Json in the orchestration as the object and not a string.
Here is what I have:

import com.oracle.e1.common.OrchestrationAttributes;
import java.text.SimpleDateFormat;
import groovy.json.*

HashMap<String, Object> main(OrchestrationAttributes orchAttr, HashMap inputMap)
{
  HashMap<String, Object> returnMap = new HashMap<String, Object>();
 
    def inputData = (String)inputMap.get("serialData")
    def jsonSlurper = new JsonSlurper();
    def datajson = jsonSlurper.parseText(inputData);
    def workOrders = datajson.fs_DATABROWSE_V553112N.data.gridData.rowset;
 
    def output = [
        "LoadNumber": (String) inputMap.get("LoadNumber"),
        "WorkOrders": []
    ]
 
    def workOrderMap = [:]

    workOrders.each { row ->
        def woKey = row.F553112L_DOCO
        def opKey = row.F5548S1_OPSQ

        if(!workOrderMap.containsKey(woKey)) {
            workOrderMap[woKey] = [
                "WONumber": row.F553112L_DOCO,
                "WOType": row.F553112L_DCTO,
                "WOOperations": []
            ]
        }

        def workOrder = workOrderMap[woKey]

        def operation = workOrder.WOOperations.find {it.OperationSequence == opKey}
        if(!operation){
            operation = [
                "OperationSequence": row.F5548S1_OPSQ,
                "OperationCode": row.F553112L_Y55OP,
                "Serials": []
            ]
            workOrder.WOOperations << operation
        }

        operation.Serials << ["SerialNumber": row.F5548S1_LOTN]
    }

    output.WorkOrders = workOrderMap.values().toList()
    
  returnMap.put("jsonout", output);

  return returnMap;
}

This is what it returns:



UPDATE- I had to add "def jsonOutput = JsonOutput.toJson(output)"
This got it working.

 

[DaveWagoner]

I "tested" myself here and didn't look this up in ChatGPT (which will come as a shocking surprise to regulars here)

The issue is, you've done GREAT to get your data into the format you want. jsonSlurper is hugely powerful, but it doesn't handle formatting of the data properly if you are after json output. To get the final mile, you need to use jsonBuilder to format your jsonSlurper object.

I think you're trying to figure this out "under your own power" so I'll leave it here. Good luck and report back!

Finally I would really encourage you to do what I didn't do for over a year, and take the plunge into Jython for your JSON work. It's much much much simpler and more approachable than groovy.

 

[DaveWagoner]

Ooh I see you solved it yourself! I didn't know you didn't need jsonBuilder.

 

[BOster]

I "tested" myself here and didn't look this up in ChatGPT (which will come as a shocking surprise to regulars here)

The issue is, you've done GREAT to get your data into the format you want. jsonSlurper is hugely powerful, but it doesn't handle formatting of the data properly if you are after json output. To get the final mile, you need to use jsonBuilder to format your jsonSlurper object.

I think you're trying to figure this out "under your own power" so I'll leave it here. Good luck and report back!

Finally I would really encourage you to do what I didn't do for over a year, and take the plunge into Jython for your JSON work. It's much much much simpler and more approachable than groovy.

Is Jython available by default at some TR level or do you need to enable it? I think I would prefer Jython (or Ruby) to Groovy but currently only option in our main environment is Groovy.

Edit 1:
May have answered my own question. I found a doc on Oracle about how to enable it and:

"Download either Jython 2.7.2 (tested with AIS 9.2.5.4 through 9.2.7.3) or Jython 2.7.3 (tested with AIS 9.2.7.4 and later)."

We are on TR9.2.4.3 and TR9.2.5.3 so I am guessing if it does work, its not supported at our TR level????

 

[DaveWagoner]

I will rely on my smarter & actual-experienced counterparts for the answers to your question! But I do know that at some point in the TR's, groovy is no longer preinstalled, and Jython & Jruby ARE (?). keeping groovy going involves a special install from your cnc. If your cnc really loves you, you will get access to all 3 languages ongoing.

 

[BOster]

Out of curiosity, what does the Orchestrator UI look like when you enable other scripting languages? In other words when I expand the "Manipulate Output" on my TR it simply has a text editor box captioned "Groovy".

 

[BOster]

Ok, proving once again the fastest way to answer a JDE question is to post to jdelist.com.... at which point you will immediately answer your own question.

It looks like additional scripting languages beyond Groovy started in TR9.2.5.4 and the Orchestrator UI has a drop down to select the scripting language you wish to use.

https://docs.oracle.com/en/applicat...al-scripting-languages-on-the-ais-server.html

 

[DaveWagoner]

Indeed! This is what it looks like if your CNC likes you: