Infor Process Designer - JSON the Sequel

I showed you how to use the JSON Parser to parse your JSON data, but there is another way you can accomplish this using JavaScript in the Assign node.

Use the File Access to load the JSON file into memory and then an Assign - JavaScript Expression - to cycle through to retrieve your input values (which could then be written out to an export variable within the same function).

x=FileAccess5480_outputData.split("\n")

for (i=0;i

{

j=JSON.parse(x[i])

emp=j.Employee

dept=j.Department

outputData+=emp+”,”+dept+”\n”

}

We know that Infor’s JSON file doesn't always include the data elements when that value doesn’t exist, so you could build an edit for the fields that might be missing;    

dept=j.Department ;if (dept===undefined) dept=””

Not just answers, providing solutions