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?

Rookie Asked on July 7, 2023 in Saved Searches.
Add Comment
1 Answer(s)

How are you able to process the data? Can you manipulate it with Javascript, for example?

Intermediate Answered on July 10, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor