Sidebar

Can i sort a json array?

0 votes
150 views
asked Oct 3, 2023 by brandon-w-8204 (33,270 points)
I have a JSON array i want to sort

1 Answer

0 votes

Here is some sample code that would sort providers based on a date in the JSON structure:

var currentTimes = [];
var c;
var x;
var sortingCompleted = false;
var timePlaceholder;
var jsonPlaceholder;

function providerSort(a, b){
   var retVal;
   
   if (a.startTime < b.startTime) {
      retVal = -1;
   } else if (a.startTime > b.startTime) {
      retVal =  1;
   } else {
      retVal =  0;
   }
   
   return retVal;
}

var providers = [];
var providersAsStrings = source.getAllNodes('/providers/[]');
for (var j = 0; j < providersAsStrings.length; j++){
   providers.push(JSON.parse(providersAsStrings[j]));
}
providers.sort(providerSort);
for (var i = 0; i < providers.length; i++) {
   message.setJSONObject('/providers/[' + (i+1) + ']', providers[i]);
}

answered Oct 3, 2023 by brandon-w-8204 (33,270 points)
...