E9.2 How do I use the "Data Set Variable Name" in Custom Request (Script) in JDE ORCH?

[patrick.lemos]

In the custom request Module in the JDE Orchestrator development studio, it appears that we have a way to output a list of items via this "Data Set Variable Name" object.

I can't find any document that mentions the use of this object.

Again, I would like to know if there is a way to create an output list from the Custom Script module by using this "Data Set Variable Name" object.

Thanks,

 

[DaveWagoner]

The template that appears when you select your scripting language shows you how to populate the array variable

Jython:
#array =[{"Column1":"test1", "Column2":"val1"},{"Column1":"test2", "Column2":"val2"}]
#returnMap["Output Array"] = json.dumps(array)

If you use their naming for the array "Output Array" and Column1,Column2, it looks like this in your script component. Testing should populate the first instance of the array to show you that it is working. The Data Set Variable Name gets used later in your orchestration or logic extension and can be iterated over or looped within lex.

With most things oracle, the documentation is a bit thin, and that's if you can find it.

 

[patrick.lemos]

It appears that that Data Set Variable Name must be named "Output Array". I don't think other names work.

However, we can have whatever column name we like.

Thanks again.

 

[DaveWagoner]

the dataset var name is whatever you want it to be, just change the name within the script
returnMap["Output Array"] = json.dumps(array)