Make Grouping Happen in the JSON
If I do a saved search on orders and items and use that in an application to retrieve the data, I get a JSON with the items in an array and the header information being part of the main record. This is exactly how I want it to work.
However, I am trying to perform a saved search to send Inventory information via EDI, and I want an array of all the records as a report, instead of individual records in my JSON.
If short, I don’t want individual records in my JSON like this:
{
“record” : “name”,
“thing 1” : “5”
},
{
“record” : “name”,
“thing 2” : “9”
}
What I need instead is an array of records in JSON like this:
record : [
{“thing 1” : “5”}.
{“thing 2” : “9”}
]
Any suggestions?
How are you able to process the data? Can you manipulate it with Javascript, for example?