How to sort a large array of line items (with Zapier Storage + Code?)

We resolve this by asking ChatGPT + the Zapier docs. It should be much easier to handle arrays!

1. Create a temporary delimiter between values
2. Converting the input (Zapier Code data input is always a string, so need to convert to an array)
3. Run a comparison function of unique values
4. Write back values to map into our onward tool.

let stringSet = inputData.Playbooks;

console.log(stringSet) // Show the ugly string.

let Set = stringSet.split('|||'); // Split out by the temporary delimiter

console.log(Set); // Show the array that's fetched

console.log(Array.isArray(Set)) // Evaluates to true

// Suspect each line is one long string still.
console.log(Number.isInteger(Set.score)); // Evaluates to false

// JSON.parse() was causing problems. GPT alternative suggestion to turn string into an array.
let parsedSet = Set.map(str => {
  let obj = {};
  str = str.replace(/,$/, '');
  let keyValuePairs = str.match(/(\w+):("[^"]+"|\w+)/g);
  keyValuePairs.forEach(pair => {
    let [key, value] = pair.split(':');
    key = key.trim();
    value = value.trim();
    obj[key] = value.match(/^".*"$/) ? value.slice(1, -1) : Number(value);
  });
  return obj;
});

console.log(parsedSet);


// Make sure we're only evaluating unique slugs to avoid duplicate entries
let uniqueSet = [];
let slugMap = {};

for (let item of parsedSet) {
    if (!slugMap[item.slug]) {
        slugMap[item.slug] = true;
        uniqueSet.push(item);
    }
}

let sortedSet = uniqueSet.sort((a, b) => b.score - a.score); // Sort the unique set by score

console.log(sortedSet); // Show the output of the whole set.

let sortedSlugs = sortedSet.map(item => item.slug);

console.log(sortedSlugs);

output = { sortedSlugs, sortedSet }; // Write the output back to the Zap