Order the keys in a JSONArray

Question

Order the keys in a JSONArray

My json Array structure is as follows:

[
    {
        "pos1": "Batterie de préchauffage",
        "attributes": [
            {
                "disconnect": "false",
                "disconnectBis": "false"
            }
        ]
    },
    {
        "pos4": "Batterie haute température",
        "attributes": [
            {
                "test": "true",
                "testBis": "false"
            }
        ]
    },
    {
        "pos3": "free"
    },
    {
        "pos2": "free"
    }
]

I am looking to rearrange my json data to achieve the following format:

[
    {
        "pos1": "Batterie de préchauffage",
        "attributes": [
            {
                "disconnect": "false",
                "disconnectBis": "false"
            }
        ]
    },
    {
        "pos2": "Batterie haute température",
        "attributes": [
            {
                "test": "true",
                "testBis": "false"
            }
        ]
    },
    {
        "pos3": "free"
    },
    {
        "pos4": "free"
    }
]

I need to ensure that the 'pos' values are in progressive order.

I hope someone can understand my issue and provide guidance on how I can resolve this problem. I have searched extensively but haven't found a solution specific to my situation.

Thank you for your help!

javascript json

Answer 1

Answer №1

Arriving a bit fashionably late, it seems the existing answers may not be giving you the desired output. What you're looking for is to maintain the current array order and update the current pos[num] property of the object in the array with 'pos' + (idx + 1):

const input = [ { "pos1": "Batterie de préchauffage", "attributes": [ { "disconnect": "false", "disconnectBis": "false" } ] }, { "pos4": "Batterie haute température", "attributes": [ { "test": "true", "testBis": "false" } ] }, { "pos3": "free" }, { "pos2": "free" } ]

const output = input.map((o, idx) => {
  const id = Object.keys(o).find(id => /^pos/.test(id));
  if (id !== `pos${idx + 1}`) {
    o[`pos${idx + 1}`] = o[id];
    delete o[id];
  }
  return o;
});

console.log(output)

Answer 2

Arriving a bit fashionably late, it seems the existing answers may not be giving you the desired output. What you're looking for is to maintain the current array order and update the current pos[num] property of the object in the array with 'pos' + (idx + 1):

const input = [ { "pos1": "Batterie de préchauffage", "attributes": [ { "disconnect": "false", "disconnectBis": "false" } ] }, { "pos4": "Batterie haute température", "attributes": [ { "test": "true", "testBis": "false" } ] }, { "pos3": "free" }, { "pos2": "free" } ]

const output = input.map((o, idx) => {
  const id = Object.keys(o).find(id => /^pos/.test(id));
  if (id !== `pos${idx + 1}`) {
    o[`pos${idx + 1}`] = o[id];
    delete o[id];
  }
  return o;
});

console.log(output)

Answer 3

Answer №2

To organize the objects based on their first property, a simple solution like the one below can be used:

var array = [
    {
        "pos1": "Batterie de préchauffage",
        "attributes": [
            {
                "disconnect": "false",
                "disconnectBis": "false"
            }
        ]
    },
    {
        "pos4": "Batterie haute température",
        "attributes": [
            {
                "test": "true",
                "testBis": "false"
            }
        ]
    },
    {
        "pos3": "free"
    },
    {
        "pos2": "free"
    }
];

var sortedArray = array.sort((a, b) => {
    var nameKeyA = Object.keys(a)[0];
    var nameKeyB = Object.keys(b)[0];
    return nameKeyA > nameKeyB;
});

console.log(JSON.stringify(sortedArray));

Answer 4

To organize the objects based on their first property, a simple solution like the one below can be used:

var array = [
    {
        "pos1": "Batterie de préchauffage",
        "attributes": [
            {
                "disconnect": "false",
                "disconnectBis": "false"
            }
        ]
    },
    {
        "pos4": "Batterie haute température",
        "attributes": [
            {
                "test": "true",
                "testBis": "false"
            }
        ]
    },
    {
        "pos3": "free"
    },
    {
        "pos2": "free"
    }
];

var sortedArray = array.sort((a, b) => {
    var nameKeyA = Object.keys(a)[0];
    var nameKeyB = Object.keys(b)[0];
    return nameKeyA > nameKeyB;
});

console.log(JSON.stringify(sortedArray));

Answer 5

Answer №3

Utilizing the JavaScript methods and syntax outlined below will yield the desired output:

const json = '[{"pos1":"Batterie de préchauffage","attributes":[{"disconnect":"false","disconnectBis":"false"}]},{"pos4":"Batterie haute température","attributes":[{"test":"true","testBis":"false"}]},{"pos3":"free"},{"pos2":"free"}]';

// Parse the JSON
const arr = JSON.parse(json);

// `map` over the array, grabbing the object and index
const out = arr.map((obj, i) => {

  // Iterate over the keys from each object
  Object.keys(obj).forEach(key => {

    // If a key includes the substring "pos"...
    if (key.includes('pos')) {

      // ...and the new key number doesn't match the current index...
      if (key !== `pos${i + 1}`) {

        // ...copy it to a new key (starting at pos1)...
        obj[`pos${i + 1}`] = obj[key];

        // ...then delete the old key
        delete obj[key];

      }
    }
  });

  // Return the updated object 
  return obj;
});

console.log(out);

Answer 6

Utilizing the JavaScript methods and syntax outlined below will yield the desired output:

const json = '[{"pos1":"Batterie de préchauffage","attributes":[{"disconnect":"false","disconnectBis":"false"}]},{"pos4":"Batterie haute température","attributes":[{"test":"true","testBis":"false"}]},{"pos3":"free"},{"pos2":"free"}]';

// Parse the JSON
const arr = JSON.parse(json);

// `map` over the array, grabbing the object and index
const out = arr.map((obj, i) => {

  // Iterate over the keys from each object
  Object.keys(obj).forEach(key => {

    // If a key includes the substring "pos"...
    if (key.includes('pos')) {

      // ...and the new key number doesn't match the current index...
      if (key !== `pos${i + 1}`) {

        // ...copy it to a new key (starting at pos1)...
        obj[`pos${i + 1}`] = obj[key];

        // ...then delete the old key
        delete obj[key];

      }
    }
  });

  // Return the updated object 
  return obj;
});

console.log(out);

Answer 7

Answer №4

If the pattern of names follows pos[num], then this solution will be effective.

let data = [
    {
        "pos1": "Preheating battery",
        "attributes": [
            {
                "disconnect": "false",
                "disconnectBis": "false"
            }
        ]
    },
    {
        "pos4": "High-temperature battery",
        "attributes": [
            {
                "test": "true",
                "testBis": "false"
            }
        ]
    },
    {
        "pos3": "free"
    },
    {
        "pos2": "free"
    }
];

const sortPredicate = (a, b) => {
  
  let aProp = parseInt(Object.getOwnPropertyNames(a)[0].substring(3));
  let bProp = parseInt(Object.getOwnPropertyNames(b)[0].substring(3));

  return  aProp - bProp;
}

let sortedData = data.sort(sortPredicate);

console.log(sortedData);

Answer 8

If the pattern of names follows pos[num], then this solution will be effective.

let data = [
    {
        "pos1": "Preheating battery",
        "attributes": [
            {
                "disconnect": "false",
                "disconnectBis": "false"
            }
        ]
    },
    {
        "pos4": "High-temperature battery",
        "attributes": [
            {
                "test": "true",
                "testBis": "false"
            }
        ]
    },
    {
        "pos3": "free"
    },
    {
        "pos2": "free"
    }
];

const sortPredicate = (a, b) => {
  
  let aProp = parseInt(Object.getOwnPropertyNames(a)[0].substring(3));
  let bProp = parseInt(Object.getOwnPropertyNames(b)[0].substring(3));

  return  aProp - bProp;
}

let sortedData = data.sort(sortPredicate);

console.log(sortedData);

Answer 9

Answer №5

let arr = [
    {
        "key1": "Value 1",
        "attributes": [
            {
                "flag1": "true",
                "flag2": "false"
            }
        ]
    },
    {
        "key4": "Value 4",
        "attributes": [
            {
                "check": "true",
                "checkBis": "false"
            }
        ]
    },
    {
        "key3": "free"
    },
    {
        "key2": "free"
    }
];

function getKey(obj) {
  const firstMatch = Object.keys(obj).find(k => /key[0-9]+/.test(k));
  return firstMatch;
}

const ordered_keys = arr.map(o => getKey(o)).sort();
arr = arr.map((o, idx) => {
  const k = getKey(o);
  if(k && ordered_keys[idx] && k !== ordered_keys[idx]) {
    o[ordered_keys[idx]] = JSON.parse(JSON.stringify(o[k]));
    delete o[k];
  }
  return o;
});

console.log(JSON.stringify(arr, null, 2));

Answer 10

let arr = [
    {
        "key1": "Value 1",
        "attributes": [
            {
                "flag1": "true",
                "flag2": "false"
            }
        ]
    },
    {
        "key4": "Value 4",
        "attributes": [
            {
                "check": "true",
                "checkBis": "false"
            }
        ]
    },
    {
        "key3": "free"
    },
    {
        "key2": "free"
    }
];

function getKey(obj) {
  const firstMatch = Object.keys(obj).find(k => /key[0-9]+/.test(k));
  return firstMatch;
}

const ordered_keys = arr.map(o => getKey(o)).sort();
arr = arr.map((o, idx) => {
  const k = getKey(o);
  if(k && ordered_keys[idx] && k !== ordered_keys[idx]) {
    o[ordered_keys[idx]] = JSON.parse(JSON.stringify(o[k]));
    delete o[k];
  }
  return o;
});

console.log(JSON.stringify(arr, null, 2));

Order the keys in a JSONArray

Answer №1

Answer №2

Answer №3

Answer №4

Answer №5

Similar questions

Highchart: precise positioning of ticks on axis

Error Encountered When Updating cGridView in Yii: "TypeError: $.fn.yiiGridView is undefined"

What causes my XMLHttpRequest to be terminated prematurely?

Redux accesses the store data after a brief delay

Bring in 2 Angular applications into a different JavaScript project

JavaScript Bingo Game - Create Interactive Cell Selection

Mapping a list of objects from my model to a JavaScript variable for populating fullcalendar events

When trying to parse a non-alphanumeric string using Number.parseInt, the resulting type will be 'number'

Customizing the step function of HTML5 input number with jQuery: A guide

How can I retrieve the identical fingerprint used by AWS from x.509 using node-forge?

The value of the variable remains consistent throughout the .each function when using JQuery's .post() method

Loop through the JSON array and append every value to the list within AngularJS

In Typescript, what is a function that can return multiple types separated by commas known as?

What is the best way to transform a nested EJS foreach loop into a HBS foreach loop?

What could be the reason for my post jQuery Ajax request sending JSON data?

Is there a way to align a button in the center of the browser's footer?

Ionic 2: Inconsistency detected in the expression after it was verified

Must run the angular code in a sequential order

Retrieving input data when utilizing ng-file-upload

Extracting and retrieving the value from the paramMap in Angular/JavaScript